Using WRITE_NOS with AUTHORIZATION | NOS | Teradata Vantage - 17.05 - Example: Using WRITE_NOS with AUTHORIZATION - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Native Object Store Getting Started Guide

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

The example uses the AUTHORIZATION keyword to provide credentials to external object store. Instead of creating an authorization object and a function mapping, you can include your credentials in the WRITE_NOS command itself.


  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. Use AUTHORIZATION Keyword

  4. Use WRITE_NOS with the AUTHORIZATION keyword:
    SELECT NodeId, AmpId, Sequence, ObjectName, ObjectSize, RecordCount
    ON ( SELECT * FROM RiverFlowPerm WHERE DateTime = (TIMESTAMP '2018-07-01 00:00:00') )
    ) AS d
    ORDER BY AmpId;

    Replace LOCATION with the URI to the external object store where you are writing the data. Replace YOUR-ACCESS-KEY-ID and YOUR-SECRET-ACCESS-KEY with credentials to your external object store.

    Your result will be similar to the following:

    NodeId AmpId Sequence ObjectName
    ------ ----- -------- ------------------------------------------------------------------------
        33     0        1 /S3/
        33     1        1 /S3/
        33     2        1 /S3/