Lightup account setup

Lightup needs a user account that can query data and metadata for all tables you want to monitor. You might already have a user set up that will work, or you might need to create one. Grant the user sufficient privileges using security roles. Note that Postgres 14 has a built-in role for this use case, so account setup is easier.

You can run the commands on the following tabs to create a user account named lightup and grant it a role with the needed privileges:

-- Replace `'**redacted**'` with the actual password you want to use.
-- GRANT CONNECT on all databases you want Lightup to see (_cdb_ is just an example).

CREATE USER lightup WITH LOGIN BYPASSRLS ENCRYPTED PASSWORD '**redacted**' IN ROLE pg_read_all_data;
GRANT CONNECT ON cdb TO lightup;
-- Replace `'**redacted**'` with the actual password you want to use.
-- GRANT CONNECT on all databases you want Lightup to see (_cdb_ is just an example).
-- You can use whatever role name you want (_readaccess_ is just an example).
-- GRANT USAGE ON and GRANT SELECT ON ALL TABLES IN SCHEMA for all schemas you want Lightup to see (_testdata_ is just an example).

CREATE ROLE readaccess;
GRANT CONNECT ON DATABASE cdb TO readaccess;
GRANT USAGE ON SCHEMA testdata TO readaccess;
GRANT SELECT ON ALL TABLES IN SCHEMA testdata TO readaccess;
CREATE USER lightup WITH LOGIN BYPASSRLS ENCRYPTED PASSWORD '**redacted**';
GRANT ROLE readaccess TO lightup;

Connect to a Postgres datasource

  1. In the left pane, open a workspace menu and select Datasources.
  2. In the main page select Create Datasource +.
  1. Enter a Datasource Name, then for Connector Type select Postgres.
  2. 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 lightup.
  • Password - The username 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

Postgres 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 Postgres date/time data types are supported:

  • DATE
  • TIMESTAMP WITH TIME ZONE
  • TIMESTAMP WITHOUT TIME ZONE

Object types

These Postgres object types are supported: