How retrieve PostgreSQL Tables in Synapse

Felipe Idrobo Avirama 20 Reputation points
2023-10-03T13:28:50.6033333+00:00

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

User's image

What should I check?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,462 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,726 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Amira Bedhiafi 16,146 Reputation points
    2023-10-03T13:46:48.7766667+00:00

    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

    1 person found this answer helpful.