dbt News

In this workshop, we will share the key insights and design patterns that we have identified in helping numerous data teams build flexible, trustworthy customer-facing data experiences and machine learning platforms backed by dbt.

In 2019, the data community realized there an emerging role called Analytics Engineer. In 2020 came Operational Analytics, and in 2021 Revenue Analytics.

YAML is hard. We all want to involve our business customers more in what we do, but the command line is just too scary for many.

Incremental models are core to dbt, and are a key solution to how data teams balance the need for computationally efficient and timeline data.

Sai Maddali 9 Dec 2021

Last year we placed a big bet on foundational work — stability, reliability, and speed. 12 months, and a 600% increase in enterprise business later, we're focused on establishing dbt as the default standard for all enterprise data teams.

The Data Mesh is an architectural paradigm that decentralises data into product teams over a centralised data team. Combining dbt and the data mesh creates an explosion of dbt users and with it many organisational challenges.

Never heard of data pipelines? Building your first data pipeline? Already have a data pipeline and just want to scope new trends? This is the workshop for you.

In our talk we would like to walk you through our journey from our custom-built transformations to using dbt as the framework and platform for all our data needs.

Data-driven teams will be behind the most amazing human achievements in the next decade, from curing cancer to developing self-driving cars.

Ahmed will present a new data modeling approach called the activity schema. It can answer any data question using a single time series table (only 11 columns).

This talk will explore the common challenges companies face when modeling hundreds of millions or even billions of events, and how to solve them. We'll discuss the differences between the cloud data warehouses as well as incrementalization, performance tuning and testing.

By leveraging best practices from DevOps and software engineering, we’ve found that data teams can resolve broken pipelines faster, and long before stale dashboards, null values, or duplicate data issues impact downstream data consumers.

The "modern data stack" and dbt are often positioned as the current best option for organisations to aim for and the end point of transformation projects. That this is not the end... this is just the beginning.

A talk oriented towards data team managers (current, future, aspiring). Here, we'll read aloud our "love letters" to our past and present managers.

Learn how Degreed is upskilling their insights analysts with analytics engineering skills!

What if dbt was able to connect to multiple databases at once and cut on costs and development time? Or even better, avoid lock-in into a data warehouse engine?

Jeremy Cohen 8 Dec 2021

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 to come. Take a look at how we got here, and what's next for dbt.

In this talk, I'll tell the story about our stack, our changing schemas and how I used dbt to make life easier for both the engineers instrumenting tracking as well as the executives consuming downstream reporting.

This session is will help Team Leads and Committed End Users understand how they can integrate dbt, and the data warehouse into the very core of their product.

Christian Kleinerman | Tristan Handy 8 Dec 2021

Snowflake is at the forefront of changing the way modern data teams work with the Data Cloud. In this session, Christian Kleinerman, Snowflake's SVP of Product,

In our talk, we’d like to share a deep dive into how we do it and why it works. In particular, we’ll talk about our overall philosophy, then dig into our development workflows and CI/CD pipelines. Finally we will cover how we scaled all that to put data engineering tools into the hands of our entire GetUpside team.

How might we make analytics a part of the company culture? Something that engineers care about as much as product managers?

Tune in with Kevin Marr from Firebolt to learn about current trends in data warehousing and how they will impact tomorrow's data workflows.

Companies today need a product analytics platform to enable product insights that are quick to access and easy to understand and act upon. How can you prepare?

A story of how 2 motivated actuaries implemented a solution to fix our broken actuarial data pipelines using the dbt CLI, without engineering or developers.

Drew Banin 8 Dec 2021

While dbt's open source roots has always made this much easier, we believe in a world where the entire analytics ecosystem grows with us, from Core, to Cloud, and beyond.

This session is a deep dive into three ways the dbt Cloud API can be used to foster a culture of greater awareness: through real time monitoring, impact analysis, and historical understanding.

We believe the future of analytics workflows is polyglot and will embrace better interoperability between languages and UIs.

Astasia Myers | Jennifer Li | Julia Schottenstein | Sarah Catanzaro 8 Dec 2021

A panel discussion about trends in the data space. Hear from venture capitalists on what's new and interesting in the ecosystem.

For most people, the modern data stack isn’t a collection of architectural diagrams; it’s an experience.

Jeremy Cohen 8 Dec 2021

Jeremy will offer a highlight reel of the biggest changes included in dbt v1.0, as well as honorable mentions for some neat ideas that ended up on the cutting-room floor.

