MySQL
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:
Updated 22 days ago