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.
Updated about 2 months ago