Skip to main content
Vibgrate Graph: over 24% fewer tokens, same results
Back to Tags

Data Warehouse

15 items tagged with "data-warehouse"

Filter by type:

Tutorials1

Tutorial

How to bulk load data into Snowflake with COPY INTO

Stage files, define a file format, and use COPY INTO to load data into Snowflake tables efficiently with error handling.

Reference Architectures1

Reference Architecture

Modern Data Warehouse on Snowflake

A cloud data warehouse on Snowflake with ELT ingestion, virtual warehouses, and governed marts feeding BI across Azure.

Stacks3

Stack

Modern Data Stack (ELT)

Cloud-native ELT pattern: managed ingestion loads raw data into a warehouse, where dbt transforms it and a BI tool serves analytics.

Stack

Snowflake + Fivetran + Looker

A fully managed cloud analytics stack: Fivetran ingests data, Snowflake stores and transforms it, and Looker serves governed BI on top.

Stack

dbt + Amazon Redshift

An ELT analytics stack where data lands in Amazon Redshift and dbt transforms it with version-controlled, tested SQL models.

Comparisons6

Comparison

Snowflake vs BigQuery

Cloud-agnostic data warehouse with decoupled compute versus Google's fully serverless analytics warehouse.

Comparison

Snowflake vs Redshift

Cloud-agnostic warehouse with auto-scaling compute versus Amazon Redshift's AWS-native MPP data warehouse.

Comparison

BigQuery vs Redshift

Google's fully serverless analytics warehouse versus Amazon Redshift's AWS-native MPP warehouse.

Comparison

Databricks vs Snowflake

Lakehouse platform built on Spark and Delta Lake versus Snowflake's cloud data warehouse, now converging on shared use cases.

Comparison

Data Lake vs Data Warehouse

A data lake stores raw data of any type cheaply; a data warehouse stores structured, modeled data for fast analytics. They serve different stages and users.

Comparison

ETL vs ELT

ETL transforms data before loading it; ELT loads raw data first and transforms inside the destination. Cloud warehouses have made ELT increasingly common.

Benchmarks3

Benchmark

TPC-H

An ad-hoc decision-support benchmark of 22 complex analytical queries over a star-like schema, reporting query throughput and power at fixed scale factors.

Benchmark

TPC-DS

A modern decision-support benchmark with 99 queries over a multi-snowflake retail schema, designed to stress complex analytics, data loading, and concurrency.

Benchmark

Star Schema Benchmark (SSB)

A simplified TPC-H derivative using a classic star schema and 13 queries in four flights to measure data-warehouse query performance.

FAQs1

FAQ

What is the difference between a data warehouse, a data lake, and a lakehouse?

A data warehouse stores structured, modeled data optimized for fast SQL analytics, typically loaded through schema-on-write pipelines; examples includ...