Which columns can be included in an external table schema? (Select THREE).

The correct answer is A. VALUE D. METADAT A$ FILENAME E. METADATAS FILE_ROW_NUMBER. External tables in Snowflake have a fixed schema with specific system-provided columns. VALUE (A) is always present and holds the raw file content as a VARIANT. METADATA$FILENAME (D) is a metadata pseudo-column that stores the path and name of the staged file containing the row.

Data Modeling and Design

Question

Options

AVALUE
BMETADATASROW_ID
CMETADATASISUPDATE
DMETADAT A$ FILENAME
EMETADATAS FILE_ROW_NUMBER
FMETADATASEXTERNAL TABLE PARTITION

How the community answered

(30 responses)

A
93% (28)
C
3% (1)
F
3% (1)

Explanation

External tables in Snowflake have a fixed schema with specific system-provided columns. VALUE (A) is always present and holds the raw file content as a VARIANT. METADATA$FILENAME (D) is a metadata pseudo-column that stores the path and name of the staged file containing the row. METADATA$FILE_ROW_NUMBER (E) stores the row number within the source file. These three are the standard columns available in external table definitions. METADATA$ROW_ID (B) is available in standard Snowflake streams on internal tables, not in external tables. METADATA$ISUPDATE (C) and METADATA$EXTERNAL_TABLE_PARTITION (F) are either incorrect column names or not standard external table columns as written in the choices.

Topics

#External Tables#Schema Design#Pseudo-columns#Metadata

Community Discussion

No community discussion yet for this question.

Full ARA-C01 Practice