Lightup supports connections to Teradata Vantage Express 17.20.

Lightup account setup

Lightup needs a permanent database user 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 on the database, preferably using a security role.

You can run the following DDL as a DBA to create the Lightup user account and a role with sufficient privileges, and grant that role to the Lightup user.

  • The script creates a user named lightup, but you can use an existing account or another name. If you want to use another account, omit the first line and substitute your existing account's name for lightup in the rest.
  • You can also use a different role name or an existing role. If you use an existing role, omit line 2 and substitute your existing role name for readaccess in the rest.
  • Provide your own values for <password>, <schema_name>, and <another_schema>. If you only want to grant select on one schema, omit ',<another_schema>'. You can also include more schema by appending them inline with commas.
CREATE USER lightup WITH PASSWORD <password>;
CREATE ROLE readaccess;
GRANT CONNECT TO readaccess;
GRANT SELECT ON <schema_name>, <another_schema> TO readaccess;
GRANT ROLE readaccess TO lightup;

Note that this script provides broad select access— you might prefer more granular privileges. See Teradata's Creating Users page and Using Roles to Manage User Privileges page for more options creating a user account and setting up sufficient select access.

Configure connector

  • Host - The URL or IP address of the host that processes connection requests, including the TCP port (but leave out the protocol prefix). Example: ****
  • Username - The name of the user account you set up for connecting to Teradata and querying data.
  • Password - The user account's password.

Advanced settings

  • Schema scan frequency - choose Hourly, Daily, or Weekly to set how often to scan the datasources schemas.
  • Schema scan objects - select Databases, Users, or both. This determines what datasource objects to include in scans.

Query Governance

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

Object types

These Teradata object types are supported:

  • Tables