Skip to main content

dbt (data build tool) is a command line tool that helps analysts and engineers transform data in their warehouse more effectively

Project description

# dbt

dbt (data build tool) helps analysts write reliable, modular code using a workflow that closely mirrors software development.

A dbt project primarily consists of “models”. These models are SQL select statements that filter, aggregate, and otherwise transform data to facilitate analytics. Analysts use dbt to [aggregate pageviews into sessions](https://github.com/fishtown-analytics/snowplow), calculate [ad spend ROI](https://github.com/fishtown-analytics/facebook-ads), or report on [email campaign performance](https://github.com/fishtown-analytics/mailchimp).

These models frequently build on top of one another. Fortunately, dbt makes it easy to [manage relationships](https://docs.getdbt.com/reference#ref) between models, [test](https://docs.getdbt.com/docs/testing) your assumptions, and [visualize](https://graph.sinterdata.com/) your projects.

Still reading? Check out the [docs](https://docs.getdbt.com/docs/overview) for more information.

![dbt dag](/etc/dag.png?raw=true)

— ### Getting Started

  • [What is dbt]?

  • Read the [dbt viewpoint]

  • [Installation]

  • Join the [chat][slack-url] on Slack for live questions and support.

— ### The dbt ecosystem - Visualize your dbt graph [here](https://graph.sinterdata.com/) - Run your dbt projects on a schedule [here](http://sinterdata.com/)

[![Code Climate](https://codeclimate.com/github/fishtown-analytics/dbt/badges/gpa.svg)](https://codeclimate.com/github/fishtown-analytics/dbt) [![Slack](https://slack.getdbt.com/badge.svg)](https://slack.getdbt.com)

### Testing

[Coverage](https://circleci.com/api/v1/project/fishtown-analytics/dbt/latest/artifacts/0/$CIRCLE_ARTIFACTS/htmlcov/index.html?branch=development)

## Code of Conduct

Everyone interacting in the dbt project’s codebases, issue trackers, chat rooms, and mailing lists is expected to follow the [PyPA Code of Conduct].

[PyPA Code of Conduct]: https://www.pypa.io/en/latest/code-of-conduct/ [slack-url]: https://slack.getdbt.com/ [Installation]: https://docs.getdbt.com/docs/installation [What is dbt]: https://docs.getdbt.com/docs/overview [dbt viewpoint]: https://docs.getdbt.com/docs/viewpoint

Project details


Release history Release notifications | RSS feed

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

dbt-0.10.1rc2.tar.gz (97.6 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page