Partition columns for an external table can be derived from the file path and/or filename.

• A. Not supported
• B. False
• C. True
• D. Only for internal tables

Answer: (C)

External tables can use values derived from the storage path and even the file name as partition columns. By organizing data in directories and file names that encode metadata (for example, year=2024/month=06 or region_x.csv), you map those path components to partition columns in the external table definition. Then, when you filter on those partition columns, Snowflake can prune and only read the relevant files, rather than scanning the entire dataset. This makes queries more efficient by leveraging the file path and name as sources of partition information. So, the statement is true.