Company News Three years in: things are heating up 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!
Opinion A wave of acquisitions in business intelligence Holy crap! Within the past week we’ve seen the acquisitions of the two biggest players in the modern BI landscape, Looker and Tableau.
How-To How to unnest arrays in Redshift Unnesting arrays on Redshift is a pain, but it’s doable. This post walks through the entire process, start to finish.
Opinion Pricing-vision fit Thoughts on pricing strategy and what it communicates about your company's vision for the future of the market you're in.
Product News dbt Learn: analytics engineering for data analysts 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.
How-To How we configure Snowflake At Fishtown Analytics, we've set up Snowflake accounts for several dozen clients and have an approach we like quite a lot.
Opinion Is dbt the right tool for my data transformations? 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.
Product News Introducing dbt Cloud The Fishtown Analytics team is incredibly excited to announce that we’ve re-launched Sinter as dbt Cloud!
Product News How we made dbt runs 30% faster 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.
Opinion Does my startup data team need a data engineer? The role of the data engineer in a startup data team is changing rapidly. Are you thinking about it the right way?
Product News Using dbt docs The newest release of dbt, v0.11, ships with a built-in data documentation website for your dbt project.
Product News Scaling knowledge The hardest thing about scaling a company is communication. Here's how our latest release will make data communication just a little bit easier.
Product News Data warehouse design with dbt 0.10.2 dbt 0.10.2 introduces data model aliasing to help you maintain a more organized data warehouse design.
Product News Sinter Release Notes, August 2018: pull request builder, fine-grained GitHub permissions, and more 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.
Company News Two years in and it's just getting good This week marks the second anniversary of Fishtown Analytics. Here's what we learned.
How-To One analyst's guide for going from good to great If you’re a hotshot junior analyst and you want a guide for breaking through this skills plateau, this guide is for you.
How-To How to safely convert strings to integers in Redshift 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.
Product News On two years of dbt Today, March 9th, 2018, dbt turned two years old. Wow. Here's where we've been and where we're heading.
How-To “How do you decide what to model in dbt vs LookML?” 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.
How-To How to Integrate dbt and Looker with User Attributes dbt and Looker were built with the same ethos: analysts should be working in code.
Product News Using Redshift’s late binding views with dbt 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
How-To How to design your Looker Explores Frequently asked questions about Looker explores and how to design them very well.
Opinion The missing layers of the analytics stack 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.
How-To Installing dbt packages Want to go from syncing new data to having transformed data models built in minutes? Packages are going to be your friend.
