CREATE FOREIGN TABLE構文 - Advanced SQL Engine - Teradata Database

CREATE [MULTISET] FOREIGN TABLE table_specification 
  [ , table_option [,...] ]
  [ , external_security_clause ]
  [ ( location_column, { payload_column | data_column_definition }) ]
  USING (
    LOCATION ( 'external_file_path' ) 
    [ PATHPATTERN ( 'value' ) ]
    [ MANIFEST ( { 'TRUE' | 'FALSE' } ) ] 	
    [ ROWFORMAT ( 'encoding_format' ) ]
    [ STOREDAS ( { 'TEXTFILE' | 'PARQUET' } )]
    [ HEADER ( { 'TRUE' | 'FALSE' } ) ]
    [ STRIP_EXTERIOR_SPACES ( { 'TRUE' | 'FALSE' } ) ]
    [ STRIP_ENCLOSING_CHAR ('NONE') ]
  )
  [ [,] NO PRIMARY INDEX ] 
  [ [,] PARTITION BY COLUMN ] [;]

table_specification

[database_name. | user_name.] table_name

external_security_clause

EXTERNAL SECURITY [ { INVOKER | DEFINER } TRUSTED ]
  [ database_name.| user_name.]authorization_name

指定された列の総数は2048を超えることはできません。