Greenplum

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. Grant the account SELECT rights on the database, preferably using a security role. Make note of the user name and password— you'll need them to create a Greenplum datasource in Lightup.

For more information about managing access using roles in Greenplum, see their page, Managing Roles and Privileges.

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 - Enter lightup.
  • 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

Greenplum datasources support the Query history, Scheduling, and Enable data storage settings. For steps, see Set query governance settings for a datasource.