Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I created a redshift data connection in QS pointing to edw database. Now I have another issue. The edw database has multiple schemas (dev, prod, etc.), and I want to know if there's a way to default the connection to one schema (for example, dev)?
Thank you in advance!
Driver={Amazon Redshift}; Server=myserver.redshift.amazonaws.com; Database=edw; UID=myuser; PWD=mypassword; search_path=dev;
Hello @wanyunyang ,
If your Redshift user is tied to a specific schema, you can configure user roles in Redshift to default to a schema.
Ask your DBA to set the default schema for your user:
ALTER USER your_user_name SET search_path TO dev;
This ensures that all queries default to the dev schema unless explicitly overridden.