Madison Schott

SQL case statements are great, but a lot of times they can be replaced by a simpler, more readable function. Let's look at a SQL case statement and how this can be replaced by the IFNULL function -->

@dbt_labs @Snowflake Overall, I'm most excited to see how performance improves through the new Fusion engine! I do have my hesitations, though, about dbt Canvas, as this will require some thoughtful considerations for how to implement it across your team. What do you think? Are you excited?

@dbt_labs @Snowflake 🆕 dbt Explorer is now dbt Catalog For Snowflake users, you can now search through tables and views previously only in Snowflake, making it easier to find data assets.

dbt Labs just launched something HUGE. Here's what you need to know and what it means for you as analytics engineers: ➡️

Want a deeper dive on data modeling? 🔔 Be sure to follow me to learn from upcoming Data Modeling May posts! 📧 And subscribe to my newsletter (link in bio) for weekly analytics engineering resources.

Other benefits of data models include: - improved data quality - increased scalability - ability to test - better data warehouse performance

Data Modeling May- Day #1 Why do I need a data model? Data models take data from multiple sources, transform it, and deliver it in a way that makes querying easier.

Do you ever wake up and your brain just decides to choose chaos for the day? Yup, that's me right now. A thousand thoughts a minute, but also extreme productivity. Is this a blessing or a curse? 😅

One of my phrases for 2025 was "just go for it". So I signed up for a memoir writing class and seriously can't wait. I've always loved memoirs and have wanted to learn how to write one for the longest time! If there's something you want to do... just go for it!

@purva_sawant_p Love it!

@madisonmaeorg Data Modeling tricks.

I'm giving away a 3-month subscription to my paid newsletter, Learn Analytics Engineering. All you need to do is comment below something you want to learn in 2025. ⬇️ ⬇️ ⬇️

This is a job opportunity you don't want to miss! Our engineering team is building some really awesome features.

🔔 Don't forget to follow along so you can see new dbt tips in the month of December!

When setting up persist_docs with dbt, ask yourself the questions: Who is using the model? Do they have access to dbt docs? This will help you determine whether or not to enable this feature on the table in your data warehouse!

🎄Day 4 of 12 days of dbt- persist_docs Have you ever noticed the different properties available on fields when you describe a table in your data warehouse? Your warehouse allows you to see the datatype, null status, and other features of your columns.