
Azure Data Factory Cookbook
By :

In this recipe, you will learn how to leverage a serverless SQL pool in an Azure Synapse workspace to analyze data in your data lake.
You need to have access to an Azure Synapse workspace. You should also have a file in Parquet format stored in your Azure Synapse storage account. If you do not have one, refer to the Copying data in Azure Synapse Integrate recipe to create it.
Open your Azure Synapse workspace, go to the Data tab, then Linked, and open the folder that contains the Parquet format file:
Figure 3.53: Creating a new SQL script for a file in a storage account
A new script is created for connecting to the file using a serverless SQL pool. Run it to see the first 100 rows of your Customer table.
Figure 3.54: Connecting to the file from the Synapse workspace...