Migrating to the cloud comes with *real* challenges. We're unpacking what those cloud migration challenges are and offering pragmatic solutions.

in societate vivimus, fortasse collaboramus

The integration of MetricFlow is poised to make dbt's Semantic Layer considerably more sophisticated, enabling more complex metric definition and querying to be done highly...

dbt Cloud users can now connect to Starburst or Trino to write queries that join data from different data stores: that includes data warehouses, data...

Explore the data modeling techniques (relational, ER, dimensional, and data vault) that data teams use to model their data and create actionable insights.

A data quality framework develops trust between your team and the business and establishes a system of governance and accountability for your data quality.

Data Clymer, phData, Qrious, Slalom, and Tropos are now our first ever Premier Consulting Partners! We're also welcoming a fantastic new lineup of consultancies as...

The data transformation process can be broken down into six steps: extraction and loading, exploration, transformation, testing, documentation, and deployment.

Foundational data quality checks you should be running on your data cover the concepts of uniqueness, non-nullness, acceptance, referential integrity, and freshness.

Data quality testing is the practice of using code-based and automated data quality tests to know whether these assertions you make about your data are...

Data quality dimensions create a general profile of your data's quality. How you define what "good" data quality is depends on how that data is...

We've recently launched a series of quality of life improvements to the Cloud IDE experience — and we're also announcing many more to come.

The main differences between ETL and ELT lie in when and where data transformation occurs—changes that might seem small but come with big implications!

If you're an open source dbt Core user, you may have wondered what dbt Cloud could do for you. Here's when and why to consider...

You can now use Webhooks to automatically trigger workflows in external tools based on dbt job status.

This new data residency offering for dbt Cloud Enterprise customers in the Asia-Pacific region joins other regional deployment options hosted in Europe and North America....

Read this press release to learn about dbt's acquisition of Transform.

The Professional Services team at dbt Labs has a simple remit: ensure dbt Cloud customers get as much value from the platform as possible, as...

A technical writing mentorship program for the dbt Community, sponsored by dbt Labs.

We’re updating the dbt Cloud Developer and Team plans to better reflect product maturity after years of improvements.

Addressing key questions around changes to the dbt Cloud Team and Developer Plans

We’re often asked how dbt Cloud stores and processes data related to your projects. This post delves into the details of our Terms of Use,...

We've partnered with Hex to bring trust and speed to collaborative analytics workflows.

The dedicated dbt-databricks adapter is now on dbt Cloud.

Read this blog post to learn about the five important perspectives gained from Coalesce 2022.

dbt Labs has added two more courses to its library of free resources for the emerging analytics engineer. Those new to dbt will find everything...

Read this blog post to learn about navigating changes to a data team's structure and leveling up infrastructure and development workflows.

Current economic uncertainty makes navigating new data team investments a little tricky. Is now the right time to consider new tooling and frameworks? Is doing...

Coalesce is for data practitioners at all stages of their career. If you've been in this space for a bit, and want to jump straight...

Coalesce wrapped last week with more than 120 community-led sessions covering the newest tools and tactics in data. While many speakers had deep experience in...

Today, dbt Labs is announcing the new and improved Cloud IDE, available to all users by the 28th of October

The dbt Semantic Layer extends the portfolio of information managed in dbt to move dbt Labs beyond the data team.

When and why we turn to Python

Taking a beat to recognize the partners and individuals whose contributions to dbt Labs and the dbt Community went above and beyond this past year....

Spotlight on what's new in the latest release of dbt — and a happy v1.0 birthday coming up for dbt-utils

It is an incontrovertible truth of online communities that as they grow, new systems are required to keep them organized, friendly and inclusive.

A new data residency offering for dbt Cloud Enterprise customers in Europe.

A more ergonomic, safer version control experience is now here for dbt Cloud Enterprise customers.

Why it's time for dbt to support Python

The growing volume of data coupled with increased business use cases for analytics has created problems for data teams, especially around modeling, transforming, and interpreting...

Coalesce is entering its third year with the same charter—elevate data practitioners building the future of analytics engineering.

October 17-21, 2022: Coalesce is back and in-person! With 100+ speakers and sessions, 3 global locations and a virtual option, it’s a week you’re not...

A brief update on the dbt Cloud UI and what is changing.

