Hi, I am following the Create SQL Query video from Tulip University https://university.tulip.co/sql-connectors/49114 After I created a function, and run a test query, I got an error “SQL Test Error
Error: [500] SQLQueryFailureError: The SQL query specified by the connector function failed to execute successfully: Postgres Connector encountered an error during query: permission denied for table work_order_ex” Can anyone give me help? Thanks!
Hi,
In many occasions the SQL user login used to perform each query has a set of privileges set by the database server. It may be possible this specific SQL Connecter user login has attempted to access a table it does not have permission to access. I would recommend reaching out to your IT or the database server admin to request permission.
For more information on SQL Connector Authentication, please see this Tulip KB: How to Configure a Connector
Thanks!
Damiana
1 Like