Member-only story
Why we choose dbt as transformation tool on top of Snowflake
The purpose of this article is to tell you why we procured dbt as transformation tool when we have all other tools as options out in the world
Hey There! I work for an airline and I am part of “Data Platform Team”. We use AWS analytic services and Snowflake in combination to build and deploy data pipelines into production.
Background:
In Finnair, We have different LOB (Line of Business). Stakeholders from different LOB’s access data from Snowflake. They are SQL savvy’s.
- So needed a simple platform so that analytic process can be democratized
Key Considerations by my manager:
Before discussing the pre-requisites for this article, I want to provide some context for the overall direction. My manager, Juha Castrén (Head of Data Platform), has shared some considerations. These include the following points:
- Prepared data sets available so that BI tools no need to focus on transforming in dashboarding tools
- Very hard to find out which dashboard is using which distribution layer or who is actually consuming
- We wanted to use products or tools are part of Enterprise support so that we can focus on business delivery’s
