Sample External CSV Data with READ_NOS | Native Object Store | Teradata Vantage - 17.05 - Sampling External Data In Place Using READ_NOS - Teradata Database

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

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.05
created_date
January 2021
category
Programming Reference
featnum
B035-1214-175K

Preview the contents of an external object store by using the READ_NOS table operator. In this example, the payload column contains the data.

The examples and results show a sample river flow data set. To use your own data, replace the table and column names, and authorization object.

  1. To run NOS-related commands, log on to the database as a user with the required privileges.
  2. To see sample rows without column names:
    SELECT TOP 2 payload..* FROM READ_NOS_FM (
    ON ( SELECT CAST( NULL AS DATASET STORAGE FORMAT CSV ) )
    USING
    LOCATION('YOUR-STORAGE-ACCOUNT')
    RETURNTYPE('NOSREAD_RECORD')
    ) AS D;

    See Variable Substitutions for Examples for the credentials and location values for the sample river flow data set.

    Your result will be similar to the following:

    Payload..*
    ------------------------------------------------------------------
    ["11.6","10000","09380000","2018-07-01 00:00","662","0.00","8.65"]
    ["10.6","17600","09380000","2018-07-03 00:00","674","0.00","10.23"]