I am trying to run a Postgres sink connection query, but I am facing issues with specifying the schema name for the table. How can I specify the schema name in the sink SQL query for a Postgres connection?
Vijay Shankar
Asked on Oct 27, 2023
When specifying the schema name in the sink SQL query for a Postgres connection, you need to provide the schema name along with the table name in the format schema_name.table_name.
If you do not specify the schema name, public will be used as the default schema.
Make sure to use the correct syntax and ensure that the schema and table exist in the database.
Example:
-- Specify schema name along with the table name in the sink SQL query
SELECT * FROM schema_name.table_name;