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

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' } ) ] 
)