17.10 - Example: Creating an AUTHORIZATION OBJECT for use with NOS - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

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

Run the following command to create an authorization object to access external object store:

CREATE AUTHORIZATION MyAuthObj
USER 'user_name'
PASSWORD 'password';

Where:

  • user_name is the ACCESS_KEY or Storage Account Name to your external object store.
  • password is the secret access key, Key, SAS Token, or Secure Email and Secret Access Key depending on your external object store.

If you are accessing a public bucket or container, put empty strings for USER and PASSWORD, enclosed in straight quotes, such as:

CREATE AUTHORIZATION MyAuthObj
USER ''
PASSWORD '';

Associate the AUTHORIZATION OBJECT with a Foreign Table

CREATE FOREIGN TABLE riverflow_csv
, EXTERNAL SECURITY  MyAuthObj
USING ( LOCATION('/s3/td-usgs-public.s3.amazonaws.com/CSVDATA/') );