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.

You can run the following DDL as a DBA to create the Lightup user account with sufficient privileges.

• 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.
• Provide your own values for <password> and <schema_name>.

CREATE USER lightup AS PASSWORD = <password> PERM = 1e6 SPOOL = 10e6;

GRANT SELECT ON DBC.DatabasesV TO lightup;
GRANT SELECT ON DBC.TablesV TO lightup;

GRANT SELECT ON <schema_name> 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.

Connect to a Teradata datasource

1. In the left pane, open a workspace menu and select Datasources.
2. In the main page select Create Datasource +.

3. Enter a Datasource Name, then for Connector Type select Teradata.
4. Under Configure connector, provide the following inputs:

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

5. After entering the required settings and any optional settings that apply, below the Configure connector section select Test Connection.
6. After a successful connection test, select Save.
7. 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 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 Scheduling, Enforce indexed timestamps, Enable data storage, Maximum backfill duration, and Maximum distinct values query governance settings. For steps, see Set query governance settings for a datasource.

Date/time data types

These Teradata date/time data types are supported:

• DATE
• TIMESTAMP WITH TIME ZONE

Object types

These Teradata object types are supported:

• Tables
• Views

Supported Versions

• Vantage Express 17.20