Analyzing data using serverless SQL pool
Serverless SQL pool allows us to explore data using T-SQL commands in a Synapse Analytics workspace. The key advantage of serverless SQL pool is that it is available by default once a Synapse Analytics workspace is provisioned with no cluster or additional resources to be created. In serverless SQL pool, you will be charged only for the data processed by the queries as it is designed as a pure pay-per-use model.
Getting ready
Create a Synapse Analytics workspace, as explained in the Provisioning an Azure Synapse Analytics workspace recipe of this chapter.
How to do it…
In this recipe, we will perform the following:
- Uploading sample data into a Synapse Analytics workspace data lake account and querying it using serverless SQL pool
- Creating a serverless SQL database and defining a view to read the data stored in the data lake account
The detailed steps to perform these tasks are as follows:
- Log...
