Daily Sales in Snowflake for NY Restaurant

This project involves analyzing competitors of "RareBurger" in the New York area by querying data from Snowflake Marketplace. The SQL code provided selects relevant data, such as location, region, postal code, and various spending metrics, from both the "RareBurger" restaurant's revenue data and a sample dataset of other NYC restaurants. By filtering the competitors using the CATEGORY_TAGS field to include only those tagged as 'Burger', the query effectively identifies and aggregates information on competing burger establishments in the area. First, SQL queries were used to set up the tables. Second the Schemas were created, then the databases and warehouses configured in Snowflake. Next, SQL queries were used to narrow the desired data and load the tables. As our data was spread across two sources, a joining query was required. Also, the restaurant results were filtered to return only those businesses focused on burgers.