Snowflake
Snowflake is a cloud-native data warehouse platform that separates storage and compute so organizations can scale each independently, running SQL analytics on massive datasets across AWS, Azure, and Google Cloud.
25 resources across 3 libraries
Glossary Terms(12)
ClickHouse
ClickHouse is an open-source, column-oriented database management system built for online analytical processing (OLAP), capable of executing aggregation and an…
BigQuery
BigQuery is Google Cloud's fully managed, serverless data warehouse that lets users run fast SQL analytics over massive datasets without provisioning or managi…
Alteryx
Alteryx is a self-service analytics platform that lets analysts prepare, blend, and analyze data through a visual, drag-and-drop workflow designer, without req…
Amazon Redshift
Amazon Redshift is a fully managed, cloud-based data warehouse from AWS that uses columnar storage and massively parallel processing to run fast analytical que…
Databricks
Databricks is a cloud-based data and AI platform, built by the original creators of Apache Spark, that unifies data engineering, analytics, and machine learnin…
dbt
dbt (data build tool) is an open-source, SQL-based transformation framework that lets analytics engineers build, test, and document data transformation pipelin…
DuckDB
DuckDB is an open-source, in-process analytical (OLAP) SQL database engine designed to run fast queries directly on local files, dataframes, and data lakes wit…
Snowflake
Snowflake is a cloud-native data warehouse platform that separates storage and compute so organizations can scale each independently, running SQL analytics on…
Metabase
Metabase is an open-source business intelligence tool that lets people explore data, build charts, and create dashboards through a visual query builder without…
Apache Hive
Apache Hive is a data warehouse system built on top of Hadoop that lets users query and manage large distributed datasets using HiveQL, a SQL-like query langua…
Firebolt
Firebolt is a cloud data warehouse built for high-performance, low-latency SQL analytics, designed to serve sub-second queries for analytics applications and d…
Databend
Databend is an open-source, cloud-native data warehouse written in Rust, designed to provide elastic, low-cost analytical SQL processing directly on data store…
Study Notes(12)
Cost Management and Credits
Explains how Snowflake's credit-based consumption pricing works across compute, storage, and cloud services, and the tools available to monitor and control spe…
Integrating Snowflake with BI Tools
Covers how BI tools like Tableau, Power BI, and Looker connect to Snowflake, and the performance and governance patterns that keep dashboards fast and secure.
Querying with Snowflake SQL
A practical tour of Snowflake's SQL dialect, covering joins, window functions, common table expressions, and result caching.
Setting Up a Snowflake Account
A practical walkthrough of creating a Snowflake account, choosing an edition and region, and configuring initial roles and warehouses.
Snowflake Architecture
A deep dive into Snowflake's three-layer architecture: storage, compute, and cloud services.
Snowflake Best Practices
Practical guidance for sizing warehouses, controlling cost, tuning performance, and governing access in a production Snowflake account.
Snowflake Interview Questions
Common Snowflake interview questions on architecture, Time Travel, cloning, and cost troubleshooting, with the reasoning strong answers demonstrate.
Snowflake Quick Reference
A condensed cheat sheet of core Snowflake objects, editions, and everyday SQL commands for fast lookup during daily work.
Snowflake vs Redshift vs BigQuery
A practical architecture, pricing, and ecosystem comparison of the three leading cloud data warehouses to guide platform selection.
Time Travel and Fail-Safe
How Snowflake preserves historical versions of data so you can query, clone, or restore it after accidental changes, and what happens after that window closes.
What Is Snowflake?
An introduction to Snowflake as a fully managed, cloud-native data platform that separates storage from compute.
Your First Snowflake Query
A hands-on guide to running your first SQL query in Snowsight, including context, syntax, and Snowflake's free sample dataset.