Snowflake SnowPro Core Certification Study Guide

Chapter 4Loading Data

THE SNOWPRO CORE EXAM TOPICS COVERED IN THIS CHAPTER INCLUDE THE FOLLOWING:

• 3.0 Domain: Data Movement
• 3.1 Outline different commands used to load data and when they should be used.
  • COPY
  • INSERT
  • PUT
  • GET
  • VALIDATE
• 3.2 Define bulk as compared to continuous data loading methods.
  • COPY
  • Snowpipe
• 3.3 Define best practices that should be considered when loading data.
  • File size
  • Folders
• 3.4 Outline how data can be unloaded from Snowflake to either local storage or cloud storage locations.
  • Define formats supported for unloading data from Snowflake
  • Define best practices that should be considered when unloading data
• 3.5 Explain how to work and load semi-structured data.
  • Supported file formats
  • VARIANT column
  • Flattening the nested structure
• 5.0 Domain: Snowflake Overview & Architecture
• 5.1 Outline key components of Snowflake’s Cloud data platform
  • Data types
• 5.7 Outline Snowflake’s catalog and objects.
  • Database
  • Schema
  • Data Types
• 6.0 Domain: Storage and Protection
• 6.1 Outline Snowflake Storage concepts.
  • Micro-partitions
  • Stage Types
  • File Formats

Data loading and processing is a crucial activity for a data analytics system. Snowflake provides a variety of methods for loading data, including bulk data loading and processing data in a continuous manner. This chapter walks you through the concept of staging in Snowflake, describing the internal and external stage types. We cover data loading using the COPY command and continuously through Snowpipe. We also ...