Edit on GitHub
Azure Synapselink
Azure Synapse is an enterprise-scale cloud data warehouse. Synapse is a petabyte-scale data warehouse because it separates compute and storage. Compute nodes use the SQL Server database engine and data is stored in Azure Blob Storage. (Azure Synapse was formerly known as Azure SQL Data Warehouse.)
IMPORTANT: Fivetran does not support Azure Synapse Serverless.
Setup guidelink
Follow our step-by-step Azure Synapse setup guide to connect your Azure Synapse data warehouse with Fivetran.
Type transformation and mappinglink
The data types in your Azure Synapse data warehouse follow Fivetran's standard data type storage.
We use the following data type conversions:
| Fivetran Data Type | Destination Data Type |
|---|---|
| BOOLEAN | BIT |
| SHORT | SMALLINT |
| INT | INTEGER |
| LONG | BIGINT |
| BIGDECIMAL | DECIMAL |
| FLOAT | REAL |
| DOUBLE | DOUBLEPRECISION |
| LOCALDATE | DATE |
| LOCALDATETIME | DATETIME2 |
| INSTANT | DATETIMEOFFSET |
| STRING | NVARCHAR |
| JSON | NVARCHAR |
| BINARY | VARBINARY |
Data load costslink
Azure Synapse does not charge you extra when Fivetran loads data into your data warehouse.