Skip to content
O'Reilly home
Data Warehousing

Building a Modern Data Platform with Snowflake

Published by Pearson

A guide to getting off the ground

Dec. 3, 2021

3 - 6 p.m. Coordinated Universal Time

This event has ended.

What you’ll learn and how you can apply it

  • Why choose Snowflake?
  • How to provision a snowflake cluster.
  • How to isolate computer resources and establish a clean separation of concerns.
  • How to create databases, schemas, and tables.
  • How to stage, load, and unload data.
  • How to keep your data secure with network policies, role-based access control, data encryption, and MFA.
  • How to explore and query data via Snowflake’s query UI.
  • You’ll learn industry best-practices for structuring data warehouses.

This live event is for you because…

  • You’ve been tasked to build an analytics platform and want to set it up for success.
  • You lead an analytics team and are evaluating Snowflake as your data warehousing solution.
  • You’re a software engineer, data engineer, or data scientist looking to leverage a massively parallel cloud data warehouse.
  • Your existing cloud data warehousing solution isn’t scaling as promised and you’re evaluating Snowflake as an alternative.

Prerequisites

  • A working knowledge of SQL.
  • A working knowledge of analytics architecture.
  • A need for a performant, highly scalable, cost-effective analytics solution.

Course Set-up

You can download and configure snowsql (snowflake's command-line interface): https://docs.snowflake.com/en/user-guide/snowsql-install-config.html

Recommended Preparation

Recommended Follow-up

Schedule

The timeframes are only estimates and may vary according to how the class is progressing.

Schedule Segment 1: Why Snowflake? (30 minutes)

  • Developer productivity and happiness
  • Security
  • Scalability
  • Community
  • Efficiency

Exercise/Activity I - Audience Discussion, Setting the Stage (15 minutes)

  • What would you do if your engineers could spend their time building, instead of doing database administration?
  • What do you expect in an analytics platform?
  • (If applicable) What are some ways your analytics stack has struggled to scale?

Break (15 minutes)

Snowflake Database Fundamentals (45 minutes)

  • Users and roles
  • Warehouses
  • Databases, schemas, tables, oh my!
  • Internal and external stages
  • Loading data (copy from, copy into, etc)
  • Unloading data

Exercise/Activity II - Hands-On Snowflake (15 minutes)

Break (15 minutes)

Snowflake Security (15 minutes)

  • Discuss the validations (Soc I and Soc II, HIPAA, PCI DSS)
  • Access control (RBAC, DAC)
  • Network security (institute network policy but discuss private links)
  • Data at rest (discuss encryption and rekeying)
  • MFA (and SCIM)

Snowflake UI (15 minutes)

  • Walk through new Snowflake UI
  • Administration
  • Data discovery
  • Sharable filters
  • Sharable worksheets
  • Dashboards

Industry Best-Practices/ ‘Where to go from here’ (15 minutes)

  • ELT vs ETL
  • ‘Raw’ vs ‘modeled’ separation
  • Production-ready system architecture
  • Roles, policies, access control for sensitive data
  • Data modeling and visualization

Your Instructor

  • Jacob Thomas

    Jacob is the lead data engineer at Cargurus, an industry-leading automotive marketplace. He currently leads high-volume data pipelining and warehousing efforts and has also played a lead role in building out the current data platform with Snowflake. Prior to Cargurus, Jacob built out the analytics and data pipelining stack at Wanderu and did similar work at Safari Books Online/O’Reilly before that. He’s helped numerous startups and businesses modernize their data operations along the way.

Start your free 10-day trial

Get started

Want to learn more at events like these?

Get full access to O'Reilly online learning for 10 days—free.

  • checkmark50k+ videos, live online training, learning paths, books, and more.
  • checkmarkBuild playlists of content to share with friends and colleagues.
  • checkmarkLearn anywhere with our iOS and Android apps.
Start Free TrialNo credit card required.