Edit on GitHub
Users Unable To Access Fivetran Created Tableslink
Questionlink
Once Fivetran creates a new table in Redshift, that table is not accessible to other Redshift users.
Environmentlink
Answerlink
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.
Causelink
The users do not have the required permissions.