If a table isn’t replicating into your destination, it may be because one or more of the columns in the table contains an unsupported data type. An unsupported data type may keep an entire table from replicating successfully.
Supported data types
The data types Stitch supports for replication fall into two categories:
- Common, which are data types supported for all integrations
- Integration-specific, which are data types supported for specific integrations and integration versions, where applicable. Note: Common data types also apply to integrations that support integration-specific data types.
Note: If a data type isn’t present in either the Common or Integration-specific tables, it means that Stitch doesn’t currently support replication for that data type. Replicating columns with unsupported data types may lead to issues with replication.
As of June 19, 2018, the data types in the table below are supported for all integrations.
| BIGINT | BIT | CHAR | DATE |
| DECIMAL | DOUBLE | FLOAT | INTEGER |
| LONGVARCHAR | LONGNVARCHAR | NCHAR | NVARCHAR |
| NUMERIC | REAL | SMALLINT | TIME |
| TIMESTAMP | TINYINT | VARCHAR |
The integrations listed below also have data types that are specific to them. Click the links for more info, including the level of support Stitch offers and the Stitch data type it will map to.
Next steps
To allow Stitch to successfully replicate the table you’ll need to de-select any columns with unsupported data types. This will prevent Stitch from attempting to replicate them, thus allowing the table to replicate as it should.
Questions? Feedback?
Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.