16.00 - Views - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide

The system provides multiple views and tools that allow you to explore, discover, and manage Teradata-supported databases, to develop and execute SQL queries, and to transfer data between databases.

Many of the views appear as tabbed panes in the perspective. Not every view applies to every perspective. This table shows the more commonly-used views in the system. Some views are explained in more detail below.

View Description
Navigator Contains the database object tree display in the Administration perspective.
Data Source Explorer Contains the database object tree display in the Query Development and Data Transfer perspectives. You can create Connection Profiles to your Teradata Database systems and interact with database objects.
Project Explorer Provides a hierarchical view of the Projects and their resource files. You can select SQL files for editing or create new SQL files.
Object List Viewer Displays a list of objects in a database. The right-click menu changes depending on the kind of objects in the viewer.
Details/Forms Displays specific details for the selected database object and allows them to be created or modified
Filters Filters the list of objects in the Object List Viewer
Data Lab Provides access to your tables from a Teradata Data Lab.
SQL Editor Displays when an SQL file is opened. Initially, the SQL Editor is opened to provide an area to enter SQL statements. Double-clicking a file in the Project Explorer causes the file to be opened in the SQL Editor view.
Teradata SQL History Maintains a list of SQL queries issued from the SQL editor, allowing you to re-execute them.
Teradata Result Set Viewer Displays the result set returned by SQL queries issued from the SQL Editor view. Individual Result Set tabs are created for each result set.

If a CALL to a stored procedure that has OUT or INOUT parameters is run, a tab is shown in the Result Set Viewer that contains the output values of the parameters.

Transfer History Provides a display of the Data Transfer History information in the database. When a data transfer completes, an entry is placed in the Transfer History.
Transfer Progress Displays a list of executing data transfer jobs and their status.