Ernesto Ongaro, Solutions Architect at dbt Labs, stepped through best practices for securing your dbt Cloud deployment

We've partnered with Monte Carlo to make it simpler for analytics engineers to supplement dbt testing with end-to-end observability.

In this dbt Live: Expert Series session, Randy Pitcher demonstrated how to set up governance checks to enforce model standards to help you create a...

Catch up on the newest releases from the dbt Labs product team

Say hello to the newly formalized dbt Labs Technology Partner Program.

This piece is about how direct collaboration with engineers for event tracking is the best axe to wield in product analytics, and how our data...

Afzal Jasani, Solutions Architect at dbt Labs, gave a short tour of the data stack he built for a business close to home.

Sharing a little more on our plans for the dbt Semantic Layer.

With v1.2, we've made it easier to manage who (and what) can read the tables and views dbt creates in your warehouse.

Doug Guthrie, Solutions Architect at dbt Labs, demonstrated how to set up Github Actions to enforce SQL, documentation, and test standards, auto generate exposures, how...

Aaron Steichen, Solutions Architect at dbt Labs, reviewed testing and monitoring options for your dbt project.

Thoughts after attending Snowflake Summit 2022 in Las Vegas, Nevada.

dbt Labs recent underwent a massive overhauling of our OKR framework. Erica Louie, Head of Data, shares how we think about OKRs and a solution...

Mike Burke, Solutions Architect at dbt Labs, discussed the workflow and team structure that can bring analysts, data engineers, and other data stakeholders into closer...

This playbook dives into how dbt Labs thinks and implements reverse ETL workflows for our internal analytics work.

Lee Bond-Kennedy, Solutions Architect at dbt Labs, answered dbt Community member questions on how to store test results to examine them over time for trends...

Where we started... and where we're headed.

Sung Won Chung, Senior Solutions Architect at dbt Labs, answered common questions on how to pair dbt with Airflow in the latest dbt Live: Expert...

Read this blog post to learn how dbt values and treats its team members.

Introducing the new dbt Certification Program and the first dbt Analytics Engineering Certification exam.

A few words on the Cloud IDE, and how we’re planning to improve your experience in the coming months.

Read this blog post to learn about how to design a development workflow.

We are thrilled to announce that we will be opening up another round of our analytics engineering Foundry Program. The program will accept 2 apprentices...

Sean McIntyre, Senior Solutions Architect at dbt Labs, demonstrated how to refactor long scripts for modularity.

Read this blog post to learn about overriding schema generation.

Read this blog post to learn how dbt re-architected its scheduler to meet greater demand in dbt Cloud.

Experiencing dbt’s workflow on the lakehouse has never been easier.

dbt Labs raised another round of funding– $222m at $4.2b valuation. Existing investor Altimeter led the round, with participation from Databricks, GV, Salesforce Ventures, and...

Ongoing incidents with dbt Cloud have created slowness and lack of availability. Here is a recap of what happened and our plans to fix this....

As of January 1, 2022 I officially stepped down from my role as Chief Product Officer at dbt Labs. We've brought on Margaret Francis as...

Four modules designed to help the established analytics engineer plan for rapid growth.

Four modules of curated Coalesce content for teams just beginning their analytics engineering journey.

Covering both dbt Labs and dbt Cloud, these certifications represent a long-standing commitment to information security and privacy.

The metrics layer generated a lot of buzz at Coalesce, prompting some exciting and important conversations. In short: the dbt Server that will make metrics...

Last year we placed a big bet on foundational work — stability, reliability, and speed. 12 months, and a 600% increase in enterprise business later,...

dbt Core v1.0.0 has arrived. This major milestone enables users with production-grade workflows to safely and reliably build on top of dbt Core for years...

