Teradata is a scalable cloud and on-premises data warehouse platform designed to manage large volumes of data and support advanced analytics. With Validio, you can monitor and validate your Teradata data to ensure data quality and freshness.

Prerequisites for Teradata

In Teradata, create a dedicated read-only service account for Validio and grant it permission to the necessary datasets and tables.

The following SQL script provides steps for creating a read-only service account and granting access to metadata tables. Copy the script into a SQL worksheet and follow the steps:

CREATE USER validio_service AS
PASSWORD = <password>
PERMANENT = 1000000 BYTES
TEMPORARY = 1000000 BYTES
SPOOL = 10000000 BYTES;

-- Grant SELECT access on required metadata tables:
GRANT SELECT ON DBC.ColumnsV TO validio_service;
GRANT SELECT ON DBC.DatabasesVX TO validio_service;
GRANT SELECT ON DBC.QryLogV TO validio_service;
GRANT SELECT ON DBC.QryLogSQLV TO validio_service;
GRANT SELECT ON DBC.TablesVX TO validio_service;
GRANT SELECT ON DBC.TableSizeVX TO validio_service;
GRANT SELECT ON DBC.TableTextVX TO validio_service;

-- Grant SELECT on all tables contained in <DATABASE NAME>. 
-- Run this command for each database that contains tables you 
-- would like to monitor and validate
GRANT SELECT ON <DATABASE NAME> TO validio_service;

Add a Teradata Credential

To connect Validio to your Teradata database, you need to configure a credential and specify connection details.

To add a credential for Oracle,

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 credential parameter fields. Refer to the Teradata Credential Parameters table.
5. Check Use for catalog and schema checks to automatically discover credentials and add them to the catalog page.
6. Click Create.

Validio will validate the connection to the Teradata service account. If validation passes, Validio will automatically start fetching data. If validation fails, check that you provided the correct parameter values and try again.

Once the credential is created, you can add a source to monitor Teradata tables.

Teradata Credential Parameters

Authentication Methods

• Standard Authentication — Username and password for the read-only user account.
• LDAP Authentication — Username, password, and LDAP domain (if applicable).
• Kerberos Authentication — Kerberos principal and (optionally) keytab and realm.

For most workflows, standard authentication with username and password is sufficient. Use LDAP or Kerberos for enterprise environments with centralized authentication.

Add a Teradata Source

To add a source for Teradata,

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, Schema, 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 select the precise dataset 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 any incidents or issues triggered by data quality validation.
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

Supported Data Types

Validio supports validation of all standard Teradata data types, including:

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

For semi-structured data types or special fields, see Semi-structured and Complex Data Types.