Summary
In this chapter, you learned why you should care about data export scenarios and how they may be useful for you in real life. You’ve learned how to perform some basic data export work by using Azure Synapse Studio.
You then continued to learn about using server-side exports for a more robust data export experience. We looked at examples of how to export data using a pull approach, where we created a new table that pulls the result from a query to load data into it. Next, you exported data using server-side mechanisms that leverage the .export
command to push data to cloud storage, SQL tables, and external tables in Data Explorer pools.
To close, you learned about configuring continuous data export jobs that, once configured, maintain an external table in sync with a source table by running recurrently at a pre-defined interval. We looked at how we can check the details of the job to see its status and how we can disable and enable the job again if needed.
This...