dbt News

Lauren Craigie 31 Oct 2022 October 31, 2022 Lauren Craigie

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 to the talks built for those with a little more experience—these replay tracks were made for you.

Lauren Craigie 28 Oct 2022 October 28, 2022 Lauren Craigie

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 analytics engineering and dbt—most attendees did not! If you're just getting up to speed in this space, check out this selection of talks for the emerging analytics engineer.

Nate Nunta 18 Oct 2022 October 18, 2022 Nate Nunta

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

Cameron Afzal 18 Oct 2022 October 18, 2022 Cameron Afzal

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

Cody Peterson 18 Oct 2022 October 18, 2022 Cody Peterson

When and why we turn to Python

Amos Budde 17 Oct 2022 October 17, 2022 Amos Budde

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.

Jeremy Cohen | Joel Labes 17 Oct 2022 October 17, 2022 Jeremy Cohen, Joel Labes

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

Jason Ganz | Jillian Corkin | Leona Campbell 14 Oct 2022 October 14, 2022 Jason Ganz, Jillian Corkin, Leona Campbell

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

Sai Maddali 12 Oct 2022 October 12, 2022 Sai Maddali

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

Julia Schottenstein 11 Oct 2022 October 11, 2022 Julia Schottenstein

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

Tristan Handy 12 Sep 2022 September 12, 2022 Tristan Handy

Why it's time for dbt to support Python

Sharon Rehana 9 Sep 2022 September 9, 2022 Sharon Rehana

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 data. In this blog, we discuss four common pain points data teams experience and how dbt brings everyone into the data pipeline without having to rely on data engineers.

Tristan Handy 26 Aug 2022 August 26, 2022 Tristan Handy

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

Kira Furuichi 23 Aug 2022 August 23, 2022 Kira Furuichi

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 going to want to miss. Find out what’s new and what to expect from the third year of the Analytics Engineering Conference.

Jeremy Hutt 22 Aug 2022 August 22, 2022 Jeremy Hutt

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

Joey Malysz | Matt Sulkis 18 Aug 2022 August 18, 2022 Joey Malysz, Matt Sulkis

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

Brian Gillet 12 Aug 2022 August 12, 2022 Brian Gillet

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 more consistent dbt project experience for your developers and data users.

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

Nikhil Kothari 2 Aug 2022 August 2, 2022 Nikhil Kothari

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

Andrew Escay | Kira Furuichi 1 Aug 2022 August 1, 2022 Andrew Escay, Kira Furuichi

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 team went about benchmarking IDE performance.

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

Drew Banin 26 Jul 2022 July 26, 2022 Drew Banin

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

Jeremy Cohen 25 Jul 2022 July 25, 2022 Jeremy Cohen

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

Brian Gillet 22 Jul 2022 July 22, 2022 Brian Gillet

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 to push dbt Cloud job run metadata to Datadog for analysis and more in this dbt Live: Expert Series APAC session..

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

Azzam Aijazi 5 Jul 2022 July 5, 2022 Azzam Aijazi

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

Erica Louie | Kira Furuichi 5 Jul 2022 July 5, 2022 Erica Louie, Kira Furuichi

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 to measuring them that works for us.

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

Brandon Thomson | Kira Furuichi 28 Jun 2022 June 28, 2022 Brandon Thomson, Kira Furuichi

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

Brian Gillet 17 Jun 2022 June 17, 2022 Brian Gillet

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 and more in this dbt Live: Expert Series APAC session.

Aaron Raff 16 Jun 2022 June 16, 2022 Aaron Raff

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 Series session.

Meghan Colón 7 Jun 2022 June 7, 2022 Meghan Colón

In 2021 dbt Labs grew from 55 to 194 team members (current org size here). We had a voluntary turnover rate of 3.2% during a year when industry benchmarks hit 17.8%!

Laurent Goldsztejn 3 Jun 2022 June 3, 2022 Laurent Goldsztejn

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

Nate Nunta 2 Jun 2022 June 2, 2022 Nate Nunta

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

Brian Gillet 27 May 2022 May 27, 2022 Brian Gillet

