Data Dictionary Views | Teradata Data Mover - Data Dictionary Views - Teradata Data Mover

Teradata® Data Mover User Guide - 20.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
hlv1700545853003.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
don1467241476387
Product Category
Analytical Ecosystem
The Vantage Data Dictionary has tables and views that reside in the system user DBC. The tables are reserved for use by the system and contain information about the data in the system. The views provide access to the information in the tables. Data Dictionary has the following table views available, depending on the version of Analytics Database in use:
  • Base or V Version: better performance
  • X or VX Version: increased security, reduced performance
The following table lists which versions of the view Data Mover uses, depending on your configuration settings and Analytics Database version. Depending on the version of Analytics Database in use, the following is true:
  • When all four views are available and the databaseQueryService.useBaseViewsOnly configuration setting is true (default), the Base or V Version of the view is used.
  • When all four views are available and the databaseQueryService.useBaseViewsOnly configuration setting is false, the X or VX Version of the view is used.
Data Dictionary View Name Version of DBC View Used with databaseQueryService.useBaseViewsOnly Setting Source or Target
True False
DBC.ALL_RI_Children V VX Source only
DBC.Columns V VX Source and Target
DBC.ColumnStats V V Source only
DBC.Databases V VX Source and Target
DBC.DataSetSchemaInfo V V Source only
DBC.DiskSpace Base or V Base or V Source and Target
DBC.Functions V VX Target only
DBC.IndexStats V V Source only
DBC.Indices V VX Source and Target
DBC.JoinIndices V V Source and Target
DBC.Maps V VX Source and Target
DBC.MultiColumnStats V V Source only
DBC.Server V VX Target only
DBC.Tables V VX Source and Target
DBC.TableSize V VX Source and Target
DBC.TblSrvInfo V VX Target only
DBC.Triggers V VX Source and Target
DBC.RI_Distinct_Children V VX Source and Target
DBC.RI_Distinct_Parents V VX Source and Target
DBC.Children V VX Source only
  • Users that run commands and jobs in Data Mover must have SELECT permissions on the views listed in the table for Data Mover to function properly.
  • Data Mover uses the HELP VIEW DBC.Columns output to determine which columns to query for the DBC Columns View.