What Happens When I Deselect Tables or Columns in Fivetran?

Question

What happens in my destination when I deselect a table or column from my connection schema in Fivetran?

Environment

Fivetran Dashboard

Answer

Tables

When you deselect a table from your connection schema, we stop syncing updates. However, the table remains in your destination with its previously synced data.

Columns

When you deselect a column from your schema, we handle it like a deleted column:

• Some connectors keep the column in your destination with existing data and add NULL values going forward. If you re-sync the table, we remove previously synced data from the column.
• Others replace all values with NULL.

To learn more, see our Column changes documentation.

Can I drop tables or columns by deselecting them in Fivetran?

It's not possible to drop a table from your destination by deselecting it from your connection schema in Fivetran. You must manually remove it.

For some connectors, such as Salesforce, you can drop columns from your destination when you deselect them from your connection schema. If supported, a We are about to make some changes pop-up appears. To drop the column, select the checkbox next to Drop blocked columns, then click Save & Apply.

For more information, see How to drop columns by schema configuration.