As of March 13, 2017, Stitch supports replication for the following data types:
| Data Type | Supported For |
|---|---|
ARRAY
|
PostgreSQL Integrations |
BIGINT
|
All Integrations |
BIT
|
All Integrations |
CHAR
|
All Integrations |
DATE
|
All Integrations |
DECIMAL
|
All Integrations |
DOUBLE
|
All Integrations |
FLOAT
|
All Integrations |
HSTORE
|
PostgreSQL Integrations |
INTEGER
|
All Integrations |
JSON
|
PostgreSQL Integrations |
JSONB
|
PostgreSQL Integrations |
LONGVARCHAR
|
All Integrations |
LONGNVARCHAR
|
All Integrations |
NCHAR
|
All Integrations |
NVARCHAR
|
All Integrations |
NUMERIC
|
All Integrations |
REAL
|
All Integrations |
SMALLINT
|
All Integrations |
TIME
|
All Integrations |
TIMESTAMP
|
All Integrations |
TINYINT
|
All Integrations |
UUID
|
PostgreSQL Integrations |
VARBINARY
|
All Integrations |
VARCHAR
|
All Integrations |
‘Not Supported’ Columns
If a column you want to sync has a Status of Not Supported, the root cause may be an unsupported data type or insufficient user permissions.
BigQuery & Mixed Data Types
Even though the data types listed above are supported by BigQuery, multiple data types in the same column are not.
BigQuery only supports one combination of mixed data types: if a column contains anything other than FLOAT and INTEGER data types, BigQuery will reject the entire batch of data.
Some integrations are incompatible with BigQuery as a result of this.
| Related | Troubleshooting |
Questions? Feedback?
Did this article help? If you have questions or feedback, please reach out to us.