Diagram
Two parallel process flows comparing ETL where transform happens in the pipeline before loading, versus ELT where data is loaded first and transformed with SQL inside BigQuery.
Extract, Transform, and Load Workflows
Extract, Transform, and Load (ETL) is a workflow that extracts data from a source system, transforms it inside the pipeline, and then loads the prepared result into the data warehouse. A typical ETL workflow moves data through three steps in order:
Domain 6 of 7
27 practice questions
Practice this DomainLast updated