Databricks, Delta Lake, & DBT provide the perfect trio for saving investment management firms money and boosting productivity by allowing analysts to deploy SQL pipelines much faster.

In this talk, we will introduce Deepnote, a collaborative data science notebook and how you can use it with dbt to introduce more collaboration into your team’s data modelling and exploratory workflows.

Alexis Wong Baird 7 Dec 2021

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 badged!) in our dbt Learn Fundamentals course, while seasoned users can go deeper on topics like macros, materializations, and project refactoring.

Jason Ganz 7 Dec 2021

This talk is about envisioning the world of five years from now when every organization has an Analytics Engineering department.

In this talk we will demonstrate how to get started with streaming analytics using the same analytics engineering skillset that keeps you productive in batch.

If you are trying to figure out how one builds a diverse team, do not ask your black co-worker how you should go about doing it.

This talk is about how modern data teams working in the “data as product” and “analytics engineering” models can benefit from using prototyping practices.

Catalog & Cocktails is bringing its unique brand of insight, humor, and conversation to Coalesce. The weekly podcast is an honest, no-BS, and non-salesy conversation about enterprise data management and analytics with a happy-hour vibe.

Delivering high impact, high velocity, high quality data products in highly volatile data contexts.

Emilie Schario 7 Dec 2021

I propose we lobby against the title Data Scientist, instead choosing some variation of the Core Four Data Roles: Data Analyst, Analytics Engineer, Data Engineer, and Machine Learning Engineer.

How I was able to adopt dbt coming from an industrial engineering background, and how it can be leveraged by end users with a quality control mindset to solve common business problems.

Have you ever felt that you were not the intended audience of the technology you consume? Are there software design paradigms that simply do not work for you?

Using dbt artifacts we were able to create a central monitoring and alerting system that notified people if a specific dbt model failed.

I will illustrate these ideas with a demonstration of the {dbtplyr} dbt package which helps analytics engineers get the most value from controlled vocabularies by making it easier to effectively exploit column naming structures while coding.

How my team decreased query time in Looker and saved Snowflake credits, by materializing views and tables and implementing tags for job schedules.

Hiring is a critical point in influencing company and team culture and for bringing on folks who can really get the job done.

Attendees will walk away with some recommendations for creating their own data product strategy that will be useful no matter what scale they are operating on.

A dbt package is not only a way to make a particular process easier or more robust or more efficient – it can also be a way to productionize/share practices.

One of our biggest wins so far has been finding clever ways to incrementalize our longest-running tables, while still solving for 2 main pain points.

We'll show our method to automate source transformations. Aula's growth and a proliferation of nonrelational sources required constant manual maintenance to our dbt project -- which was sucking up the data team's capacity.

This session will cover our own analytical use cases, as well as features Fivetran is building to support dbt in the open-source community, like our Visual Studio Code integration, Fivetran-managed dbt packages and our Transformations product line.

Learn what questions you should be asking before seeking out consultants, what a successful engagement should look like, and how to align your internal talent with external strengths that best serve your team.

Claire Carroll 6 Dec 2021

Together, we’ll demystify the git flow and build a mental model for how git works. You’ll leave the talk feeling ready to use git on every project you work on!

Ever wondered how to build up a dbt project from the ground up? How do you know when good enough is good enough?

As data analytics becomes a cornerstone for modern companies, understanding who owns what in the data organization has never been more confusing—or important.

Martin Casado | Tristan Handy 6 Dec 2021

The modern data stack is the third generation of data analysis products to come to prominence since the 90's.

Investing in analytics engineering was a game-changer for our ability to deliver value as a data organization, but it didn't happen overnight.

Erica Louie 6 Dec 2021

This is an overview of how our Data team is structured, how we interact with the greater org, the general operations, and our expectations/responsibilities.

Rosie Sampaio Cardoso 6 Dec 2021

Are you interested in learning more about our dbt Meetups, or how to become a Meetup organizer in your community?

In this panel, we'll bring on an assortment of thought leaders and data practitioners to discuss how and why companies are using cloud data warehouses for operations today.

Drew Banin | Reynold Xin 6 Dec 2021

Reynold Xin is a technical co-founder and Chief Architect at Databricks. He’s also a co-creator and the top contributor to the Apache Spark project.

Alexis Wong Baird | Jonathan Natkins 6 Dec 2021

If dbt is new to you, join us in this session to get up to speed. We'll go through the basics and give you all the information you need to get the most value out of this conference!

