Partition columns optimize query performance by pruning out the data files that do not need to be scanned (i.e. partitioning the external table).

Partition columns optimize query performance by pruning out the data files that do not need to be scanned (i.e. partitioning the external table).

Which pseudocolumn of External table evaluate as an expression that parses the path and/or filename information.
A . METADATA$ROW_NUMBER
B . METADATA$COLUMNNAME
C . METADATA$FILEPATH
D . METADATA$FILENAME

View Answer

Answer: C

Explanation:

The pseudocolumn of an external table that evaluates as an expression parsing the path and/or filename information is:

C. METADATA$FILEPATH

This pseudocolumn provides the full path (including the filename) of the file from which a particular row originated. This can be especially useful when using partitioning based on directory or file structures in your external stage.