Learn with us at our bi-weekly demos and see dbt Cloud in action!

Thursday, Apr 6, 2023: Live event | Business critical data teams: Firing up growth at Deputy with dbt Cloud

  • Login
dbt Labs
  • Product

    Overview

    header image

    What is dbt?

    dbt is an intuitive, collaborative platform that lets you reliably transform data using SQL and Python code.

    Learn more

    By use case

    • For Data Modeling

      Create modular data models you can reuse and build upon

    • For Data Testing

      Test before production to ship reliable, accurate data

    • For Data Documentation

      Automate your documentation for ease and accessibility

    Implementation

    • Semantic Layer
    • Integrations
    • Enterprise
    • Success Stories
  • Docs
    • Documentation

      Find resources in this collection of dbt guides and user forums

    • Core Concepts

      Grasp dbt’s technical basics by exploring these core concepts

    • Getting Started Guide

      Start using dbt with this series of step-by-step tutorials

    Platforms

    • BigQuery
    • Databricks
    • Redshift
    • Snowflake
    View all
  • Company
    • Who We Are

      Meet our leadership team and read the latest news about dbt

    • Our Values

      Learn about the values that fuel dbt and shape our direction

    • Diversity, Equity & Inclusion

      Read about our commitment to inclusivity and diverse voices

    • Find a Partner

      Find collaborative Partners in our searchable database

    • Become a Partner

      Join the dbt Partner program for valuable benefits and trainings

    • Services

      Let our experts help your team with customized guidance

  • Learn

    Resources

    • Developer Blog

      Read use cases and gain insights from the dbt Community

    • Blog

      Catch up the latest dbt news, product updates, and events

    • Resource Hub

      Explore a centralized collection of tutorials and case studies

    • Training

      Attend a free course to learn dbt in a structured and guided way

    • Certification

      Validate your skills with an official dbt Certification

    • Events & Meetups

      Attend meetups, conferences, and demos in person and online

  • Community
    • About the Community

      Learn about the benefits of the dbt Community

    • Join the dbt Community

      Sign up to meet new peers and share what you know

    • Discourse Forum

      Ask questions and learn from other dbt practitioners

  • Pricing
  • Book a demo
  • Create a free account
  • Book a demo
  • Create a free account
  • Login

Table of Contents

  1. Playbooks
    • • How dbt Labs’ data team approaches reverse ETL
  2. How a bill becomes a law
    • • How dbt Labs manages OKRs
    • • Data lessons learned from benchmarking the IDE’s performance
  3. Our favorite SQL functions
    • • A star (generator) is born
    • • The surrogate key macro
    • • DATEADD SQL function
    • • UNION ALL & union_relation macro
    • • COALESCE SQL function
    • • DATEDIFF SQL function
    • • DATE_TRUNC SQL Function
    • • LOWER SQL function
    • • EXTRACT SQL function
  4. Orchestrating my day
    • • Erica Louie, Head of Data at dbt Labs
    • • Ian Fahey, Analytics Engineer at dbt Labs
Open sourcing dbt Labs' data culture

Last modified on: Jun 28, 2022

Previous:

Product

  • What is dbt?
  • Case studies
  • Integrations
  • Pricing

For Developers

  • Documentation
  • Getting Started Guide
  • Supported Data Platforms
  • Developer Blog

Company

  • About Us
  • Diversity, Equity & Inclusion
  • CareersWe're Hiring!
  • Company Blog

Resources

  • Resource Hub
  • dbt Learn
  • Certification
  • Events

Community

  • Join the Community
  • Become a Contributor
  • Open Source dbt Packages
  • Community Forum

Support

  • Contact Support
  • Professional Services
  • Find a Partner
  • Become a Partner

Read the Roundup

The internet's most useful articles on analytics engineering and its adjacent ecosystem. Curated with by Tristan Handy and Anna Filippova.

Read Now

Connect with Us

GitHub LinkedIn Twitter YouTube
  • © 2023 dbt Labs, Inc. All Rights Reserved.
  • Terms of Service
  • Privacy Policy
  • Security
  • Report a Problem