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

WRITE_NOS (
  ON { [ database_name.]table_name | (subquery) } 
     [  PARTITION BY column_name [ ,...] ORDER BY column_name [ ,...] |
       HASH BY column_name [ ,...] LOCAL ORDER BY column_name [ ,...] |
       LOCAL ORDER BY column_name [ ,...]]
  USING
    LOCATION ('external_object_storage_path')
    [  AUTHORIZATION ( { [DatabaseName.]AuthorizationObjectName |
       '{"Access_ID":"access_id", "Access_Key":"secret_key", "Session_Token":"session_token"}' } ) ]
    STOREDAS ({ 'PARQUET' | 'CSV' })
    [ NAMING ({ 'DISCRETE' | 'RANGE' }) ]
    [ HEADER ( { 'TRUE' | 'FALSE' } ) ] 	
    [ ROWFORMAT ( 'encoding_format' ) ]
    [ MANIFESTFILE ('manifest_name') ]
    [ MANIFESTONLY ('TRUE') ]
    [ OVERWRITE ({ 'TRUE' | 'FALSE' }) ]
    [ INCLUDE_ORDERING ({ 'TRUE' | 'FALSE' }) ]
    [ INCLUDE_HASHBY ({ 'TRUE' | 'FALSE' }) ]
    [ MAXOBJECTSIZE ('max_object_size') ]
    [ COMPRESSION ( { 'GZIP' | 'SNAPPY' } ) ]
)