gcp dataform - ghdrako/doc_snipets GitHub Wiki

fully managed Google Cloud service feature:

  • A SQL-based language for defining data transformations.
  • A serverless orchestration engine to schedule transformations and determine dependencies.
  • A cloud development environment IDE with integrated version control. Code can be deployed to development, test, and production environments easily and securely.

The biggest difference is that dataform uses JavaScript as its scripting language whilst dbt opts for Jinja, a web templating engine for Python.

Dataform v dbt Cloud dbt Cloud requires a monthly subscription plus any charges incurred on the data platform . . . whereas Dataform is free to use with only the data platform charges incurred.