Which columns may be included in an external table schema?
Snowflake external tables include VALUE, which represents each external-file row as a VARIANT value, and the METADATA$FILENAME and METADATA$FILE_ROW_NUMBER pseudocolumns. METADATA$EXTERNAL_TABLE_PARTITION is an internal hidden column used in partition expressions, not a schema column.
VALUE
METADATA$FILENAME
METADATA$FILE_ROW_NUMBER
METADATA$EXTERNAL_TABLE_PARTITION
Community Discussion