READ_NOS Table Operator Syntax | SQL Statements | VantageCloud Lake - READ_NOS Syntax - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
READ_NOS (
USING (
   LOCATION ('external_file_path')
   [ AUTHORIZATION('[DatabaseName.]AuthorizationObjectName]
      | '{"Access_ID":"access_id", "Access_Key":"secret_key" [
      ,"Session_Token":"session_token" ] }'  ]
   [ RETURNTYPE ( { 'NOSREAD_RECORD' | 'NOSREAD_KEYS' |
                    'NOSREAD_SCHEMA' } ) ]
   [ SAMPLE_PERC ( 'row_sampling_value' ) ]
   [ STOREDAS ( { 'PARQUET' | 'TEXTFILE' } ) ]
   [ SCANPCT ( 'scanpct' ) ]
   [ MANIFEST ( { 'TRUE' | 'FALSE' } ) ]
   [ TABLE_FORMAT ('DELTALAKE') ]
   [ ROWFORMAT ( 'rowformat_value' ) ]
   [ HEADER ( { 'TRUE' | 'FALSE' } ) ]
)