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

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