The 2022 Coalesce agenda is now LIVE! Check it out here.

|

Friday, Aug 26, 2022: Join a live Q&A with dbt experts, who'll answer all your 🌶 questions!

|

The 2022 Coalesce agenda is now LIVE! Check it out here.

|

Friday, Aug 26, 2022: Join a live Q&A with dbt experts, who'll answer all your 🌶 questions!

|

The 2022 Coalesce agenda is now LIVE! Check it out here.

|

Friday, Aug 26, 2022: Join a live Q&A with dbt experts, who'll answer all your 🌶 questions!

|

The 2022 Coalesce agenda is now LIVE! Check it out here.

|

Friday, Aug 26, 2022: Join a live Q&A with dbt experts, who'll answer all your 🌶 questions!

|
Close
dbt Labs
  • Product

    What is dbt?

    dbt is a development framework that combines modular SQL with software engineering best practices to make data transformation reliable, fast, and fun.

    Learn more

    Meet dbt

    • Overview
    • For data modeling
    • For data testing
    • For data documentation
    • dbt Cloud Enterprise
    • dbt Cloud integrations
  • Documentation

    For developers

    dbt lets you transform data where it lives, using just SQL SELECT statements to infer dependency graphs and run transformation models in order, without writing DDL & DML.

    Browse the docs

    Documentation

    • Docs homepage
    • Core concepts
    • Getting started tutorial
    • Reference docs

    Adapters

    • BigQuery
    • Databricks
    • Redshift
    • Snowflake
    View all

    Packages

    • audit_helper
    • dbt_utils
    • snowplow
    View all
  • Pricing
  • Company

    About us

    dbt Labs is on a mission to help analysts create and disseminate organizational knowledge. We are the creators and maintainers of dbt.

    Learn more

    Company

    • About
    • Open roles
    • Find a Partner
    • Become a Partner
    • Services
    • Values
    • Diversity, Equity, and Inclusion

    Customer Stories

    • jetBlueJetBlue is eliminating the data engineering bottleneck with dbt
    • HubspotHow HubSpot is empowering analysts to own their tools
    View all
  • Community

    Welcome to the community

    Introduce yourself to your new peers, ask questions, and share what you know. The dbt Community is where analytics engineering lives and grows, and you're a part of it!

    • About the Community
    • Join the dbt Community
    • Newsletter
    • Code of Conduct
    • Vendor Guidelines
    • Answering Community Questions
    • Organizing Inclusive Events
    • Speaking at a Meetup
    • Writing About Your Work
  • Resources

    Find resources

    Check out guides and playbooks, register for our free dbt Fundamentals course, or find events in your timezone.

    Learn

    • dbt News
    • dbt Developer Blog
    • Discourse forum
    • Training
    • Certification

    Connect

    • dbt Community Slack
    • Events & Meetups
    • GitHub
    • Coalesce

    Guides and bookmarkables

    • What is analytics engineering?What is analytics engineering?
    • How to structure a data team?How should I structure my data team?
    • Coalesce 2021Coalesce 2021 replays
    • Coalesce 2020 replaysCoalesce 2020 replays
  • Sign in
  • Create a free account

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:

dbt

  • What is dbt?
  • Documentation
  • Adapters
  • Packages
  • Pricing
  • Support

Company

  • About dbt Labs
  • Open roles
  • Find a Partner
  • Become a Partner
  • Success stories

Resources

  • Blog
  • Community
  • Events
  • Learn
  • Brand guidelines

Connect with us

GitHub LinkedIn Twitter YouTube Read the Roundup
  • © dbt Labs, Inc. All rights reserved.

  • Terms of Service
  • Privacy Policy
  • Security