The dbt Live: Expert Series is a new 60-minute interactive experience where dbt Labs Solution Architects share practical advice on how to tackle the sticky problems we see come up over and over again in the field—like how to safely split environments with CI/CD, or how to implement blue/green deployments.

Jen Mancino 27 May 2022 May 27, 2022 Jen Mancino

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 who are interested in getting into the analytics engineering field.

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

Brian Gillet 18 May 2022 May 18, 2022 Brian Gillet

The dbt Live: Expert Series is a new 60-minute interactive experience where dbt Labs Solution Architects share practical advice on how to tackle the sticky problems we see come up over and over again in the field—like how to safely split environments with CI/CD, or how to implement blue/green deployments.

Julia Schottenstein 27 Apr 2022 April 27, 2022 Julia Schottenstein

… just not a good one to keep! In this two part series you’ll learn how we rearchitected our scheduler to meet greater demand in dbt Cloud. For those looking for more technical detail, check out the second post, in which an engineer on this team breaks down the architecture we started with, the technical...

Nikhil Kothari 14 Apr 2022 April 14, 2022 Nikhil Kothari

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

Tristan Handy 24 Feb 2022 February 24, 2022 Tristan Handy

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 Snowflake. The raise will fuel our investment in building the next layer in the modern data stack.

Connor McArthur 23 Feb 2022 February 23, 2022 Connor McArthur

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.

Drew Banin 3 Feb 2022 February 3, 2022 Drew Banin

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 our new CPO. I'm incredibly excited to be transitioning into an individual contributor role.

Lauren Craigie 21 Dec 2021 December 21, 2021 Lauren Craigie

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

Lauren Craigie 21 Dec 2021 December 21, 2021 Lauren Craigie

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

Randy Hanooman 16 Dec 2021 December 16, 2021 Randy Hanooman

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

Tristan Handy 10 Dec 2021 December 10, 2021 Tristan Handy

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 accessible will be source available. This will provide users control, while enabling us to build a sustainable business.

Sai Maddali 9 Dec 2021 December 9, 2021 Sai Maddali

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.

Jeremy Cohen 8 Dec 2021 December 8, 2021 Jeremy Cohen

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.

Alexis Wong Baird 7 Dec 2021 December 7, 2021 Alexis Wong Baird

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.

Fatima Conteh 8 Nov 2021 November 8, 2021 Fatima Conteh

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 November 1, 2021 Nikhil Kothari

Exciting developments in our partnership with Snowflake.

Julia Schottenstein 26 Oct 2021 October 26, 2021 Julia Schottenstein

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 October 13, 2021 Christine Berger

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 September 30, 2021 Julia Schottenstein

Choosing between continuous delivery and continuous deployment based on business needs

Jeremy Cohen 23 Sep 2021 September 23, 2021 Jeremy Cohen

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 August 25, 2021 Rosie Sampaio Cardoso

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 August 19, 2021 Tristan Handy

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 July 30, 2021 Anna Filippova

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 July 28, 2021 Azzam Aijazi

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 July 16, 2021 Meghan Colón

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 June 30, 2021 Tristan Handy

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 June 2, 2021 Amy Chen

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 May 4, 2021 Amy Deora

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 January 14, 2021 Simon Ouderkirk

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

Tristan Handy 1 Dec 2020 December 1, 2020 Tristan Handy

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

Jeremy Cohen 12 Nov 2020 November 12, 2020 Jeremy Cohen

Spark for analytics, for real: now in dbt Cloud

Tristan Handy 11 Nov 2020 November 11, 2020 Tristan Handy

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 October 29, 2020 Emilie Schario

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 October 21, 2020 Mila Page

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

Tristan Handy 15 Oct 2020 October 15, 2020 Tristan Handy

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 October 14, 2020 Tristan Handy

Many folks may not know it, but George (Fivetran’s Co-Founder and CEO) and I go way back. We started out as mortal enemies when I was helping to launch Stitch while Fivetran was in its still-nascent days back in 2015 😄 Since I founded Fishtown Analytics in 2016, though, we’ve been close partners and have...

