What’s DBT:

In Ro, we use Data Building Tools (DBT) to integrate SQL commands into data pipelines. While Snowflake’s UI is used for light-weighted analytic work. DBT is used more for the automation work to interact with remote database. Here is a demonstration of how we develop a data pipeline use DBT:

Image for post
Image for post
A demonstration of DBT workflow in Ro

Typically, a DBT project is consist of several models. Each model consist of some SQL files. When executing the DBT on local machine, DBT compiles the project, generates the documents and create several executable files for server deployment. …

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