Posted in Query

Understanding a basic query in Snowflake

   November 17, 2023

These next three queries will:

  1. Assume the tasty_data_engineer role via USE ROLE
  2. Leverage the tasty_de_wh Warehouse via USE WAREHOUSE
  3. Query our raw_pos.menu table to find which Menu Items are sold at our Plant Palace branded food trucks.
USE ROLE tasty_data_engineer;
USE WAREHOUSE tasty_de_wh;

SELECT
    m.menu_type_id,
    m.menu_type,
    m.truck_brand_name,
    m.menu_item_name
FROM frostbyte_tasty_bytes.raw_pos.menu m
WHERE m.truck_brand_name = 'Plant Palace';