What should I learn to build semantic data models in Snowflake?
Hi everyone,
I work mainly with SQL, reporting, and dashboards, but I’ve recently been given the opportunity to take on a larger data project at my company.
We have data across several systems and databases, including SQL Server, PostgreSQL, and a CRM. We’re currently bringing these sources into Snowflake, and that part is nearly complete. The next step is to clean and organize the data, create reliable semantic data models, and make it easier for people to use the data for reporting and analysis.
This is my first time working on a proper data warehouse project, so I’m trying to understand what I should learn before going too far in the wrong direction.
From what I’ve researched so far, I probably need to focus on dimensional modelling, fact and dimension tables, star schemas, dbt, data quality testing, and Snowflake best practices. But I’m not sure what the most practical learning path would be, or whether I’m missing anything important.
If you’ve worked on a similar project, what topics would you recommend focusing on first? Are there any courses, books, YouTube channels, or hands-on projects that helped you understand how to design good data models in Snowflake?
I’d really appreciate any advice or learning recommendations. Thanks!