ELT

ELT is a variant of ETL where raw data is loaded into the target data warehouse first, and transformations happen inside the warehouse using SQL. Cloud warehouses like BigQuery, Snowflake, and Redshift have made ELT practical by providing cheap storage and massively parallel query processing.

dbt (data build tool) is the primary framework for managing ELT transformation logic as version-controlled SQL.