Destinations
You must connect a destination to Fivetran so that our connectors can sync data into it from your sources. Fivetran supports cloud data warehouses, databases, online data platforms, and data lakes as destinations.
Destinations were previously called "warehouses" in our documentation because we originally only supported data warehouses as destinations.
Supported destinations
Fivetran supports the following destinations:
- Apache Kafka
- Azure Synapse
- BigQuery
- ClickHouse Cloud Partner-Built
- Convex Partner-Built In Dev
- Databricks
- Managed Data Lake Service
- Materialize Partner-Built Private Preview
- MilvusPartner-Built Private Preview
- MotherDuck Partner-Built
- MySQL Beta
- Oracle Beta
- PostgreSQL
- Redshift
- SingleStore Partner-Built Beta
- Snowflake
- SurrealDB Partner-Built Beta
- SQL Server
- Teradata Vantage Partner-Built Private Preview
Let us know if there is a destination that you would like, but that is not yet supported.
Unsupported scenarios
Our load queries are designed to ingest data into your destination as efficiently as possible. However, it is not always possible to load large datasets into row stores like PostgreSQL and MySQL that were designed as operational data stores. If your database is unable to execute our load queries due to data size, you will need to switch to a horizontally scalable column store like Snowflake, Redshift, BigQuery, or Azure Synapse.
Also, we do not support configuring multiple connectors to the same destination table as it can lead to sync failures.
Data types
All destinations contain data in the following types. We may need to convert a few data types to a type accepted by your destination. You can find information about the conversions on the individual destination pages.
| Data Type |
|---|
| BOOLEAN |
| SHORT |
| INT |
| LONG |
| BIGDECIMAL |
| FLOAT |
| DOUBLE |
| LOCALDATE |
| LOCALDATETIME |
| INSTANT |
| STRING |
| XML |
| JSON |
| BINARY |
For more information about data types, see our Data types documentation.