Using Python variable substitution

Now that you've had exposure to Snowflake Notebooks, you will go a step further by performing an analysis using SQL and Python.

Your manager would like to understand how many reviews exist for Executive Resorts hotels in Mexico. They created a notebook, exercise_1_3.ipynb, located in This PC > Desktop > Resources, but didn't finish their analysis. They've asked you to take over and complete this task.

In SQL cells, use the table's full path in your FROM clause. Get it from the left panel: Databases tab → expand your COURSE_… database → select the REVIEWS table → Copy name.