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
Comments
Log in or register to comment.