Using WRITE_NOS with AUTHORIZATION | NOS | Teradata Vantage - 17.10 - Example: Using WRITE_NOS with AUTHORIZATION - 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)

The example uses the AUTHORIZATION keyword with an authorization object to provide credentials to external object store.

    Prerequisites

  1. Set up or obtain access to the external object store where you want to write data. Follow the instructions from your external storage vendor.
  2. If not already done, have an administrative user create the authorization object that has the credential to the bucket. See Controlling Foreign Table Access with an AUTHORIZATION Object.
  3. Use AUTHORIZATION Keyword

  4. Use WRITE_NOS with the AUTHORIZATION keyword:
    SELECT * FROM WRITE_NOS (
    ON ( SELECT * FROM RiverFlowPerm WHERE DateTime = '2018-06-27 00:00:00' ) USING
    LOCATION('/S3/s3.amazonaws.com/iewritenostest/RiverFlowPerm2/')
    AUTHORIZATION(MyAuthObj)
    STOREDAS('PARQUET')
    ) AS d;

    Replace LOCATION with the URI to the external object store where you are writing the data.

    Your result will be similar to the following:

    NodeId AmpId Sequence ObjectName
    ------ ----- -------- ------------------------------------------------------------------------
        33     0        1 /S3/s3.amazonaws.com/ie-writenos-bucket/20180701_auth_example/object_33_0_1.parquet
        33     1        1 /S3/s3.amazonaws.com/ie-writenos-bucket/20180701_auth_example/object_33_1_1.parquet
        33     2        1 /S3/s3.amazonaws.com/ie-writenos-bucket/20180701_auth_example/object_33_2_1.parquet