For the best performance while loading data into table from a stage, you should avoid applying patterns that filter on a large number of files.

For the best performance while loading data into table from a stage, you should avoid applying patterns that filter on a large number of files.
A . FALSE
B. TRUE

View Answer

Answer: B

Explanation:

PATTERN = ‘regex_pattern’

A regular expression pattern string, enclosed in single quotes, specifying the file names and/or paths to

match.

Tip

For the best performance, try to avoid applying patterns that filter on a large number of files. https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#optional-parameters