Question

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

Environment

Destination: Redshift warehouse

Answer

Please 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 running the below 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 find more information here.

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

Cause

The users are not granted the required permission.