Azure Synapse

Azure Synapse

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:

---

• Synapse snack: mount storage container in notebook (2024-12-07)
• Synapse - Execute pipeline after deployment (2024-10-29)
• Synapse - Invalid notebook reference (2024-10-01)
• Synapse - Run all notebooks in a foreach loop (2024-09-22)
• Synapse - ReferenceError: Response is not defined (2024-09-21)
• Toggle Azure Synapse Triggers during deployment (2024-01-01)
• Give Power BI access to Synapse Serverless SQL Pool (2023-12-26)
• Deploying Synapse Serverless SQL pool with DevOps (2023-12-24)
• Review Synapse notebooks with your GPT model (2023-10-24)
• Synapse and ADF Pipeline snack - Disable Activity (2023-06-28)
• Synapse - Automatically check naming conventions (2023-05-05)
• Synapse snack - Increment counter variable (2023-04-05)
• Synapse - Cleanup workspace after deployment (2023-04-01)
• Synapse - Change Data Feed (CDF) on delta tables (2023-03-26)
• Synapse - Creating Silver Delta Tables (2023-03-20)
• Synapse - Using Spark SQL to time travel Delta Tables (2023-03-19)
• Synapse - Add existing Delta Table to Lake Database (2023-03-19)
• Synapse snack - Get child pipeline value to parent (2023-03-05)
• Show dataset parameters in Azure Synapse Dataflow (2023-02-13)
• Cleanup Synapse before deployment (2022-12-31)
• Create Data Lake containers and folders via DevOps (2022-11-07)
• Deploy Synapse workspaces via DevOps - Pipeline (2022-10-03)
• Deploy Synapse workspaces via DevOps - Setup (2022-10-03)
• Synapse - error: missing required argument 'factoryId' (2022-10-02)
• Synapse - 'node' is not recognized as an command (2022-09-30)
• Skipped dependency between pipeline activities (2022-07-31)
• Break or stop ForEach loop in ADF and Synapse (2022-06-08)
• ADF Snack: Trigger every hour during office hours (2022-06-02)
• Refresh single table in PBI Dataset from within ETL (2022-05-19)
• Refresh Power BI Datasets via its name instead of Id (2022-05-08)
• Refresh Power BI Datasets with ADF or Synapse (MSI) (2022-04-30)
• Refresh Power BI Datasets with ADF or Synapse (SP) (2022-03-21)
• ADF Snack - Script Activity (2022-03-14)
• 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)
• Synapse snack: No new Azure SQL Database allowed (2020-10-15)
• Pause all/an Azure Synapse SQL Pool(s) (Az) (2020-10-02)
• Use Managed Service Identity for Synapse PolyBase (2020-05-03)