Unable To Modify the Column Selection for a New Tablelink
Updated November 29, 2023
While adding a new table, it's not possible to modify the column selection because the options are greyed out.
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:
- Pause the connector.
- Grant the necessary permissions to access the columns.
- Unpause the connector.
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.