Using SQL on-demand

In this recipe, you will learn how to use SQL on-demand in an Azure Synapse workspace.

Getting ready

You need to have an Azure Synapse workspace created and the file in Parquet format kept in your Azure Synapse storage account.

How to do it…

1. Open the Azure Synapse workspace, go to Data, and open the folder that contents the Parquet format file.
2. Right-click on the file and choose New SQL script | Select TOP 100 rows:

   Figure 3.37 – Creating a new SQL script for a file in a storage account

   A new script is created for connecting to the file using SQL on-demand:

   Figure 3.38 – Connecting to the file from the Synapse workspace using SQL on-demand

   Note

   The query executes within several seconds; you don't need to wait several minutes for the cluster to start. You can copy this script and then paste it into SSMS.

3. You can also use SQL on-demand to connect from SSMS or a visualization tool (such as Power BI or Tableau). For this...