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
|
| 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.