Which statement best describes the purpose of Table stages in Snowflake?

• A. Table stages are used to stage data files for loading into a table operation.
• B. Table stages require external storage.
• C. Table stages cannot be used with Snowpipe.
• D. Table stages automatically encrypt data.

Answer: (A)

Staging is a holding area for data files you plan to load into Snowflake. A table stage is a named location tied to a specific table that you use as the source when loading data into that table (for example, with COPY INTO or Snowpipe). This is precisely what the statement describes: the table stage exists to hold your data files so they can be loaded into the corresponding table.

You can store files in Snowflake’s internal stages or in external cloud storage, so requiring external storage isn’t correct. Snowpipe can monitor and load from many stages, including table stages, so the idea that a table stage can’t be used with Snowpipe isn’t accurate. And while Snowflake automatically handles encryption for data at rest and in transit, encryption isn’t the defining purpose of a table stage; its role is to provide a location from which data is loaded into a table.