Error: Cannot Select - Fivetran Teleport Sync Does Not Yet Support Syncing This Table

Issue

While selecting tables to sync in the Schema tab, some tables are unavailable and display the following error:

Error: Cannot Select - Fivetran Teleport Sync Does Not Yet Support Syncing This Table, the User Does Not Have Temporary Table Privileges for This Table's Schema.

Environment

• Connector: MySQL
• Incremental sync method: Fivetran Teleport Sync

Resolution

To resolve this issue, grant the CREATE TEMPORARY TABLES privilege to the database user Fivetran uses to connect to your MySQL database. Run the following command:

GRANT CREATE TEMPORARY TABLES ON <database_name>.* TO '<username>'@'%';

After granting the privilege, return to the Schema tab in Fivetran and click the the Refresh button (Update latest schema from source).

Cause

This issue occurs when we try to sync a table without a primary key using Fivetran Teleport Sync, but the database user does not have the CREATE TEMPORARY TABLES privilege.

For tables without a primary key, we create a temporary table on the MySQL source server. This temporary table includes a generated primary key column, _fivetran_id, which we derive from the values of the other columns in each row and used to sync the data to the destination. After the sync completes, we drop the temporary table.

This process requires creating temporary tables, so the database user must have the CREATE TEMPORARY TABLES privilege.