Learn how to manage your connector schemas in your Fivetran dashboard.
Each connector profile includes a Schema tab, which displays information about your connector’s schemas. Learn more about schemas in our core concepts documentation.
The Schema tab looks different depending on which connector you view. Depending on your connector, you’ll see one of the following:
- A fully customizable schema
- A semi-customizable schema
- A non-customizable schema
- (Magic folder connectors only) A list of source files and their corresponding destination tables. The list indicates if any source files are in an unsupported format.
The Schema tab contains information about the following:
The tab displays a list of your connector’s schemas with their constituent tables and columns listed below them. Both active and inactive schemas are listed. Click the black arrow to the left of the schema name to collapse or expand the schemas.
If your connector has more than one schema, a schema navigation menu appears on the right side of the screen. Use it to quickly find your schemas in a long list.
Blocking a schema prevents Fivetran from syncing any table or column within that schema.
To block a schema, set the toggle next to the schema name to OFF, then click Save changes.
If you want to un-block this schema in the future, set the toggle back to ON. Depending on how long you wait and your connector type, you may need to do a historical re-sync to update that schema’s data in your destination, which increases your MAR.
Change schema settingslink
To view or change your schema settings, click the gear icon above the schema list.
A drop-down menu appears. Choose one of the following settings:
- Allow all (enabled by default): Allows Fivetran to sync all new schemas, tables, and columns from your source.
- Allow columns: Blocks Fivetran from syncing new schemas and configurable tables, but allows us to sync new columns.
If you switch to a different setting, click Save changes to save your new setting.
To find a specific table, search for it by name using the search bar.
To find all active tables, click the filter icon and select Only show selected tables.
By default, all tables in a selected schema are automatically selected to be synced. However, you can choose to block certain tables from syncing.
To block a table, click the check box next to the table name, then click Save changes. You can block multiple tables at once.
If you want to un-block this table in the future, click the check box. Depending on how long you wait and your connector type, you may need to do a historical table re-sync to update that table’s data in your destination, which increases your MAR.
View or change sync modelink
If your connector supports history mode, you can view and change your tables’ sync mode. Hover over the table’s row to see its current sync mode. If the table currently uses history mode, History is displayed in the table’s row even if you are not hovering over it.
TIP: See which connectors support history mode in our history mode connector list.
To change the table’s sync mode, click on the mode name to open a drop-down menu. Choose one of the following settings:
- Live mode (enabled by default) : Source record changes and deletes are reflected in the destination. The destination will be an exact copy of the source.
- History mode: Source record changes and deletes are recorded and timestamped as new records in the destination, resulting in more monthly active rows and higher cost.
If you switch to a different mode, click Save changes to save your new mode.
To re-sync a table, hover over the table’s row in the schema list. Click the Resync button that appears.
You can only re-sync active tables.
Block a columnlink
By default, all columns in a selected table are automatically selected to be synced. If your connector supports column blocking, you can choose to block certain columns from syncing. Primary key columns cannot be blocked.
TIP: See which connectors support column blocking in our column blocking connector list.
If you want to block certain columns, click the check box next to the column name, then click Save changes. You can block multiple columns at once.
Hash a columnlink
If your connector supports column hashing, you can hover over the column’s name to see its hash mode (hashed or unhashed). Primary key columns cannot be hashed.
TIP: See which connectors support column hashing in our column hashing connector list.
To change this column’s hash mode, click on the mode name to open a drop-down menu. Choose one of the following settings:
- Unhashed (enabled by default): Data values at the source will be replicated identically to the destination.
- Hashed: Hash data values in this column before syncing data to your destination.
If you switch to a different mode, click Save changes to save your new mode. You can change the hash mode for multiple columns at once.