Azure Synapse

Previously SQL Data Warehouse (SQL DW), Azure Synapspe is the petabyte scale analytical compute warehousing solution from Microsoft. Synapse is an enterprise analytics service that accelerates time to insight across data warehouses and big data systems by separating compute from storage. Azure Synapse brings together the best of SQL technologies used in enterprise data warehousing, Spark technologies used for big data, Data Explorer for log and time series analytics, Pipelines for data integration and ETL/ELT, and deep integration with other Azure services such as Power BI, CosmosDB, and AzureML.

DLH.io synchronizes data to Synapse from 100+ connectors and integrations better than other platforms because we're experts in Azure and SQL Server technology.

Currently DLH.io does not support loading of data/events into Azure Synapse Serverless. As of 2022 the main reason for this continues to be that the base storage foundation of Azure Synapse is Azure Blob and/or Azure Data Lake storage. Azure Synapse Serverless simply reads from the storage blob directly. The other magic behind DLH.io for loading data is for handling CDC, etc. Because Synapse Serverless requires the dynamic table or view concept over the storage layer, even though DLH.io could do this, the use case for Synapse is to use a dedicated SQL pool (previously known as a SQL Data Warehouse).

Currently DLH.io supports CSV loading to your Azure Synapse target. Parquet and AVRO are potentially supported (please contact support for more information, if required).

Azure Synapse does not costs extra when loading data from DLH.io, meaning that Azure does not charge your account any additional amount for using DLH.io just because it is more efficient and a better option than native Microsoft Azure integration concepts.