17.10 - Setting Up Authorization for WRITE_NOS Examples - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Native Object Store Getting Started Guide

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

To use WRITE_NOS, you need to be authorized by the external object storage. A user can provide credentials to the external storage using AUTHORIZATION syntax in the WRITE_NOS command.

  1. Log on to the database as an administrative user with the required privileges to create an authorization object and function mapping.
  2. Create an authorization object for the external object store you are writing to, if not already done:
    CREATE AUTHORIZATION MyAuthObj_Write
    USER 'YOUR-ACCESS-KEY-ID'
    PASSWORD 'YOUR-SECRET-ACCESS-KEY';

    See an example of using an authorization object with the AUTHORIZATION syntax in the query: Example: Using WRITE_NOS with AUTHORIZATION.