top of page
Search
  • 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

​Weekly

Volume of data

~400 fact records daily

Data sources

https://api.kexp.org/v2

Data collection method

Python API Call


13 views0 comments

Recent Posts

See All

Carto, Snowflake, and Data Management

A basic principle of data management: Don't move data unless you have to. Moving data is expensive and error-prone. Data Egress Cost: How To Take Back Control And Reduce Egress Charges Archiving to S

Music Festivals 2024

I am browsing music festivals I'd like to attend in 2024. I work for Evolve.com which manages vacation properties and my search came up with this site from one of our biggest competitors. Vacasa: US

bottom of page