Configuring continuous data export
All three data export mechanisms that we have explored so far with server-side data push are quite similar in syntax and in how they operate. They require someone to start the actual data export task, monitor it, and implement the logic to copy new data in the future. There is, however, one important advantage of exporting data to external tables: the possibility to use continuous data export to keep your external table updated as new records are inserted in the original table.
We’ll continue to build on the table created in the Exporting to external tables section. We did the initial data load and now we would like to set up a process that updates the content of the external table with new records inserted in the fleet data table every two hours. Continuous data export allows you to configure this process, ensuring that each record in your table is processed exactly once.
Here’s the syntax to create a new continuous data export...