If a table isn’t replicating into your data warehouse, it may be because one or more of the columns in the table contains an unsupported data type. It’s possible that an unsupported data type can keep an entire table from replicating.
Supported 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 |
Next Steps
To allow Stitch to successfully replicate the table you’ll need to deselect any columns with unsupported data types. This will prevent Stitch from attempting to sync them, thus allowing the table to replicate as it should.
Questions? Feedback?
Did this article help? If you have questions or feedback, please reach out to us.