Using WRITE_NOS with AUTHORIZATION | NOS | Teradata Vantage - 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
Published
July 2021
Language
English (United States)
Last Update
2022-06-22
dita:mapPath
gmv1596851589343.ditamap
dita:ditavalPath
wrg1590696035526.ditaval
dita:id
B035-1214
lifecycle
previous
Product Category
Software
Teradata Vantage

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