A Simple Query to Ensure Data Quality During a Migration
This past year at Eventbrite we’ve been moving the infrastructure that supports our analytical workloads from a bevy of open-source tools (Presto, Hive, Luigi, Superset) to more managed-services (Snowflake, dbt). Working on the Analytics Engineering team, we’ve been tasked with migrating …
Query to generate models .yml file contents
Writing out the schema.yml file (or the whatever-you-want-to-name-it.yml file) for models in a mart / schema in your dbt project can take a long time, especially if you have a mart / schema with lots of tables with lots of columns. Instead of manually typing every table and column name out,
Just run …