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. If not already done, set up a database table to extract data from. You can use one of your existing tables or set up a test table to use with the examples. See Setting Up a Test Table.
  2. Set up or obtain access to the external object store where you want to write data. Follow the instructions from your external storage vendor.
  3. If not already done, have an administrative user create the authorization object. See Setting Up Authorization for WRITE_NOS Examples.
  4. Use AUTHORIZATION Keyword

  5. Use WRITE_NOS with the AUTHORIZATION keyword:
    SELECT * FROM WRITE_NOS (
    ON ( SELECT * FROM RiverFlowPerm WHERE DateTime = '2018-06-27 00:00' )
    USING
    LOCATION('/S3/s3.amazonaws.com/iewritenostest/RiverFlowPerm2/')
    AUTHORIZATION(MyAuthObj_Write)
    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