Advanced SQL Engine | Teradata Vantage - 2.2 - Advanced SQL Engine - Teradata Vantage - Teradata Vantage on AWS - Teradata Vantage on Azure - Teradata Vantage on Google Cloud - Teradata Vantage on IntelliFlex

Teradata Vantage™ User Guide

Teradata Vantage
Teradata Vantage on AWS
Teradata Vantage on Azure
Teradata Vantage on Google Cloud
Teradata Vantage on IntelliFlex
Release Number
Release Date
January 2021
Content Type
User Guide
Publication ID
English (United States)

Advanced SQL Engine (SQL Engine) includes embedded analytic functions supporting high-speed analytics processing required to operationalize analytics. It is the most comprehensive SQL Engine with the highest available and resilient data platform in the industry.

Advanced SQL Engine is designed for decision support. It handles complex data requirements and manages the data warehouse environment through the use of a parallel implementation that automatically distributes data and balances workloads. Parallel processing is an efficient method of handling complex tasks like ad-hoc queries, as it breaks a task into smaller subtasks that are managed concurrently by multiple work units. The support of query and workload parallelism in Advanced SQL Engine enables better performance and higher throughput levels as a relational database management system (RDBMS).

Native Object Store

Native Object Store (NOS) is a Vantage capability that enables Business Analysts, System Administrators, Data Scientists, and Database Administrators to use standard Teradata SQL and APIs to:
  • Search and query CSV, JSON, and Parquet format datasets located on external S3-compatible object storage platforms
  • Write data stored on Vantage to external S3-compatible object storage platforms
Supported External Object Stores:
  • Amazon S3
  • Google Cloud Storage
  • Microsoft Azure Blob storage
  • Microsoft Azure Data Lake Storage Gen2

See Teradata Vantage™ - Native Object Store Getting Started Guide and the Orange Book, Native Object Store: Teradata Vantage™ Advanced SQL Engine, TDN0009800. Both are located at (to see the Orange Book, you must Sign In).

Highly Resilient Data Management

Advanced SQL Engine provides scalability by adding node interconnect capabilities through the Teradata BYNET®. Each processor node running the powerful BYNET software is connected to the dual high-speed Infiniband™. These interconnected nodes form a loosely-coupled, massively parallel processing (MPP) architecture that is managed as a single system. This approach provides the foundation for linear scalability in Teradata systems. A Teradata system is scalable to thousands of physical processors and tens of thousands of virtual processors (VProcs) from an initial single, two-processor node environment.

Advanced SQL Engine supports entry-level to massive enterprise data warehouse (EDW) solutions.

In-Database Analytics

Advanced SQL Engine Analytic Functions
Advanced SQL Engine has the ability to run path and patterning, time series, and model scoring functions for decision trees. The in-database analytics combined with the data management capability, results in high performance and quick decision making.

See Teradata Vantage™ - Advanced SQL Engine Analytic Functions.

Vantage Analytics Library
Vantage Analytics Library provides the Data Scientist with over fifty advanced analytic functions built directly in the Advanced SQL Engine. These functions support the entire data science process, including exploratory data analysis, data preparation and feature engineering, hypothesis testing, as well as statistical and machine learning model building and scoring.

See Vantage Analytics Library User Guide.