Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
WEBINAR June 25, 2025: Build on Apache Iceberg with Qlik Open Lakehouse - REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
wanyunyang
Creator III
Creator III

Qlik Sense data connection to Redshift

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!

Labels (2)
2 Replies
bonny
Contributor II
Contributor II

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

Ravi1212
Contributor II
Contributor II

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.