Fatima Conteh 8 Nov 2021

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 plenty of opportunities to join us live. Find out what’s new, what’s staying the same, and how to prepare.

Nikhil Kothari 1 Nov 2021

Exciting developments in our partnership with Snowflake.

Julia Schottenstein 26 Oct 2021

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

Christine Berger 13 Oct 2021

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 process they've employed across dozens of projects.

Julia Schottenstein 30 Sep 2021

Choosing between continuous delivery and continuous deployment based on business needs

Jeremy Cohen 23 Sep 2021

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

Rosie Sampaio Cardoso 25 Aug 2021

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 safely engaging with the dbt Community.

Tristan Handy 19 Aug 2021

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 and low cognitive load, making the entire development process more intuitive, pleasant, and efficient.

Anna Filippova 30 Jul 2021

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 dichotomies, and learn to feel comfortable in the space between.

Azzam Aijazi 28 Jul 2021

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 ETL” to your stack.

Meghan Colón 16 Jul 2021

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 Program. This program will provide a gateway for those that are new to the field or looking to make a career change.

Tristan Handy 30 Jun 2021

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.

Amy Chen 2 Jun 2021

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, we’re opening the door for analysts to become first-class creators and users of streaming analytics.

Amy Deora 4 May 2021

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 in their preferred frameworks.

Simon Ouderkirk 14 Jan 2021

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

Watch Evy Kho's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Andrea Kopitz's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Johnathan Brooks's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Jacob Mulligan and Dom Colyer's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Nadja Jury's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Krishna Naidu and Jose Galarza's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Jonathan Mak's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Caitlin Moorman's talk replay from the Coalesce analytics engineering conference in 2020.

Bart Sandbergen | Rob Winters | Simon Ouderkirk | Teodora Vrabcheva | Virginia López-Gil Pérez 13 Dec 2020

Watch Rob Winters, Bart Sandbergen, Virginia López-Gil Pérez, Teodora Vrabcheva and Simon Ouderkirk's talk replay from the Coalesce analytics engineering conference in 2020.

Watch John Napoleon-Kuofie's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Shannon Morales's talk replay from the Coalesce analytics engineering conference in 2020.

Amy Chen | Benjamin Singleton | Christopher Holliday | Ryan Goltz 13 Dec 2020

Watch Chris Holliday, Amy Chen, Ryan Goltz and Ben Singleton's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Sam Foltin's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Alan Cruickshank's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Pietro Casella and Erik Ferm's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Bastien Boutonnet and Jean-François Lairie's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Benn Stancil's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Sam Bail's talk replay from the Coalesce analytics engineering conference in 2020.

Brian de la Motte | Emilie Schario | Francisco Lozano | Laurie Voss 12 Dec 2020

Watch Emilie Schario, Laurie Voss, Francisco Lozano and Brian de la Motte's talk replay from the Coalesce analytics engineering conference in 2020.

Alexis Johnson-Gresham | Colleen Tartow, Ph.D. | Ilse Ackerman | Meghan Colón 12 Dec 2020

Watch Ilse Ackerman, Alexis Johnson-Gresham, Colleen Tartow, PhD and Meghan Colón's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Andres Recalde's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Anna Bladey's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Dave Fowler's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Nick Schrock's talk replay from the Coalesce analytics engineering conference in 2020.

Emilie Schario | Taylor A. Murphy, PhD 12 Dec 2020

Watch Emilie Schario and Taylor Murphy's talk replay from the Coalesce analytics engineering conference in 2020.

Drew Banin 12 Dec 2020

Watch Drew Banin's talk replay from the Coalesce analytics engineering conference in 2020.

Barr Moses | David Wallace | Drew Banin | Jon Loyens | Matt Allen 12 Dec 2020

Watch Drew Banin, Barr Moses, Jon Loyens, Matt Allen and David Wallace's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Emily Hawkins's talk replay from the Coalesce analytics engineering conference in 2020.

Christine Berger 11 Dec 2020

Watch Christine Berger's talk replay from the Coalesce analytics engineering conference in 2020.

Janessa Lantz | Stephanie Morillo 11 Dec 2020

Watch Stephanie Morillo and Janessa Lantz's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Vincey Au's talk replay from the Coalesce analytics engineering conference in 2020.

Watch David Murray's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Kenny Ning's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Jacob Frackson's talk replay from the Coalesce analytics engineering conference in 2020.

Tristan Handy 11 Dec 2020

Watch Tristan Handy's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Ashley Van Name's talk replay from the Coalesce analytics engineering conference in 2020.

