17.10 - Native Object Store SQL Updates - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Release Definition

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Release Notes
Publication ID
B035-1725-171K
Language
English (United States)

Some SQL syntax has been simplified for NOS:

  • CREATE AUTHORIZATION INVOKER/DEFINER
    Existing syntax:
    CREATE AUTHORIZATION auth-obj
    AS DEFINER TRUSTED
    USER 'user-logon'
    PASSWORD 'user-password';
    
    CREATE FOREIGN TABLE tablename
    , EXTERNAL SECURITY DEFINER TRUSTED auth-obj;
    
    Simplified syntax:
    CREATE AUTHORIZATION auth-obj-new
    USER 'user-logon'
    PASSWORD 'user-password';
    
    CREATE FOREIGN TABLE tablename
    , EXTERNAL SECURITY auth-obj-new;
    
  • ACCESS_ID and ACCESS_KEY Syntax

    In previous releases, READ_NOS used an authorization object in a function mapping in the READ_NOS statement. The syntax is simplified now, so you can include the authorization in the READ_NOS statement without using a function mapping.

    You also no longer need to include "READ_NOS" in the SELECT.

    CREATE AUTHORIZATION auth-obj-new
    USER 'user-logon'
    PASSWORD 'user-password';
    
    SELECT TOP n * FROM (
       LOCATION='YOUR-STORAGE-ACCOUNT'
       AUTHORIZATION=auth-obj-new
    ) AS D;
    
    OR
    
    SELECT TOP n * FROM (
       LOCATION='YOUR-STORAGE-ACCOUNT'
       AUTHORIZATION='{"ACCESS_ID":"access_id","ACCESS_KEY":"access_key"}'
    ) AS D;
    
    Continue to use INVOKER/DEFINER in a function mapping.

See Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210 andTeradata Vantage™ - Native Object Store Getting Started Guide, B035-1214 , available at https://docs.teradata.com/.