Quickstart Transformation Tables Lose Permissions After Every Run

Issue

When Quickstart transformations run, the destination tables lose permissions. BI users, such as Tableau users, can't query the tables unless access is manually granted after each run.

Environment

Quickstart transformations

Resolution

To resolve this issue, set default privileges in your destination so that new tables automatically grant access to your BI user. Run the following command in your destination database, replacing the placeholders with your values:

ALTER DEFAULT PRIVILEGES FOR ROLE <fivetran_role> IN SCHEMA <schema>
GRANT SELECT ON TABLES TO <bi_tool_user>;

Cause

Quickstart transformations may drop and recreate tables during a run. When a table is dropped, all previously granted permissions are removed. The newly created table does not inherit prior grants unless default privileges are configured.