topic Qlik Sense data connection to Redshift in Connectivity & Data Prep

Qlik Sense data connection to Redshift

wanyunyang — Mon, 10 Feb 2025 16:19:59 GMT

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!

Re: Qlik Sense data connection to Redshift

bonny — Wed, 19 Feb 2025 07:49:48 GMT

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

Re: Qlik Sense data connection to Redshift

Ravi1212 — Sun, 23 Feb 2025 17:29:01 GMT

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.