Loading data to Azure Synapse Analytics using Azure Data Studio
Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux. Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal. It’s engineered with the data platform user in mind, with the built-in charting of query result sets and customizable dashboards.
In this recipe, we are going to configure Azure Data Studio and load data into Azure Synapse Analytics from an external resource.
Getting ready
You need to have Azure Data Studio installed on your computer.
You need to upload the dataset from this book’s GitHub repository to the container. Then, you need to generate shared access signatures to connect blobs via Azure Synapse Analytics.
You can download the dataset from the book’s GitHub repository, or you can use...