dbt

What it can do

Build, test and run SQL queries and Python scripts. Run these on a schedule. Define metrics that you you can use in other tools later. Work from a web IDE.

Product versions

1. Core: open-source and host it all yourself. Only has the command-line basic features.

2. Cloud: dbt takes care of hosting, includes the web IDE and defining metrics.

3. Enterprise: the typical enterprise features.

Pricing

Clouds has one free user, then €1,100 per user per year. Enterprise starts at €44,000 per year including 10 users. Open-source is free.

Location of data

You can choose a region where the data is processed. Options are US (AWS us-east-1) or EU (AWS eu-central-1, Frankfurt).

Important notes

Europe data location is only available for the Enterprise plan. Pyhon is only supported for Snowflake, Databricks, BigQuery.

Links

• Site https://www.getdbt.com

• Supported databases https://docs.getdbt.com/docs/supported-data-platforms

• Pricing https://www.getdbt.com/pricing/

• Docs: https://docs.getdbt.com