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
Install or connect dbt; then check its status, ports and certificate from FrontierStack. The same screen links to firewall checks, Malware Audit and backups where they apply.
Run it from your Mac.
FrontierStack installs, monitors and secures services on this Mac and on linked servers.
Download FrontierStackApple notarized · Safe & secure · macOS 13 Ventura+