Question

Can I disable syncs for subtables, such as tax_line and order_line?

Environment

Connector: Shopify

Answer

Some subtables support data blocking. You can disable all but the primary keys by following the steps below:

1. In Fivetran, access the Schema tab.
2. Expand the desired table.
3. Deselect the unwanted columns.
4. Save the changes.

Cause

Disabling subtables is not possible by design.  Fivetran selects tables for the user to provide a consistent and simple experience. In exceptional cases, we allow configuration. The more configuration we add, the more maintenance there is to do and the more places things can go wrong.

By skipping the configuration that a small number of customers want, we can focus on delivering greater value in other features like new connectors.