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.

You can run the following DDL to set up a role and the lightup user account, with the following adjustments:

You can use whatever role name you want (readaccess is just an example).
GRANT CONNECT on all databases you want Lightup to see (cdb 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).
Substitute your own 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 ROLE readaccess TO lightup;

Configure connector

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.

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

MySQL 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.

Metadata metrics

For information about supported metadata metrics, see Metadata metric types.

Date/time data types

These MySQL date/time data types are supported:

DATE
DATETIME
TIMESTAMP

Object types

These MySQL object types are supported:

Tables
Views