Error: Cannot Select - Exclude Tables: Tables Contains Unsupported Primary Key

Issue

While trying to include a table in the connection schema, the following error appears:

Cannot select - Exclude tables: Table contains unsupported primary key

Environment

• Connector: Oracle
• Sync method: Fivetran Teleport Sync

Resolution

To resolve this issue, ensure your table's primary key is defined with one of the following data types supported by Fivetran Teleport Sync for Oracle:

• DATE
• NUMBER

  NOTE: INTEGER only; i.e., NUMBER(p) or NUMBER(p,0)

• RAW
• VARCHAR
• VARCHAR2

For more information, see our Fivetran Teleport Sync for Oracle documentation.

Cause

This issue occurs when your table's primary key is defined with a data type that isn't supported by Fivetran Teleport Sync for Oracle.