Redshift
Steps to prepare and connect to Redshift
Lightup account setup
You'll need 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 the least sufficient permissions, preferably using a security role.
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 6 days ago