Azure Synapse Analytics

Azure SQL Data Warehosue

What is Azure Synapse Analytics? It's formally know as Azure SQL Data Warehouse and it is an Azure database specially made for Online Analytical Processing (OLAP). It is capable of massively parallel processing (MPP) to quickly process large sets of data into your data warehouse.

In short, it is an database suited for large data warehouses in the cloud. For more details read this post or the ones below here.

Azure Synapse Analytics posts:

---

• Delta Lake support in Azure Synapse Analytics (2021-12-05)
• Synapse pipeline pass parameter to notebook (2021-11-27)
• Pausing/resuming Dedicated SQL Pools from Synapse (2021-03-01)
• Scaling Azure Dedicated SQL Pools from ADF (2021-01-11)
• Pausing and resuming Dedicated SQL Pools from ADF (2021-01-06)
• Pause all/an Azure Synapse SQL Pool(s) (Az) (2020-10-02)
• Use Managed Service Identity for Synapse PolyBase (2020-05-03)
• Schedule Up/Downscale Azure SQL Database (API) (2020-02-02)
• Schedule Up/Downscale Azure SQL Database (TSQL) (2020-02-01)
• Schedule Up/Downscale Azure SQL Database (Az) (2020-01-31)
• Pause everything on your Azure playground - Tags (2018-01-01)
• Pause everything on your Azure playground (2017-12-30)
• CTAS - The fastest way to load data on a MPP system (2017-11-20)
• Use PolyBase to read Data Lake in Azure SQL DW (2017-10-23)
• Use PolyBase to read Blob Storage in Azure SQL DW (2017-08-20)
• Azure SQL Database vs Azure SQL Data Warehouse (2017-07-30)
• Schedule Pause/Resume of Azure Data Warehouse (2017-04-17)
• Schedule Upscale/downscale Azure SQL DB(/DWH) (2017-04-11)