Set Teradata Datatools Preferences | Teradata Studio - Setting Teradata Datatools Preferences - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
lex1576517377362.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

Use the Teradata Datatools Preferences dialog to configure options that control the use of views to obtain metadata information and to set the byte increments for display of size metrics.

The Studio application uses system views to obtain information for its displays, such as the list of databases. Typically, the views are available in two forms: the V view and a VX view variant. Depending on your permissions and how your database is set up, you may only be able to access the information through one form.

  1. Select Window > Preferences > Teradata Datatools.
  2. Select the V, VX, or a Custom View to be used when loading the metadata for various objects. If you select Custom Option, you must provide the fully qualified name for a table or view.
    The table or view must also provide the exact same column names and data types as the associated DBC view. For example, if you are providing a custom view for the Databases list, you must provide a fully-qualified name for a table or view that contains the same columns as DBC.DatabasesVX view.
  3. At Size preference, choose whether KB, MB, and GB increments are in multiples of 1000 or 1024.
  4. Click Apply then OK to save your changes.