Within this Tasty Bytes Introduction Quickstart you will first be learning about the fictious food truck brand, Tasty Bytes, created by the frostbyte team at Snowflake.
After learning about the Tasty Bytes Organization, we will complete the process of setting up the Tasty Bytes Foundational Data Model, Workload Specific Roles + Warehouses and all necessary Role Based Access Control (RBAC).
Upon finishing this Quickstart, you will have deployed the foundation required to run the Quickstarts seen in our Powered by Tasty Bytes - Quickstarts section.
For this Quickstart, you will use the Snowflake web interface known as Snowsight. If this is your first time leveraging Snowsight we would highly consider taking a look at our Snowsight Documentation for a high-level walkthrough.
frostbyte_tasty_bytes setup is now complete.
With the Tasty Bytes Setup successful, we can now explore the Database, Roles and Warehouses we created.
This query will return the Database we created via SHOW DATABASES using our SYSADMIN role.
USE ROLE sysadmin; SHOW DATABASES LIKE 'frostbyte_tasty_bytes';
This query will return the Schemas within the Database we created via SHOW SCHEMAS.
SHOW SCHEMAS IN DATABASE frostbyte_tasty_bytes;
This query will return the Tables within the
raw_pos schema via SHOW TABLES
SHOW TABLES IN SCHEMA frostbyte_tasty_bytes.raw_pos;
This query will return the Roles we created via SHOW ROLES.
SHOW ROLES LIKE 'tasty%';
This query will return the Warehouses we created via SHOW WAREHOUSES.
SHOW WAREHOUSES LIKE 'tasty%';
These next three queries will:
tasty_data_engineerrole via USE ROLE
tasty_de_whWarehouse via USE WAREHOUSE
raw_pos.menutable 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';
Amazing! Within a few minutes we now have a Tasty Bytes demo environment complete with data, roles and warehouses set up in our Snowflake account. Let's now take a look at all of the other Tasty Bytes Quickstarts available to us to leverage.
Congratulations! You have now completed the Tasty Bytes Foundational Setup!
The Table of Contents below will outline all of the available Tasty Bytes Quickstarts that leverage the foundation you just built.