Changes/Additions | Data Definition Language | Teradata Vantage - Changes and Additions - Teradata Vantage

Changes/Additions | Data Definition Language | Teradata Vantage - Changes and Additions - Teradata Vantage - Analytics Database

SQL Data Definition Language Syntax and Examples

Deployment

VantageCloud

VantageCore

Edition

VMware

Enterprise

IntelliFlex

Product

Analytics Database

Teradata Vantage

Release Number

17.20

Published

June 2022

ft:locale

en-US

ft:lastEdition

2025-11-22

dita:mapPath

jco1628111346878.ditamap

dita:ditavalPath

qkf1628213546010.ditaval

dita:id

mdr1472255012272

lifecycle

latest

Product Category

Teradata Vantage™

Date	Release	Description
March 2025	17.20.03.36	SHOW TABLE for a Complex Structure Table (CST) SHOW TABLE display CST for tables that are CST tables. See Example: SHOW TABLE for a Complex Structure Table
August 2024	17.20.03.29	DURATION_SECONDS clause for Assume Role DURATION_SECONDS is an optional custom clause to set the duration of AWS Assume Role. You or your administrator can create an authorization object with the optional DURATION_SECONDS clause to store duration in seconds, used in the execution of CREATE FOREIGN TABLE, SELECT, READ_NOS, and WRITE_NOS. See CREATE AUTHORIZATION and CREATE AUTHORIZATION and REPLACE AUTHORIZATION.
March 2024	17.20.03.24	Support for Assume Role AWS Assume Role allows existing AWS IAM users and service accounts temporary access to AWS resources in other accounts. You or your administrator can create an authorization object that allows this access. See CREATE AUTHORIZATION.
December 2022	17.02.03.08	CSV Option for WRITE_NOS STOREDAS
November 2022	17.02.03.07	Parallel Distribution of Parquet Files Vantage distributes Parquet files across AMPs based on rowgroup boundaries (parallel distribution) by default. New SET QUERY_BAND name BINPACKALGO4PARQUET can change this behavior—for details, see SET QUERY_BAND Syntax Elements.
October 2022	17.20.03.06	Setting for Percentage of Data to Scan to Discover Schema Added SCANPCT clause to CREATE FOREIGN TABLE Syntax.
July 2022	17.20.03.03	Support for Virtual Columns in PARTITION BY clause of CREATE FOREIGN TABLE Updated CREATE FOREIGN TABLE Syntax. Added the following: Example: Object Paths with Variable Names Example: Object Paths without Variable Names Example: HELP TABLE with Foreign Table Added MODIFY PARTITION BY clause to ALTER FOREIGN TABLE Syntax. Updated COLLECT STATISTICS (Optimizer Form).
June 2022	17.20.03.01	Teradata Unity was discontinued as of version 17.05. Use Business Continuity Manager instead. Support for Multiline JSON Statements Updated JSON External Files. Support for Delta Lake Added TABLE_FORMAT ('DELTALAKE') syntax element to CREATE FOREIGN TABLE.
July 2021	17.10	New Statement: ALTER FOREIGN TABLE Support for Named JSON Arrays Updated JSON External Files. Error Tables for Foreign Tables Updated CREATE FOREIGN TABLE. Google Cloud Authorizations for Foreign Tables Added Example: Creating a Google Cloud Authorization. Fallback Subtables Not Compressed by Default Updated ALTER TABLE. Updated CREATE TABLE and CREATE TABLE AS. Updated SET QUERY_BAND. FAST MODE for ALTER TABLE Statement Updated ALTER TABLE. Azure LOCATION Syntax for NOS Updated LOCATION. Updated LOCATION Key Prefix Best Practices. AUTHORIZATION for READ_NOS Updated CREATE AUTHORIZATION and REPLACE AUTHORIZATION. USING Clause for CREATE AUTHORIZATION Updated CREATE AUTHORIZATION and REPLACE AUTHORIZATION. INVOKER and DEFINER, which appear in the syntax of the following statements, are deprecated for NOS: CREATE FOREIGN TABLE CREATE AUTHORIZATION and REPLACE AUTHORIZATION CREATE FUNCTION MAPPING and REPLACE FUNCTION MAPPING Miscellaneous Changes Corrected CREATE PROFILE Syntax. Corrected MODIFY PROFILE Syntax. Corrected DROP PROFILE Syntax. Corrected description of FOR USER in PASSWORD clause of MODIFY USER. Updated CREATE FOREIGN TABLE syntax, syntax element descriptions, and examples. Updated description of WHEN clause in CREATE TRIGGER and REPLACE TRIGGER Syntax Elements. 17.05 syntax is deprecated (supported but not recommended).
June 2020	17.00	UDF Search Path Added SET SESSION UDFSEARCHPATH Native Object Store Added CREATE FOREIGN TABLE, including syntax, options, usage notes, and examples. Updated DROP TABLE to add the FOREIGN keyword. Updated COLLECT STATISTICS (Optimizer Form) to add Example: Collecting Statistics on a Foreign Table Column. Added Example: SHOW TABLE for Foreign Table. Updated CREATE AUTHORIZATION and REPLACE AUTHORIZATION to include the USING clause, where you can specify security parameters for accessing remote repositories. Updated CREATE FUNCTION MAPPING and REPLACE FUNCTION MAPPING to add the EXTERNAL SECURITY clause . Updated CREATE storage_format SCHEMA to add Example: Schema for DATASET Type with CSV Storage Format. Incremental Restore Added LOGGING INCREMENTAL ARCHIVE ON FOR object_list, LOGGING INCREMENTAL ARCHIVE OFF FOR object_list, and INCREMENTAL RESTORE ALLOW WRITE FOR object_list. JSON Auto Composition and Shredding Updated CREATE TABLE and CREATE TABLE AS column attributes to add the AUTO COLUMN option. Added AUTO COLUMN and Examples: Creating a Table with a JSON Auto Column. Updated ALTER TABLE column attributes to add the AUTO COLUMN option. Added AUTO COLUMN and Examples: Adding and Removing the JSON Auto Column Option. Added Example: HELP COLUMN for a JSON Column with the Auto Column Option and Example: HELP TABLE with a JSON Auto Column. Added Example: SHOW TABLE with an Auto Column. Function Mapping Variable Substitution Updated CREATE FUNCTION MAPPING and REPLACE FUNCTION MAPPING. Function Mapping for Native Functions Updated CREATE FUNCTION MAPPING and REPLACE FUNCTION MAPPING. Algorithm 3 is the new default mode for DBQL Logging The Database Query Log (DBQL) is enhanced for Analytics Database 17.00 with more complete and accurate logging. DBQL now uses Algorithm 3 by default, which includes collecting statistics on aborted and parallel steps, and results in more accurate resource usage statistics. Upgraded systems that were not previously using Algorithm 3 will not use Algorithm 3 until explicitly configured to do so.