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 connection.
2. Grant the necessary permissions to access the columns.
3. Unpause the connection.

Cause

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

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