Qlik Sense data connection to Redshift

[wanyunyang]

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!

[bonny]

Driver={Amazon Redshift}; Server=myserver.redshift.amazonaws.com; Database=edw; UID=myuser; PWD=mypassword; search_path=dev;

[Ravi1212]

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.