Exporting data with client tools
Data export with client tools is the ability to perform client-side exports through the tool you are using to query your Data Explorer pools. In this book, our tool of choice has been Azure Synapse Studio, so let’s use it in our example. Whenever you perform any queries in Azure Synapse Studio, regardless of whether it is a SQL query or a KQL query, you will see the Export results button above your query results, as illustrated in Figure 9.1. This allows you to immediately export the results of this query to a file that will be downloaded to your local machine. The supported file formats here are comma-separated values (CSV) files, JavaScript Object Notation (JSON) files, or Extensible Markup Language (XML) files.
Figure 9.1 – Exporting query results
Most business intelligence and data management client tools in the industry, if not all, offer a similar capability to this, allowing you to save the results...