Redshift
Steps to prepare and connect to Redshift
Lightup account setup
Lightup needs an account that can query data and metadata for all tables you want to monitor. You might already have an account set up that will work, or you might need to create one. Give the account sufficient permissions, preferably using a security role.
You can run the following DDL as a DBA to set up a role and the Lightup user account, with the following adjustments:
- You can use whatever role name you want (readaccess is just an example).
- The script creates a user account named lightup, but you can use an existing account or a different name if you prefer.
- GRANT CONNECT on all databases you want Lightup to see (cdb is just an example).
- GRANT USAGE ON and GRANT SELECT ON ALL TABLES IN SCHEMA for all schemas you want Lightup to see (testdata is just an example).
- Substitute your own password for **redacted**.
CREATE ROLE readaccess;
GRANT CONNECT ON DATABASE cdb TO readaccess;
GRANT USAGE ON SCHEMA testdata TO readaccess;
GRANT SELECT ON ALL TABLES IN SCHEMA testdata TO readaccess;
CREATE USER lightup WITH LOGIN BYPASSRLS ENCRYPTED PASSWORD '**redacted**';
GRANT ROLE readaccess TO lightup;
Connector setting
- Host Name - The hostname for the datasource (check the browser address bar; you want the string between // and /). Example:
https://
host.na.me
/
- Database Name - The name of the database you're connecting to.
- Username - The username of the account used for connecting to the database and querying data.
- Password - The username account's password.
Schema scan frequency
You can adjust how often scans run for a datasource.
- In section 3 - Advanced, select a value for Schema scan frequency: Hourly, Daily, or Weekly.
Query governance
You can use all query governance features.
Updated 12 days ago