software
ELT
Extract, Load, Transform
Definition
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.
Can this ship? Are we exposed? Can you prove it?
Every CISO is asking these three questions. We answer them with facts, not guesses, from repository to runtime.