What is dbt?

Why use dbt?

  • Easy to use. Anyone with a SQL background (analytics developers, data engineers and scientists) to build pipelines
  • Built-in Jinja functionality to allow dynamic templating of SQL scripts with functions (either installed as a package or defined yourself) at runtime
  • Automatically generate documentation that can be deployed on a web server for all to access
  • You no longer need to define your task dependencies — dbt handles this for you
  • Growing community allowing a large forum to ask & answer questions
  • dbt can integrate easily with cloud providers, including GCP, AWS & Azure

Example dbt Pipeline on GCP

Running the Country GDP Growth Pipeline…

--

--

A Google Cloud Data Engineering enthusiast

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store