Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

'Not Supported' Errors for Database Integration Tables

Does a table in your database integration have a Sync Status of Unsupported? Depending on the type of database, the solution can vary.

MySQL 'Not Supported' Table Messages

A Sync Status of Unsupported for a MysQL table usually means that the table is in a format unsupported by Stitch. Currently, Stitch only supports replicating from InnoDB tables.

To troubleshoot, start by confirming the table type. If it's in an unsupported format like MyISAM, you'll need to convert the table to InnoDB format to allow Stitch to replicate it.

Performing the conversion requires tech expertise and familiarity with MySQL, so we recommend looping in a database admin or another member of your tech team to help out.

After you successfully convert the table to InnoDB format and a full replication cycle has completed, the table's Sync Status should change to Supported and be available for syncing.

PostgreSQL 'Not Supported' Table Messages

If you see that a PostgreSQL table has a status of Unsupported, the credentials being used to connect to the database may not have access.

To troubleshoot, verify that the user has access to the table; if need be, grant the appropriate permissions. You can refer to the Connecting PostgreSQL article for detailed info on the required permissions.

After you grant the required permissions and a full replication cycle has completed, the table's Sync Status should change to Supported and be available for syncing.

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!