Stairway to Synapse Analytics

This Stairway examines the architecture and structure of using Azure Synapse Analytics as a data warehousing platform.

• Level 1 of the Stairway to Synapse Analytics - Create a Synapse Workspace

  In this first level of the Stairway to Synapse Analytics, we learn how to set up a new workspace and add data files.

• Level 2 of the Stairway to Synapse Analytics: Analyze Data in Storage Account using the Serverless SQL pool

  In this second level of the Stairway to Synapse, we learn how to create external tables and query data that is stored in our data storage using the serverless pool.

• Level 3 of the Stairway to Synapse Analytics: Analyze Data Using a Spark Pool

  Introduction In Level 1 of this series, I discussed Synapse Analytics basics and the steps for creation of the Synapse Workspace. In Level 2, data analysis was done on Data Lake files using Serverless SQL Pool. In Level 3, I will analyze data from the files uploaded in Data Lake container using a Spark Pool. I will […]

• Level 4 of the Stairway to Synapse Analytics: Create and Use a Delta Lake

  Introduction In Level 1 of this series, I discussed Synapse Analytics basics and the steps for creating the Synapse Workspace. In Level 2, we analyzed Data Lake files using the Serverless SQL Pool. In Level 3, we analyzed Data Lake files using the Spark Pool. In Levels 4 and level 5, I will discuss the Delta […]