Elt

12 items tagged with "elt"

Filter by type:

Best Practices1

ELT vs ETL Best Practices

Guidance on when to transform data before loading (ETL) versus loading raw and transforming in the warehouse (ELT), and how to run each pattern well.

Tutorials1

Tutorial

How to build transformation models and tests with dbt

Structure dbt staging and mart models, add tests and documentation, and run a build that materializes them in a warehouse.

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.

Stacks5

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

dbt + BigQuery Analytics Stack

Serverless analytics engineering on Google BigQuery with dbt managing SQL transformations, tests, and lineage on top of warehouse-native compute.

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.

Stack

Airbyte + dbt + Snowflake

An open-core ELT stack: Airbyte ingests data, Snowflake stores it, and dbt transforms it with tested, version-controlled SQL models.

Comparisons2

Comparison

dbt vs Dataform

The widely adopted SQL transformation framework versus Google's warehouse-native transformation tool integrated with BigQuery.

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.

FAQs1

FAQ

What is the difference between ETL and ELT?

ETL (Extract, Transform, Load) transforms data before loading it into the target system, which suited traditional warehouses with limited compute and ...

Glossaries1

Glossary

ETL

Extract, Transform, Load - a process for moving and transforming data between systems