Ashley Van Name | Carly Kaufman | Mila Page 11 Dec 2020

Watch Carly Kaufman, Mila Page and Ashley Van Name's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Jennifer Li, Boris Jabes, Jeremy Levy and Arjun Narayan's talk replay from the Coalesce analytics engineering conference in 2020.

Watch Grant Winship and Sanjana Sen's talk replay from the Coalesce analytics engineering conference in 2020.

Andrew Escay | Christine Berger | Erica Louie 10 Dec 2020

Watch Andrew Escay, Christine Berger and Erica Louie's talk replay from the Coalesce analytics engineering conference in 2020.

Carly Kaufman | Claire Carroll 10 Dec 2020

Watch Carly Kaufman and Claire Carroll's talk replay from the Coalesce analytics engineering conference in 2020.

Tristan Handy 1 Dec 2020

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

Jeremy Cohen 12 Nov 2020

Spark for analytics, for real: now in dbt Cloud

Tristan Handy 11 Nov 2020

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 participating. Matt Miller of Sequoia joined our board.

Emilie Schario 29 Oct 2020

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 the business is technical knowledge. So...is there such a thing as a non-technical data analyst?

Mila Page 21 Oct 2020

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

Tristan Handy 15 Oct 2020

I originally wrote this as a part of our new analyst onboarding program back in June of 2017, shared with new analysts on their first day. It’s as true today as it was the day I wrote it, so I wanted to publish it more broadly. Maybe you’ll find it useful!

Tristan Handy 14 Oct 2020

June 11, 2021 update – This post hasn’t aged as well as I would’ve hoped. George makes a strong statement in it: “Fivetran is not fundamentally a company that is focused on data transformation.” That statement appears to be less true today than it was in October of 2020. In a recent conversation, George indicated...

Tristan Handy 1 Oct 2020

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 model has fundamentally changed. Our relationship with dbt service providers is now 100% partnership.

Tristan Handy 22 Sep 2020

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.

Andrea Fabry 17 Sep 2020

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

Tristan Handy 12 Aug 2020

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

Claire Carroll 17 Jul 2020

We’re taking some steps to bring back the ✨magic ✨ in the dbt community. First stop — focusing the different ways the dbt community interacts with each other.

Tristan Handy 2 Jul 2020

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

Danielle Leong 25 Jun 2020

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 landscape looks like for the analytics engineer hiring pipeline.

Andrea Fabry 18 Jun 2020

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

Tristan Handy 22 Apr 2020

A Letter to the Community

Claire Carroll 7 Apr 2020

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

Drew Banin 17 Mar 2020

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

Claire Carroll 16 Mar 2020

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 beautifully simple.

Tristan Handy 31 Jan 2020

The first global conference for analytics engineers

Claire Carroll 17 Jan 2020

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 to analyze metrics like churn, upgrades, and downgrades. Here's how to do this with dbt.

Tristan Handy 14 Jan 2020

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 for progress.

Drew Banin 14 Jan 2020

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

Erin Vaughan | Janessa Lantz 7 Jan 2020

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 will degrade over time.

Erin Vaughan | Janessa Lantz 29 Oct 2019

The data team is a brand new thing: it’s not IT, it’s not finance...so who does it report to? How big is it?

Claire Carroll 16 Oct 2019

Analytics engineers provide clean data sets to end users, modeling data in a way that empowers end users to answer their own questions.

Janessa Lantz 8 Oct 2019

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 success.

Claire Carroll 3 Oct 2019

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 rant will inspire you to be more opinionated in your SQL style.

Tristan Handy 24 Sep 2019

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 with your fixed number of hours. Simple. Here's how analysts can operate with leverage.

Tristan Handy 17 Sep 2019

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 four questions we've found to be useful in helping us spot the potholes that derail analytics engineering projects.

Claire Carroll 10 Sep 2019

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 how to solve this using dbt snapshots.

Erin Vaughan 5 Sep 2019

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 habit. Here's a checklist we use to review analytics PRs.

Erin Vaughan 13 Aug 2019

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 between data engineers and data analysts. Here's why and how you can hire one too.

Erin Vaughan | Janessa Lantz 13 Aug 2019

How to screen for curiosity when making your next analytics engineering hire (example interview questions included).

Erin Vaughan 6 Aug 2019

Advice from analysts and data engineers at HubSpot, Managed by Q, GitLab, Wong Decision Intelligence, AskWonder, and Calogica

Claire Carroll 22 Jul 2019

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 what the dbt community can learn from it.

