Teradata Database - Database Detail Pattern

For TKU July 2021 we've added a default Teradata JDBC driver. Teradata is also now available in default Database credential list in UI.

More information about database drivers can be found on related Managing database drivers page.

When setting up a credential please give it as much permission as possible. When running SELECT * FROM DBC.DatabasesV "You can use this view to query the characteristics of the databases you own and which you have privileges on" (see publisher's documentation)

Product Architecture

Overview

Teradata_DBDetails pattern creates Database (or Database Detail) Nodes for all configured databases within the Teradata Database instance. It triggers off SoftwareInstance with type 'Teradata Database Server' and creates Database (or Database Detail) Node with type 'Teradata Database'.

Configuration Options

There are several configuration options available for this product:

ignore_databases := ["All", "Crashdumps", "DBC", "dbcmngr", ... "tdwm"]; - allows to ignore selected database names
retrieve_tables := false; - allows to retrieve tables

Database Listing

Pattern extracts list of database using the following query:

sql query: "SELECT * FROM DBC.DatabasesV WHERE DBKind = 'D'"

Pattern extracts defined tables within the given database using the following query:

sql query: "SELECT DatabaseName, TableName, CreateTimeStamp, LastAlterTimeStamp FROM DBC.TablesV WHERE TableKind = 'T' and DatabaseName = <database_name>"

The following picture shows Teradata Database instance with databases

The Database (or Detail) Node has the following model