Preferences | Teradata Studio - 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

Modify preferences by selecting Window > Preferences.

Filter the information or navigate to the preference. Changes to preferences are stored within your workspace. See Filters for more information.

Data Management

Preference Description
Connectivity Configures the connectivity Driver Definitions by adding, editing, removing, or copying driver definitions.
Label Decorations Specifies the display format for columns in the Data Source Explorer.
SQL Development
Option Description
General Specifies settings for database development.
SQL Editor Offers options for the SQL Editor for code assist, connection behavior for SQL files, syntax colors, and SQL templates.
SQL Query Builder Omits the current database/schema from the generated SQL statements of the SQL Query Builder.
SQL Results View Options Offers options for displaying the results of SQL statements.

General

Preference Description
Appearance Customizes the display appearance by offering options for theme, color, font, and label preferences.
Compare/Patch Customizes the display when comparing text files.
Content Types Enables you to associate editors with file types.
Editors Customizes editor behaviors and functions and adds or removes the editors and file types available in the Content Types preferences.
Globalization Customizes global settings for Unicode and text/graphic support.
Keys Customizes the keyboard bindings.
Security Customizes the secure storage, which may be needed when configuring the Teradata Metadata Service (MDS) web service login on Linux.
Workspace Changes the text file encoding for the workspace.

Help

Preference Description
Content Customizes the display of the help screens as well as configuring remote help content.

Teradata Datatools

Preference Description
Teradata Datatools Sets query and size preferences for all Teradata datatools.
Connection Options Sets connection preferences for connection profiles. Preferences include maximum connections per profile. For Teradata connections, queryband options allow you to specify user and metadata queryband settings, as well as fastload/export options. In addition, you can specify default JDBC Connection Options for Teradata and Aster connections.
Data Source Explorer Load Sets preferences in the Data Source Explorer for display of database and user object hierarchy and for load settings that determine which databases and user objects to load.
Data Utilities

Specifies the root directory location and thresholds for disk cache and maximum rows allowed for COMMIT transactions.

You can also set the preference to be prompted with a confirmation dialog to continue/stop load in case of column(s) mismatch.

Dependencies Sets preferences for accessing the Meta Data Services web service.
Export Sets the preference to launch a native editor and customizes export options. Select Write SQL and Result Status to the Export File to include the SQL and result status when exporting.
History Sets the exclude options for the History database, maximum number of rows to display, and which columns to show in the SQL History View.
Logging Specifies your preferences for logging messages.
New Profile Connection Types Sets which types of connection profiles to show as options in the New Connection Profile dialog.
Object List Viewer Specifies which toolbars and menu actions are visible on the Object List Viewer.
Result Set Viewer Sets preferences for Teradata Result Set Viewer.
SQL Formatter Sets preference options for the SQL Formatter.
SQL Handling Sets handling preferences for SQL result sets and options for drag-and-drop and auto-connect functions. You can also specify the LOB sizes for handling large values for Teradata and Aster, and customize success and failure notification as sounds during SQL execution.
Studio Perspectives Sets options for opening perspectives.
Table Data Editor Sets preferences for selection color options, filter thresholds, and editor display and copy/paste options.