Claire Carroll 15 Jul 2019

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. So too is the nature of data warehouses: unless action is taken to maintain order.

Drew Banin 10 Jul 2019

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

Tristan Handy 2 Jul 2019

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 dbt Meetups in 3 cities (NY, SF, London). What a year!

Tristan Handy 10 Jun 2019

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

Tristan Handy 14 May 2019

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

Tristan Handy 4 May 2019

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

Erica Louie 9 Apr 2019

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 next one.

Jeremy Cohen 22 Mar 2019

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

Claire Carroll 11 Mar 2019

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 project. This guide will help you figure out if dbt is right for your data transformations.

Drew Banin 16 Jan 2019

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

Tristan Handy 16 Jan 2019

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

Drew Banin 8 Jan 2019

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 about 30% faster.

Tristan Handy 2 Jan 2019

The role of the data engineer in a data team is changing rapidly. Are you thinking about it the right way?

Tristan Handy 6 Sep 2018

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

Drew Banin 6 Sep 2018

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

Drew Banin 3 Aug 2018

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

Connor McArthur 31 Jul 2018

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 customizable job definitions. Today, it just got better.

Tristan Handy 6 Jul 2018

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

Tristan Handy 13 Jun 2018

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

Jason Ganz 8 Apr 2018

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

Tristan Handy 16 Mar 2018

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 avoid the headaches I've gone through.

Drew Banin 9 Mar 2018

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

Tristan Handy 29 Jan 2018

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 year and a half. This post is my attempt to answer it.

Tristan Handy 16 Jan 2018

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

Drew Banin 9 Jan 2018

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

Tristan Handy 2 Jan 2018

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

Tristan Handy 11 Dec 2017

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 think is missing from the market.

Erin Vaughan 30 Oct 2017

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

Drew Banin 26 Oct 2017

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

Tristan Handy 17 Oct 2017

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

Tristan Handy 11 Sep 2017

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

Connor McArthur 18 Jul 2017

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

Tristan Handy 4 Jul 2017

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

Tristan Handy 1 Jul 2017

Fishtown Analytics celebrates its one year anniversary today.

Tristan Handy 31 Mar 2017

You need analytics.

Tristan Handy 9 Mar 2017

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 SQL function that I have come to use surprisingly often.

Tristan Handy 18 Sep 2016

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

Tristan Handy 18 Sep 2016

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

Tristan Handy 13 Sep 2016

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

Tristan Handy 3 Aug 2016

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 me. I love checklists, and treated the opening of this business as a really big one.

Tristan Handy 1 Aug 2016

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 powerful tools to analyze their customers’ behavior.

Tristan Handy 11 May 2016

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 in the problem space.

Tristan Handy 5 Apr 2016

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 ecosystem. The center of gravity in mature analytics organizations has shifted away from proprietary, end-to-end tools towards more composable solutions.

Christine Berger

Git is the version control system of choice for data teams worldwide - see how we wield it internally at dbt Labs.

Two fundamental technological advances, ETL tools and cloud data warehouses, enable analytics engineers to practice the ELT workflow.

Follow the career path of Adam Stone, an analytics engineer on Netlify's data team.

Find your next analytics job. Open roles listed for data analysts, analytics engineers, data engineers, data scientists and ML engineers.

Erin Vaughan | Janessa Lantz

Over the last four years, the data team at Snaptravel has grown from one analyst to almost a dozen, and they've experimented with five data team structures.

Data testing helps your analytics team move faster - let's explore what to test, and when to test it.

Christine Berger | David Krevitt | Randy Pitcher

Explore practical examples of modular data modeling techniques from traditional to modern and modular techniques.

Exploring how we use data notebooks internally on the team, and how platforms like Hex & Querybook are making SQL-based notebooks a reality.

We've all heard the buzz, but how does implementing a reverse ETL tool actually improve your operational analytics work in practice?

The tale of migrating from a stored procedure-based ELT workflow to an ELT data transformation workflow on BigQuery, and the 3x productivity gains that ensued.

Reporting quality can make or break your data team's reputation - will your colleagues cherish your visualizations, or question their validity?

Follow the career path of Tom Nagengast, an analytics engineer on Netlify's data team.

Organize your organization's information with a high-quality data documentation process.

Mila Page

In 2016, Tristan Handy wrote about the need for data analysts to start working like software engineers. How's that transition going?

Cleanly transformed data is table stakes for predictive modeling. How can analytics teams collaborate to make transformed datasets easily accessible?