Teradata

​

Prerequisites for integrating with Teradata

-- Create a user.
CREATE USER validio_user AS
PASSWORD = <password>
PERMANENT = 0 BYTES
SPOOL = 1000000000 BYTES;

-- Grant read access to the following system tables
-- These permissions are required for Validio catalog functionality.
GRANT SELECT ON DBC.DatabasesV TO validio_user;
GRANT SELECT ON DBC.TablesV TO validio_user;
GRANT SELECT ON DBC.ColumnsV TO validio_user;
GRANT SELECT ON DBC.ColumnsQV TO validio_user;
GRANT SELECT ON DBC.QryLogV TO validio_user;
GRANT SELECT ON DBC.QryLogSqlV TO validio_user;

-- For data monitoring and profiling, grant read access to all relevant tables and views.
-- The following grants read access to all existing and future tables and
-- views in a database. Run this command on each database containing relevant tables.
GRANT SELECT ON <DATABASE> TO validio_user;

​

Resolving column data types for views

• Enable QVCI (recommended for restrictive environments). In Teradata, enable QVCI by setting the DisableQVCI DBS Control flag. Validio can then read view column metadata from DBC.ColumnsQV without access to the underlying tables. Refer to Teradata documentation for the exact procedure.
• Grant SELECT on the underlying tables. If QVCI cannot be enabled, grant the Validio user SELECT on each monitored view and on the tables it reads from, so that HELP COLUMN can resolve the column types.

​

Supported data types

• Numeric types (INTEGER, FLOAT, etc.)
• Text types (VARCHAR, CHAR)
• Dates and times (DATE, TIMESTAMP)
• Arrays and complex types (if present)

​

Add a Teradata credential

1. Navigate to Credentials and click + New credential.
2. Under Namespace, select a namespace where the resources will be created.
3. For Credential Type, select Teradata Credential.
4. Fill in the Configuration parameter fields. Refer to the Teradata Credential Parameters table.
5. (Optional) Click Test credential to validate that Validio can successfully access the Teradata account. If validation fails, check that you provided the correct parameter values.
6. (Optional) Check Use for catalog and schema checks to automatically discover assets from this credential and add them to the Catalog page.
7. Click Create credential.

​

Teradata credential parameters

​

Add a Teradata source

1. Navigate to Sources and click + New source.
2. Under Source type, select Teradata.
3. Under Config,
   1. Select the valid Credential or create a new credential to authenticate your connection to the data warehouse.
   2. You have two options for specifying the dataset and tables to monitor:
      1. Select an existing table — Enter the Database and Table to specify where the data comes from. Selecting more than one table will create a new source for each table. Refer to the Source Configuration Parameters table
      2. Use Custom SQL — Write a valid SQL query to specify the tables to monitor. For details, see About Custom SQL Sources.
   3. Set the Polling schedule, using a cron expression to specify how frequently the validators on the source will check for changes.
4. Under Schema, click Continue to automatically infer the schema fields from the tables you selected. If you select many tables, this operation can take a few minutes to complete.
5. Under Source details,
   1. Add Tags to help group related sources or to use for routing notifications.
   2. Add an Owner who will be the contact for incident notifications.
   3. Assign a Priority, which indicates the importance of incidents detected on this source.
6. Click Continue to create the source. Source names are generated automatically and will be displayed when the source creation completes. If there are more than 5 sources, you will see the names for the first five and a count of the remaining sources.

​

Source configuration parameters