TIQETS.ENGINEERING

Managing data warehouse views with dbt at Tiqets

At Tiqets, we maintain a number of derived views in our data warehouse. Instead of always going back to the raw data to answer a question, we model the data so it represents more “high-level” abstractions that are useful to the business. For example, we derive:

  • active customers from orders

These views have been very useful in preventing repetitive work, but also in improving our understanding of the business. However, they were also a pain to manage.

We made heavy use of…

rrbarbosa

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store