How retrieve PostgreSQL Tables in Synapse

Question

I am trying to create a data set with a specific table but I get the following error.

What should I check?

Answer 1

From the error message, you need a grant on the table directly.

 GRANT ALL PRIVILEGES ON TABLE xxxx TO yourusername;

The user or the role trying to access the table doesn't have the necessary permissions. Check the permissions :

SELECT grantee, privilege_type
FROM information_schema.table_privileges
WHERE table_name = 'xxxxxx';

Links from the documentation :

https://www.postgresql.org/docs/current/ddl-priv.html

https://www.postgresql.org/docs/current/sql-grant.html