QuestionQ77

Data Loading, Unloading & Connectivity

What is the FASTEST method for loading particular staged files with the COPY INTO <location> command?

Explanation

A discrete list of staged filenames passed through the FILES parameter is generally the fastest way to identify files for a COPY operation. Snowflake notes that this method supports up to 1,000 files; path/prefix selection and pattern matching are alternative selection methods, with pattern matching generally the slowest.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!