))
Season 2: Episode #25 | Building a Reusable SQL Library: Best Practices & Pitfalls
Manage episode 491158920 series 3610392
Content provided by Ievgen & Vadym. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Ievgen & Vadym or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://ppacc.player.fm/legal.
🔍 Tired of finding five versions of the same SQL file – all with different numbers? In this episode, Vadym and Helen break down the mess (and the fix) behind reusable SQL libraries.
Whether you're cleaning up metrics, onboarding faster, or scaling your analytics stack, this episode is your practical guide to building a library that works.
What you’ll learn:
🪤 Common pitfalls teams face when SQL logic is scattered
🧱 What makes a good SQL library – and why it boosts speed, not slows it
🔁 Real-world story: from 400 queries to 25 clean data marts
🛠 Tools like dbt, Dataform, GitHub, Looker, and OWOX Data Marts
📁 5 best practices for building a clean, trusted, and versioned library
➡️ Explore OWOX BI and simplify your SQL workflows
🤝 Join our open-source community and contribute to SQL libraries
👉 Get trusted reports with your context in 1 minute
👉 OWOX Website
👉 Analytics with OWOX BI YouTube Channel
35 episodes
Share
