Azure Synapse
Azure Synapse is an enterprise-scale cloud warehouse. It is peta-byte scale because it separates compute and storage. Compute nodes use the SQL Server database engine & data is stored in Azure Blob Storage. (Azure Synapse was formerly known as Azure SQL Data Warehouse.)
Setup guide
Follow our step-by-step Azure Synapse setup guide to connect your Azure Synapse destination with Fivetran.
Type transformation and mapping
The data types in your Azure Synapse 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 |
| FLOAT | REAL |
| DOUBLE | DOUBLEPRECISION |
| BIGDECIMAL | DECIMAL |
| LOCALDATE | DATE |
| INSTANT | DATETIMEOFFSET |
| LOCALDATETIME | DATETIME2 |
| STRING | NVARCHAR |
| JSON | NVARCHAR |
| BINARY | VARBINARY |
Data load costs
Azure Synapse does not charge you extra when Fivetran loads data into your warehouse.