Users Unable To Access Fivetran Created Tables

Question

Once Fivetran creates a new table in Redshift, that table is not accessible to other Redshift users.

Environment

Redshift destination

Answer

Make sure that the users are granted the correct permissions and privileges to access the tables.

You can test the permissions for a specific user by executing the following query:

SELECT u.usename,
    s.schemaname,
    has_schema_privilege(u.usename,s.schemaname,'create') AS user_has_select_permission,
    has_schema_privilege(u.usename,s.schemaname,'usage') AS user_has_usage_permission
FROM pg_user u
CROSS JOIN(SELECT DISTINCT schemaname FROM pg_tables) s
WHERE u.usename = 'myUserName'
    AND s.schemaname = 'mySchemaName'

You can also check with your Redshift Admin for more details.

Cause

The users do not have the required permissions.