Unable To Modify the Column Selection for a New Table

Issue

While adding a new table, it's not possible to modify the column selection because the options are greyed out.

Environment

Database connectors

Answer

To resolve this issue, ensure that the database user you created for Fivetran can natively access the greyed-out columns in the database.

If the Fivetran user can't access the columns, do the following:

1. Pause the connector.
2. Grant the necessary permissions to access the columns.
3. Unpause the connector.

Cause

When a connector sync begins, it pulls each table's standard configuration. If the Fivetran database user doesn't have the necessary permission to access specific tables or columns, the standard configuration marks these tables or columns as Excluded By System.

If the correct permissions are granted during the sync, we will not include the tables or columns for 12-24 hours.