dbt Labs now offers five free courses for the emerging analytics engineer. Those new to dbt will find everything they need to get started (and...

Dec 6-10, 2021: Coalesce is back with 85 speakers, 65+ sessions, and a little razzle-dazzle. Targeting 4 time zones (EST, PST, GMT, and AEDT)—there are...

Exciting developments in our partnership with Snowflake.

Your code doesn't have to do the same thing everywhere it runs. Separate code from configuration - and set config based on context.

Where to begin when migrating legacy SQL transformation code to dbt? In a new (free!) on-demand course, analytics engineers from dbt Labs unpack the refactoring...

Choosing between continuous delivery and continuous deployment based on business needs

It's finally (almost) here. The best way to get ready is by upgrading *now* to the latest & greatest that dbt Core has to offer...

We are cancelling in-person events for the remainder of 2021. We know these are disappointing news but remain confident that it's the right decision for...

With the DAG-in-the-IDE (now available to all dbt Cloud users), analytics engineers can seamlessly navigate the core structure of their dbt project with low friction...

The data world needs more purple people — generalists who can navigate both the business context and the modern data stack. Let's put aside skillset...

Give your business teams access to transformed data in the tools they use every day. Hightouch now integrates with dbt to help you bring “Reverse...

Over the past few months, the dbt Labs’ recruiting team has partnered with leaders from our Engineering and Analytics Engineering organizations to design the Foundry...

Fishtown Analytics– now dbt Labs– was founded to bring analytics engineering to everyone. $150m in new funding will fuel the next phase of that journey....

Our friends at Materialize, the world’s first SQL-platform for processing streaming data, have officially launched a new dbt adapter, now available in open beta. Together,...

This SQL-first integration with Databricks means that analysts can build fully automated data pipelines in the same space that data engineers & data scientists work...

Staging is a ✨new✨ quarterly event that brings dbt users (that’s you!) into the product development lifecycle (where I spend my days 😅).

My thoughts on where our space has been and where it might be going.

Spark for analytics, for real: now in dbt Cloud

Fishtown Analytics has raised $29.5m in a Series B financing. New investor Sequoia Capital led the round with existing investors Andreessen Horowitz and Amplify Partners...

Translating business logic into code is technical knowledge. Building a marketing attribution model, forecasting, or calculating MRR is technical knowledge. Understanding the inner workings of...

Our thoughts on what makes a great conference pitch and lessons for future iterations of Coalesce.

Read this blog post to learn why analytics engineers are actually developers.

Read this blog post to learn about the future of Fivetran and dbt.

Fishtown Analytics started as a consulting company that competed with other dbt service providers. We are now a venture backed software company and our business...

Two amazing companies in the modern data stack–Fivetran and Census–have launched major integrations with dbt. Here's why I'm excited about this.

A startup's guide to modeling data following Kimball best practices

A recent post, Dashboards are Dead, sparked a conversation about the future of data reporting.

dbt is no longer a niche product and dbt Slack is no longer a community of misfits...we’ve gone mainstream, folks.

This article is written for job seekers. I’ve gathered a lot of data over the course of a month-long search and learned about what the...

A holistic data testing framework to help you catch data quality issues before they impact your stakeholders.

A Letter to the Community

For the foreseeable future, all in-person dbt events are cancelled. But we have some good stuff in the works.

dbt is four years old, and we are so grateful for the community that has grown alongside this project.

Marketing attribution has long been one of the stickiest problems in analytics. But with raw data, SQL, and dbt a previously complex problem can become...

The first global conference for analytics engineers

If you’re a data analyst at a SaaS company or an ecommerce business with a subscription component, it is inevitable that you will be asked...

The inability to bridge the chasm between IT and the business is the core dysfunction in modern data teams, and it’s also the biggest opportunity...

With the dbt Integrated Developer Environment (IDE) you can orchestrate the entire analytics engineering workflow in your browser.

Analytics code is code. Which means that it will have bugs. And without rigorous processes in place to find and eliminate those bugs, code quality...

Meet Sagar Velagala, Operations Manager at Lola.com. He's a one-person analytics team at a fast-growing, ~100 person company. Here's the analytics strategy that underpins his...

My love for group by 1, 2 developed when I was a fledgling analyst and has only grown. Even if you disagree, I hope this...

If your time is valuable, it should be important to you to operate with the highest possible leverage. This allows you to get more done...

Data teams are successful when they build reserves of trust. One important way to build trust is by consistently delivering projects on time. Here are...

All data analysts have faced the problem–how do I model data when the record in the data warehouse keeps changing? In this post, I'll cover...

Version control is a critical part of the software engineering workflow, but for many analysts, writing and reviewing pull requests is still a relatively new...

Modern data warehouses have upended the way that data teams function. Increasingly, companies are hiring a new kind of technical analyst to bridge the gap...

Stephen Whitworth, Data Engineering Lead at Monzo, spoke at the London dbt Meetup a few weeks ago. Here are my thoughts on his talk and...

The natural state of the universe is chaos: entropy tends to increase in closed systems, and there’s really nothing that we can do about that....

dbt v0.14.0 lays the foundation for dbt Develop -- a query editor which leverages the brand new dbt server.

680 companies use dbt every week, 2100 members of dbt Slack, dbt Cloud processed 140k jobs from 200 accounts in June, and we're hosting regular...

Holy crap! Within the past week we’ve seen the acquisitions of the two biggest players in the modern BI landscape, Looker and Tableau.

Unnesting arrays on Redshift is a pain, but it’s doable. This post walks through the entire process, start to finish.

Thoughts on pricing strategy and what it communicates about your company's vision for the future of the market you're in.

We just finished hosting the first dbt Learn. Here's why we did it, what we learned, and how you can get on board for the...

We've set up Snowflake accounts for quite a few clients and have an approach that we rather like.

As dbt is adopted by a wider community, we want to be extremely clear about when dbt is, and is not, a fit for your...

The Fishtown Analytics team is incredibly excited to announce that we’ve re-launched Sinter as dbt Cloud!

Sinter just became dbt Cloud. Why the re-brand?

In dbt’s latest release, we made some significant changes to how dbt processes these DAGs, and we’re seeing that these changes make dbt projects run...

The hardest thing about scaling a company is communication. Here's how our latest release will make data communication just a little bit easier.

The newest release of dbt, v0.11, ships with a built-in data documentation website for your dbt project.

dbt 0.10.2 introduces data model aliasing to help you maintain a more organized data warehouse design.

Sinter is the best way to deploy dbt in production at most organizations. It features rich scheduling functionality, accessible run logs and error alerting, and...

This week marks the second anniversary of Fishtown Analytics. Here's what we learned.

I just went through the process of converting 25,000 lines of SQL from Redshift to Snowflake. Here are my notes.

If you’re a hotshot junior analyst and you want a guide for breaking through this skills plateau, this guide is for you.

This is a very stupid problem. I am not writing this post because it’s a fascinating topic—rather, I’m writing it in the hopes that you...

Today, March 9th, 2018, dbt turned two years old. Wow. Here's where we've been and where we're heading.

I got this question on my last post. It is a good one, and one that I’ve gotten a bunch of times over the past...

dbt and Looker were built with the same ethos: analysts should be working in code.

dbt version 0.9.1 adds support for late binding views in Redshift. This post will explain late binding views and explore some potential uses

Frequently asked questions about Looker explores and how to design them very well.

Modular analytics tools allow companies to choose components to fit their needs and switch out or augment components as their needs change. Here's what I...

Want to go from syncing new data to having transformed data models built in minutes? Packages are going to be your friend.

We’re thrilled to announce the release of dbt version 0.9.0, including support for pivoting out columns and ignoring incongruent tables.

dbt (data build tool) enables data analysts and engineers to transform data in their warehouses.

This post is one of the first things that new employees read upon joining our team.

How to create historical records in your database using dbt data logs.

dbt, our open source product for data modeling, is SQL-only. SQL can, by itself, accomplish a majority of analytical (non-data science) workloads.

Fishtown Analytics celebrates its one year anniversary today.

You need analytics.

Over the past nine months I’ve worked with over a dozen venture-funded startups to build out their internal analytics. In doing so, there’s a single...

This post, originally published in 2016, was most recently updated in November 2017.

Business intelligence tech has changed really dramatically over the past 3-4 years since the advent of cloud-based analytics databases.

There’s a new small business that just opened up in Fishtown and it’s not a gin bar or artisanal coffee shop.

Over the past three months I’ve been in the lab building Fishtown Analytics. There’s a lot of the company formation process that’s been fun for...

Today is a big day. Today, Magento announced it has purchased RJMetrics. The RJMetrics product will form the foundation of Magento Analytics, giving Magento users...

When a software engineer starts on a new project, her first step is almost always to survey the ecosystem of open source software that exists...

Over the past year, I and the folks at RJMetrics have had the opportunity to observe, and participate in, a significant evolution of the analytics...