Chapter 3: Analyzing Data with Azure Synapse Analytics
Azure Synapse Analytics, formerly known as SQL Data Warehouse, combines data warehousing and big data analytics to provide a unified experience to extract, load, and transform data. Azure Synapse has the following features—Synapse SQL – T-SQL-based analytics (SQL pools and SQL on-demand), Spark Analytics, Synapse pipelines, and Synapse studio. At the time of writing this book, all features except Synapse SQL are in preview.
Azure Synapse Analytics is important to learn as data warehousing is an important part of data engineering and big data solutions.
Azure Synapse SQL can be used to quickly load data from sources and perform transformations. The transformation queries are fast as Azure Synapse SQL uses massive parallel processing (MPP) architecture to process the queries.
In this chapter, we'll cover the following recipes:
- Provisioning and connecting to an Azure Synapse SQL pool using PowerShell...