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 requirements
Please make sure the following items are true before getting setup or make sure you have the permissions and ability to configure the following before going through the setup process:
- Azure Synapse
- Ability to create a user for Fivetran
- Ability to add/change resource classes for user
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.