Missing Tables or Columns
Issue
Tables or columns in the Connector SDK source are missing from the destination.
Environment
Connector: Connector SDK
Resolution
If the columns you want to sync do not contain data, you must declare the missing column(s) using the schema() method. We create tables and columns in your destination for any column declared using the Schema() method, even if no data is sent for that column.
If the column(s) do contain data, contact our support team.
We recommend using the schema() method only to declare missing columns or define data types when necessary. For columns that contain data, Fivetran infers data types based on the values you send. For more information, see our documentation on data type inference.
Examples: Using the schema() method
Our Connector SDK GitHub repository includes examples that show how to declare tables, columns, and data types using the schema() method in different scenarios:
- Declare a schema for a single table
- Declare schemas for multiple tables in one connector
- Define a table with multiple primary keys
- Explicitly define column data types in a schema
Cause
Fivetran creates empty tables and columns in your destination only when they are defined using the optional schema() method. This issue occurs when tables or columns contain no data and haven't been declared.