Working with File and Column Metadata

The following file-level metadata fields are available for the supported file formats:

File Metadata	Type	Description
METADATA$FILENAME	VARCHAR	The name of the file from which the row was read
METADATA$FILE_ROW_NUMBER	INT	The row number within the file (starting from 0)

These metadata fields are available in:

• SELECT queries over stages (e.g., SELECT FROM @stage)
• COPY INTO <table> statements

Detailed Guides for Querying Metadata

File Format	Guide
Parquet	Querying Parquet Files with Metadata
CSV	Querying CSV Files with Metadata
TSV	Querying TSV Files with Metadata
NDJSON	Querying NDJSON Files with Metadata
ORC	Querying ORC Files with Metadata
Avro	Querying Avro Files with Metadata