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.