Chapter 3 of 5 · Snowflake SnowPro Core COF-C03
Data Loading, Unloading, and Connectivity
File formats, stages, COPY INTO, Snowpipe, streams, tasks, dynamic tables, drivers and integrations.
- 7topics
- 36 minfast track
- 2diagrams and exhibits
- 18%of the exam
Topics in this chapter
Take them in order, or jump to the one you need.
- 1Data Loading, Unloading and File FormatsLearn the SnowPro Core load and unload path: PUT, COPY INTO, GET, supported file formats, named file format objects, compression…5 min
- 2Internal and External Stages, Encryption and Directory TablesCompare user, table and named internal stages with external stages, pick the right server-side encryption type, and use directory…5 min
- 3COPY INTO and Error Handling OptionsMaster COPY INTO for the SnowPro Core exam: load metadata, FORCE and PURGE, transformations, ON_ERROR choices, VALIDATION_MODE…5 min
- 4Snowpipe and Snowpipe StreamingCompare bulk COPY, Snowpipe auto ingest and Snowpipe Streaming: event notifications, pipes, serverless billing, load metadata and…Diagram5 min
- 5Streams, Tasks and Dynamic TablesBuild continuous pipelines in Snowflake with streams for change data capture, scheduled and triggered tasks, task graphs and…Diagram6 min
- 6Snowflake Drivers and ConnectorsKnow the Snowflake drivers (JDBC, ODBC, Python, Go, .NET, Node.js, PHP) and connectors for Kafka and Spark, plus the SQL API and…5 min
- 7Storage, API and Git IntegrationsSet up storage integrations for external stages, API integrations for external functions and Git, and Git repository clones in…5 min
About this chapter
What this chapter covers
This chapter is 18% of the SnowPro Core Certification COF-C03 exam. It tests how data gets into and out of Snowflake: files and stages, the COPY INTO command and its error options, continuous ingestion and pipelines, and the drivers, connectors and integrations that link Snowflake to other systems.
Questions are short scenarios about a Snowflake Practitioner, either single answer or multiple select. Many hinge on one default or one keyword, such as the default ON_ERROR value, the stage reference for a table, or which file types can be unloaded.
How the topics fit together
Data travels a fixed path, and each step has its own tools.
- File formats and the load and unload path describe how files are read and written.
- Stages hold the files, with encryption and directory tables on top.
- COPY INTO loads in bulk, with load metadata and error handling options.
- Snowpipe and Snowpipe Streaming automate ingestion of files and rows.
- Streams, tasks and dynamic tables keep transformed tables up to date.
- Drivers, connectors and integrations connect clients, platforms, cloud storage, APIs and Git.
Learn the defaults as a set. ON_ERROR is ABORT_STATEMENT for COPY and SKIP_FILE for Snowpipe, load metadata lasts 64 days for COPY and 14 days for pipes, and unloads split into 16 MB files unless told otherwise.
How to use these pages
Each topic page has the same shape, so you can skim for what you need.
- What it is: the idea in plain words.
- How it works: the mechanism, with diagrams, SQL and comparison tables.
- Common mistakes: the classic traps.
- What to remember for the exam: the facts to memorize.
- Check yourself: three questions to test your understanding.
Read the pages in order the first time. The later pages on automation reuse the stages, file formats and COPY options from the first three.
Ready for more practice?
The full Snowflake SnowPro Core COF-C03 question bank has 845 questions, with timed practice exams and an explanation for every answer.
This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.