You'll need 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 the sufficient permissions using security roles.
You can run the following DDL to create the user account; just substitute a password for <strong_password_here>:
CREATE USER lightup WITH LOGIN BYPASSRLS ENCRYPTED PASSWORD '<strong_password_here>' IN ROLE pg_read_all_data;
Run the following DDL to create the user account; just substitute a password for **redacted**:
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 readaccess TO lightup;
- Host Name - The hostname for the datasource (check the browser address bar; you want the string between // and /). Example:
- Database Name - The name of the database you're connecting to.
- Username - Enter lightup.
- Password - The username account's password.
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.
Postgres datasources support the Query history, Scheduling, and Enable data storage settings. For steps, see Set query governance settings for a datasource.
Updated 6 days ago