Learn Postgres
The Crunchy Data Playground gives you a fully functional Postgres instance right in your browser. There's nothing to install, nothing to set up, and no credit card. Each tutorial comes with a preloaded sample database so you can start writing queries immediately.
These are some of my favorites to recommend, but there are dozens more on the platform.
| Tutorial | Description |
|---|---|
| Crunchy Data Playground | Browse all available interactive tutorials, from SQL basics to advanced geospatial queries. |
| psql Basics | Get comfortable navigating Postgres from the command line with \d, \dt, \l, and more. |
| Basics of Arrays | Postgres has native array support. Learn to store, query, and manipulate arrays directly in SQL. |
| Working with Dates | Date and time handling is one of those things every developer needs eventually. Learn intervals, date math, and formatting. |
| Introduction to JSON | Store and query JSON documents natively in Postgres, without a separate document database. |
| Window Functions | Once you learn window functions, you'll wonder how you ever lived without them. Ranking, running totals, moving averages, and more. |
| PostGIS Intro | Add geospatial queries to Postgres: points, polygons, distance calculations, and spatial indexing. |
All Crunchy Data Playground tutorials are free, run entirely in the browser, and require no installation or account creation.
Hands-On Training: Postgres Full-Day Training Workshop
If you want to go deep in a single sitting, this open source workshop covers six hours of material from beginner through advanced topics. Originally presented at SCaLE 23x (2026), it's designed for both instructor-led sessions and self-study.
What's covered:
- psql fundamentals and navigation
- SQL querying and data manipulation
- DBA essentials (users, roles, configuration)
- Troubleshooting common issues
- Performance analysis and monitoring
- Query tuning and indexing strategies
Setup: Docker-based environment with the Bluebox sample database (real TMDB movie data). Spin it up in a few minutes and start working through exercises at your own pace.
Snowflake Developer Guides
These guides walk you through real-world workflows on Snowflake Postgres, from creating your first table to building production data pipelines with pg_lake and monitoring with your observability stack of choice.
Getting Started with Snowflake Postgres
Create a Snowflake Postgres instance, connect to it, and create sample data and queries. Getting Started with Snowflake Postgres
Getting Started with Snowflake Postgres Tables
Create tables, load data, and run queries on your Snowflake Postgres instance. Getting Started with Tables
Postgres Execution Plan
Read EXPLAIN output and understand how Postgres decides how to fetch your data. Postgres Execution Plan
Migrate to Snowflake Postgres Using Logical Replication
Set up logical replication to migrate an existing Postgres database to Snowflake Postgres with minimal downtime. Migrate Using Logical Replication
Mirror Postgres Data to Snowflake
Set up continuous mirroring from Snowflake Postgres to your Snowflake account for analytics and reporting. Mirror to Snowflake
Bidirectional Data Pipelines with pg_lake
Build IoT-style pipelines that flow data between Postgres and Snowflake using pg_lake's Iceberg integration. Two versions: your own S3 bucket, or a Snowflake internal stage where data never leaves Snowflake. Bidirectional Data Pipelines with pg_lake (External Stage) Bidirectional Data Pipelines with pg_lake (Internal Stage)
Stream Snowflake Changes to Postgres with pg_lake
Use a Snowflake stream and task to export changes to an internal stage, then merge them into a Postgres table with pg_incremental. Stream Snowflake Changes to Postgres
Sync Data from Postgres to Snowflake with Iceberg
Use pg_lake to sync Postgres tables to Snowflake as Iceberg tables for analytics workloads. Sync Data with Iceberg and pg_lake
Build a Lakehouse with Snowflake Postgres
Combine Postgres as your transactional layer with Snowflake's analytics engine for a complete lakehouse architecture. Build a Lakehouse with Snowflake Postgres
Getting Started with PostgreSQL CDC (Openflow)
Replicate an existing PostgreSQL database into Snowflake with the Openflow PostgreSQL connector. Getting Started with PostgreSQL CDC
Build AI Apps with Streamlit and Snowflake Cortex
Connect your Postgres data to Snowflake Cortex AI functions and build interactive Streamlit applications. Build AI Apps with Streamlit and Cortex
Monitor with Datadog
Ship Snowflake Postgres logs and metrics to Datadog for centralized observability. Monitor with Datadog
Monitor with Observe
Integrate Snowflake Postgres monitoring into Observe. Monitor with Observe
Monitor with Grafana
Set up Grafana dashboards for Snowflake Postgres performance monitoring and alerting. Monitor with Grafana
All Snowflake developer guides include step-by-step instructions with working SQL, ready to follow in your own Snowflake Postgres instance. Create a free trial account if you want to follow along.
This content is provided as is, and is not maintained on an ongoing basis. It may be out of date with current Snowflake instances
