QuestionQ94Verified/Data Storage and ProcessingCopy linkReport a problemAsk AstroTutorSave questionWhich columns may be included in an external table schema?Choose threeAVALUEBMETADATA$ROW_IDCMETADATA$ISUPDATEDMETADATA$FILENAMEEMETADATA$FILE_ROW_NUMBERFMETADATA$EXTERNAL_TABLE_PARTITIONShow AnswerAnswerExplanationSnowflake 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.Learn moreIntroduction to external tables | Snowflake DocumentationShow comments1Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion