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

You can run the following SQL as a DBA to create the Lightup user and a role with sufficient privileges for all the tables in a schema, and then grant that role to the Lightup user account.

  • The script names the Lightup user account lightup, but you can use an existing account or another name; likewise the role name readaccess can be a different name if you prefer.
  • If you only want to include one schema, remove , \<another_schema>.
  • Replace \<schema name\>, \<another_schema>, and \<password\> with your own values. Note that you can include more schemas by appending them with commas.
CREATE USER lightup WITH <password>;
CREATE ROLE readaccess WITH CONNECT;
GRANT USAGE ON SCHEMA <schema_name>, <account_name> TO readaccess;
GRANT SELECT ON ALL TABLES IN SCHEMA <schema_name>, <another_schema> TO readaccess;
GRANT ROLE readaccess TO lightup;

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

Connect to a Greenplum datasource

  1. In the left pane select Datasources*
  2. In the main page select Create Datasource +.
  3. Enter a Datasource Name, then for Connector Type select Greenplum.
  4. Under Configure connector, provide the following inputs:
  • 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. Each datasource can only connect to one database. If you need to connect to more than one, you'll need to create a datasource for each.
  • Username - Enter the account name (e.g., lightup).
  • Password - The account's password.
  1. After entering the required settings and any optional settings that apply, below the Configure connector section select Test Connection.
  2. After a successful connection test, select Save.
  3. Your new datasource appears in the list of available datasources. By default, these are listed in alphabetical order, so you might have to scroll or change the sort order to see your new datasource.

Advanced/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, Enable data storage, and Maximum backfill duration, and Maximum distinct values settings. For steps, see Set query governance settings for a datasource.

Date/time data types

These Greenplum date/time data types are supported:

  • DATE
  • TIMESTAMP WITH NO TIMEZONE
  • TIMESTAMP WITH TIMEZONE

Object types

These Greenplum object types are supported:

Partitions

Greenplum datasources support partitions and partition time zones.