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.