top of page
  • Writer's pictureTim Burns

Studying Snowflake - Data Analyst Study Guide

Updated: Feb 12, 2023

Snowflake is an Enterprise-Level Data Platform for the major cloud providers: AWS, Azure, and GCP. They've managed to build a platform that addresses the diversity and complexity of an enterprise data warehouse, as well as leveraging cutting-edge big data tools and processes.

The SnowPro certification is divided into Core and several advanced specializations. In this blog post, I dig into the Data Analyst SnowPro certification with examples from my own KEXP Data Warehouse in Snowflake, freely available on my Big Data Platforms Git page.

The basis for this blog post is the course exam notes. Download the PDF file, and you can follow the guide while running the examples cited in this post.

Here is a list of domains in the guide.

  1. Data Ingestion and Data Preparation

  2. Data Transformation and Data Modeling

  3. Data Analysis

  4. Data Presentation and Data Visualization

Data Ingestion and Data Preparation

Worksheet - Collecting the Data

Collecting the data is accessing it on a remote site and copying it into the storage provider's location. Snowflake currently supports three service providers: S3, GCS, and Azure.

Data collection frequency


Volume of data

~400 fact records daily

Data sources

Data collection method

Python API Call

15 views0 comments

Recent Posts

See All

Providence Porchfest '24

Maddie Cardoza at Providence Porchfest '24 Had a wonderful day yesterday at Porchfest.


bottom of page