Which tool manages SQL-based transformations in BigQuery with version control?
Why A is the answer
Dataform
Dataform manages SQL transformations in BigQuery, with version control.
In detail
- Dataform manages SQL transformations with version control.
- Transformations stay in SQL.
Use case
An illustrative scenario, not a real incident.
A team keeps BigQuery SQL transformations in Dataform, with version control and dependencies.
See it in different ways
flowchart TD
A{"What do you have?"} -->|"New batch or streaming pipeline"| B["Dataflow with Apache Beam"]
A -->|"Existing Spark or Hadoop"| C["Dataproc"]
A -->|"Visual, code-free integration"| D["Cloud Data Fusion"]
A -->|"SQL transformations in BigQuery"| E["Dataform"]mindmap
root((Processing))
Dataflow
Apache Beam
Dataproc
Existing Spark
Data Fusion
Visual, code free
Dataform
SQL in BigQuery
Managed Airflow
DAG orchestrationflowchart LR S0["Write SQLX"] --> S1["Commit"] --> S2["Run in BigQuery"]
Key point: Dataform manages SQL transformations.
Why the other options are wrong
- B. Datastream
- Datastream replicates data.
- C. BI Engine
- BI Engine speeds up dashboards.
- D. Cloud Data Fusion
- Data Fusion is visual integration.