-NA- - Running and Editing SQL

Release Number
Release Date
February 2020
Content Type
Fast Facts
Publication ID
English (United States)

Running and Editing SQL

Teradata offers several query tools that allow you to run and edit SQL. Use the tool that best matches your needs.

Tool Description
Teradata Studio™ Run queries on the Advanced SQL Engine, Machine Learning Engine, Aster, and Hadoop
Teradata Studio™ Express Similar to Teradata Studio for running SQL
Teradata Vantage™ Modules for Jupyter Run queries on the Advanced SQL Engine and Machine Learning Engine
Basic Teradata Query (BTEQ) Enables workstation and mainframe users to submit SQL statements and BTEQ commands in batch or command-line interactive mode on the Advanced SQL Engine
  • Formats the results and returns them to the screen, a file, or to a designated printer
  • Included in Teradata Tools and Utilities package
Teradata SQL Assistant Discontinued. Last version is SQL Assistant 16.20. Use Teradata Studio or Teradata Studio Express instead
Tip: Use the EXPLAIN statement in SQL to show details of how your query is processed. This can help you improve query performance. See Teradata Vantage™ SQL Request and Transaction Processing .

Teradata Vantage™ is our flagship analytic platform offering, which evolved from our industry-leading Teradata Database. Until references in content are updated to reflect this change, the term Teradata Database is synonymous with Teradata Vantage. Advanced SQL Engine is a core capability of Teradata Vantage, based on our best-in-class Teradata Database. Advanced SQL refers to the ability to run advanced analytic functions beyond that of standard SQL.