HomeServices › dbt

dbt on a Mac

SQL-based data transformation & modeling (self-hosted / cloud) · Data Pipelines & ETL

dbt (data build tool) is the transform step of the modern data stack — define models, tests, snapshots and docs as SQL + Jinja, then dbt run / dbt test to build them in your warehouse with full lineage. Install dbt Core with pip install dbt-core dbt- (postgres, snowflake, bigquery, …); dbt docs serve hosts the lineage site. dbt Cloud adds a hosted IDE, scheduler and API. Pairs with Airbyte/Meltano (EL) and Dagster/Prefect (orchestration).

Run dbt with FrontierStack

FrontierStack lists dbt in its Data Pipelines & ETL catalog. Install or connect it from one place, then monitor its status, ports and certificate, secure it with the firewall and Malware Audit, and back it up.

Run it all from one Mac app.

FrontierStack installs, monitors and secures the whole stack — locally and across your fleet — from a single native macOS app.

Download FrontierStack

Related in Data Pipelines & ETL