COF-C03: SnowPro Core Certification

By Snowflake · Question Mode

QuestionQ72

Data Loading, Unloading & Connectivity

A user needs to load Snowflake files from a stage that contains data from the past 5 years while using the LEAST amount of operational overhead.

The file names contain the year in this format: SALES_2025_01.gz.

What command should be used to load the data from 2024?

Explanation

The COPY INTO command supports the PATTERN parameter to select staged files with a regular expression. A pattern that matches SALES_2024_ loads the 2024 files in a single operation without individually specifying files or moving/removing unrelated staged data.

Learn more

Community Discussion

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