Snowflake for SQL Users: Set This Up Before Your First Query
⚙️ Check out the brand new Intro to Snowflake course at Maven Analytics 👉 https://bit.ly/4qvlBkZ If you already know SQL, you're most of the way to using Snowflake. But there's one thing that trips up almost everyone on day one, and it's not the SQL. It's everything you have to set up before you even write your first query. In this video, Maven Analytics instructor Alice Zhao walks you through it so you can skip the frustration and hit the ground running. What you'll learn: 👉 Why your first Snowflake query returns an error 👉 What "context" means in Snowflake and why it matters 👉 The four things you must set before running any query: role, warehouse, database, and schema 👉 Two different ways to set your context in Snowflake Interested in Analytics Engineering? Check out Alice's Analytics Engineering 101 Course! ⚙️ https://bit.ly/4wim1fz ⏱️ Timestamps: 00:00 – The one thing that trips up every SQL user in Snowflake 00:21 – Why your query returns an error 00:43 – Setting your role 01:03 – Setting your warehouse 01:40 – Setting your database 01:58 – Setting your schema 02:39 – Recap and two ways to set context Maven Analytics is an award-winning learning platform where individuals and teams build new skills, showcase work, and connect with experts around the world. We've helped 2M+ people build job-ready data literacy & AI skills, master tools like Excel, SQL, Power BI, Tableau and Python, and build the foundation for successful careers. Start building life-changing skills for FREE 👉 https://bit.ly/4bIcbMC