DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
Tutorials
Snowflake Open Catalog
Status
  1. Overview
    • Snowpark Session
    • Snowpark APIs
        1. Input/Output
            1. DataFrameReader
              • DataFrameWriter
                • FileOperation
                  • PutResult
                    • GetResult
                      • DataFrameReader.avro
                        • DataFrameReader.csv
                          • DataFrameReader.dbapi
                            • DataFrameReader.format
                              • DataFrameReader.json
                                • DataFrameReader.load
                                  • DataFrameReader.option
                                    • DataFrameReader.options
                                      • DataFrameReader.orc
                                        • DataFrameReader.parquet
                                          • DataFrameReader.schema
                                            • DataFrameReader.table
                                              • DataFrameReader.with_metadata
                                                • DataFrameReader.xml
                                                  • DataFrameWriter.copy_into_location
                                                    • DataFrameWriter.csv
                                                      • DataFrameWriter.format
                                                        • DataFrameWriter.json
                                                          • DataFrameWriter.mode
                                                            • DataFrameWriter.option
                                                              • DataFrameWriter.options
                                                                • DataFrameWriter.parquet
                                                                  • DataFrameWriter.save
                                                                    • DataFrameWriter.saveAsTable
                                                                      • DataFrameWriter.save_as_table
                                                                        • DataFrameWriter.insertInto
                                                                          • DataFrameWriter.insert_into
                                                                            • FileOperation.get
                                                                              • FileOperation.get_stream
                                                                                • FileOperation.put
                                                                                  • FileOperation.put_stream
                                                                                    • PutResult.count
                                                                                      • PutResult.index
                                                                                        • GetResult.count
                                                                                          • GetResult.index
                                                                                            • PutResult.message
                                                                                              • PutResult.source
                                                                                                • PutResult.source_compression
                                                                                                  • PutResult.source_size
                                                                                                    • PutResult.status
                                                                                                      • PutResult.target
                                                                                                        • PutResult.target_compression
                                                                                                          • PutResult.target_size
                                                                                                            • GetResult.file
                                                                                                              • GetResult.message
                                                                                                                • GetResult.size
                                                                                                                  • GetResult.status
                                                                                                                • DataFrame
                                                                                                                • Column
                                                                                                                • Data Types
                                                                                                                • Row
                                                                                                                • Functions
                                                                                                                • Window
                                                                                                                • Grouping
                                                                                                                • Table Function
                                                                                                                • Table
                                                                                                                • AsyncJob
                                                                                                                • Stored Procedures
                                                                                                                • StoredProcedureProfiler
                                                                                                                • User-Defined Functions
                                                                                                                • User-Defined Aggregate Functions
                                                                                                                • User-Defined Table Functions
                                                                                                                • Observability
                                                                                                                • Files
                                                                                                                • Catalog
                                                                                                                • LINEAGE
                                                                                                                • Context
                                                                                                                • Exceptions
                                                                                                                • Testing
                                                                                                            • Snowpark pandas API
                                                                                                            DeveloperSnowpark APIPythonpandas on Snowflakepandas on Snowflake API ReferenceSnowpark APIsInput/OutputDataFrameReader.with_metadata

                                                                                                            snowflake.snowpark.DataFrameReader.with_metadata¶

                                                                                                            DataFrameReader.with_metadata(*metadata_cols: Iterable[Union[Column, str]]) → DataFrameReader[source]¶

                                                                                                            Define the metadata columns that need to be selected from stage files.

                                                                                                            Returns:

                                                                                                            a DataFrameReader instance with metadata columns to read.

                                                                                                            See also

                                                                                                            https://docs.snowflake.com/en/user-guide/querying-metadata

                                                                                                            Was this page helpful?

                                                                                                            Visit Snowflake
                                                                                                            Join the conversation
                                                                                                            Develop with Snowflake
                                                                                                            Share your feedback
                                                                                                            Read the latest on our blog
                                                                                                            Get your own certification
                                                                                                            Privacy NoticeSite Terms© 2025 Snowflake, Inc. All Rights Reserved.
                                                                                                            Language: English
                                                                                                            • English
                                                                                                            • Français
                                                                                                            • Deutsch
                                                                                                            • 日本語
                                                                                                            • 한국어
                                                                                                            • Português