Example: Creating an AUTHORIZATION OBJECT for Use with NOS - Teradata Vantage

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

1. Create the authorization object or ask an administrator to create it for you:

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

   Where:

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

   If you are accessing a public bucket, put empty strings for USER and PASSWORD, enclosed in straight quotes. For example:

   CREATE AUTHORIZATION MyAuthObj
   USER ''
   PASSWORD '';

2. 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/') );