How To Remove Columns or Tables from a Destination

Question

How can I remove unused columns or tables which no longer need to be synced and are not required in the destination?

Environment

• Connectors
• Destinations

Answer

To remove unwanted tables or columns from the destination, do the following:

1. In your Fivetran dashboard, select the connector in which you would like to exclude columns or tables.
2. Pause the connector so that it stops syncing to the destination while the changes are made.
3. Exclude the columns or tables in the Schema tab.

   NOTE: You must have the Create Connectors, Edit Connectors, or Manage Connectors permissions to exclude columns and tables. Learn more in our RBAC documentation.

4. Drop the columns or tables in the destination. Refer to your destination service provider's documentation to learn how to drop tables and columns.
5. Unpause the connector.