Tristan Handy 1 Oct 2020 October 1, 2020 Tristan Handy

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 September 22, 2020 Tristan Handy

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 September 17, 2020 Andrea Fabry

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

Tristan Handy 12 Aug 2020 August 12, 2020 Tristan Handy

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

Tristan Handy 2 Jul 2020 July 2, 2020 Tristan Handy

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 June 25, 2020 Danielle Leong

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 June 18, 2020 Andrea Fabry

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

Tristan Handy 22 Apr 2020 April 22, 2020 Tristan Handy

A Letter to the Community

Claire Carroll 7 Apr 2020 April 7, 2020 Claire Carroll

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 March 17, 2020 Drew Banin

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

Claire Carroll 16 Mar 2020 March 16, 2020 Claire Carroll

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 January 31, 2020 Tristan Handy

The first global conference for analytics engineers

Claire Carroll 17 Jan 2020 January 17, 2020 Claire Carroll

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 January 14, 2020 Tristan Handy

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 January 14, 2020 Drew Banin

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 January 7, 2020 Erin Vaughan, Janessa Lantz

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.

Janessa Lantz 8 Oct 2019 October 8, 2019 Janessa Lantz

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 October 3, 2019 Claire Carroll

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 September 24, 2019 Tristan Handy

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 September 17, 2019 Tristan Handy

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 September 10, 2019 Claire Carroll

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 September 5, 2019 Erin Vaughan

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 August 13, 2019 Erin Vaughan

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.

Claire Carroll 22 Jul 2019 July 22, 2019 Claire Carroll

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 July 15, 2019 Claire Carroll

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 July 10, 2019 Drew Banin

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 July 2, 2019 Tristan Handy

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 June 10, 2019 Tristan Handy

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 May 14, 2019 Tristan Handy

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 May 4, 2019 Tristan Handy

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 April 9, 2019 Erica Louie

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 March 22, 2019 Jeremy Cohen

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

Claire Carroll 11 Mar 2019 March 11, 2019 Claire Carroll

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 January 16, 2019 Drew Banin

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

Tristan Handy 16 Jan 2019 January 16, 2019 Tristan Handy

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

Drew Banin 8 Jan 2019 January 8, 2019 Drew Banin

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 6 Sep 2018 September 6, 2018 Tristan Handy

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 September 6, 2018 Drew Banin

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

Drew Banin 3 Aug 2018 August 3, 2018 Drew Banin

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

Connor McArthur 31 Jul 2018 July 31, 2018 Connor McArthur

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 July 6, 2018 Tristan Handy

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

Tristan Handy 13 Jun 2018 June 13, 2018 Tristan Handy

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 April 8, 2018 Jason Ganz

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 March 16, 2018 Tristan Handy

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 March 9, 2018 Drew Banin

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 January 29, 2018 Tristan Handy

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 January 16, 2018 Tristan Handy

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

Drew Banin 9 Jan 2018 January 9, 2018 Drew Banin

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 January 2, 2018 Tristan Handy

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

Tristan Handy 11 Dec 2017 December 11, 2017 Tristan Handy

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 October 30, 2017 Erin Vaughan

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 October 26, 2017 Drew Banin

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 October 17, 2017 Tristan Handy

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

Tristan Handy 11 Sep 2017 September 11, 2017 Tristan Handy

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

Connor McArthur 18 Jul 2017 July 18, 2017 Connor McArthur

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

Tristan Handy 4 Jul 2017 July 4, 2017 Tristan Handy

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 July 1, 2017 Tristan Handy

Fishtown Analytics celebrates its one year anniversary today.

Tristan Handy 31 Mar 2017 March 31, 2017 Tristan Handy

You need analytics.

Tristan Handy 9 Mar 2017 March 9, 2017 Tristan Handy

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 September 18, 2016 Tristan Handy

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

Tristan Handy 18 Sep 2016 September 18, 2016 Tristan Handy

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 September 13, 2016 Tristan Handy

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 August 3, 2016 Tristan Handy

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 August 1, 2016 Tristan Handy

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 May 11, 2016 Tristan Handy

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 April 5, 2016 Tristan Handy

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.