READ_NOS Table Operator Syntax | SQL Statements | Teradata Vantage - 17.10 - READ_NOS Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1210-171K
Language
English (United States)
READ_NOS (
[ON { table_name | view_name | ( query_expression ) }]
USING (
  LOCATION ( 'external_file_path' ) 
  [  AUTHORIZATION ( { [DatabaseName.]AuthorizationObjectName |
       '{"Access_ID":"identification", "Access_Key":"secret_key"}' } ) ]
  [  BUFFERSIZE ( 'buffer_size' )  ]
  [  RETURNTYPE ( { 'NOSREAD_RECORD' | 'NOSREAD_KEYS' | 
                    'NOSREAD_PARQUET_SCHEMA'  'NOSREAD_SCHEMA' } )  ] 
  [  SAMPLE_PERC ( 'row_sampling_value' ) ]
  [  STOREDAS ( { 'PARQUET' | 'TEXTFILE' } ) ]
  [  FULLSCAN ( { 'TRUE' | 'FALSE' } ) ]
  [  MANIFEST ( { 'TRUE' | 'FALSE' } ) ]
  [  ROWFORMAT ( 'rowformat_value' ) ]
  [  HEADER ( { 'TRUE' | 'FALSE' } ) ] 
)
You must type the bold curly braces shown in '{"Access_ID":"identification", "Access_Key":"secret_key"}'. Those particular curly braces are part of the READ_NOS statement.