Road to Snowflake SnowPro Core Certification: Stages & Storage Integration

Seventh Chapter: Stages & Storage Integration

Gonzalo Fernandez Plaza

--

Seventh Chapter of the Snowflake SnowPro Core Certification Complete Course.
Seventh Chapter of the Snowflake SnowPro Core Certification Complete Course.

Stages in Snowflake specify where data files are stored (staged) so that we can load the data in the files into a table. It is where the files are before moving them to Snowflake tables. There are two types of stages, internal and external stages; let’s see them.

  1. External Stages
  2. Internal Stages
  3. Stage Metadata
  4. Storage Integration
  5. Typical Exam Questions

Remember that all the chapters from the course can be found in the following link.

EXTERNAL STAGES 

External Stages, or Named External Stages, reference data files stored outside Snowflake. Named Stages are Database Objects. The following Cloud Storage Services are supported (where the files to be copied to Snowflake tables will be located):

  • Amazon S3 Buckets for AWS.
  • Google Cloud Storage Buckets for Google Cloud.
  • Microsoft Azure Containers for Azure.

--

--

Gonzalo Fernandez Plaza

Computer Science Engineer & Tech Lead 🖥️. Publishing AWS & Snowflake ❄️ courses & exams. https://www.fullcertified.com