Name		Name	Last commit message	Last commit date
parent directory ..
FY25_Zero_To_Snowflake		FY25_Zero_To_Snowflake
README.md		README.md
tb_introduction.sql		tb_introduction.sql
tb_zts_collaboration.sql		tb_zts_collaboration.sql
tb_zts_data_governance.sql		tb_zts_data_governance.sql
tb_zts_financial_governance.sql		tb_zts_financial_governance.sql
tb_zts_geospatial.sql		tb_zts_geospatial.sql
tb_zts_semi_structured_data.sql		tb_zts_semi_structured_data.sql
tb_zts_transformation.sql		tb_zts_transformation.sql

README.md

Tasty Bytes - Quickstarts File Repository

If you are brand new to Tasty Bytes we ask that you please reference An Introduction to Tasty Bytes - Quickstart.

This Quickstart is a Prerequisite for many other Powered By Tasty Bytes - Quickstarts available.

The FY25 Zero to Snowflake folder contains .sql files that walkthrough modular feature/function demos for which you can learn more on below:

Cost Management
- Learn about Snowflake Virtual Warehouses and their configurabilities, Resource Monitors, Account and Warehouse Level Timeout Parameters, and Exploring Cost.
Transformation
- Learn about Snowflake Cloning, Caching, Table Manipulation, Time-Travel and Table level Swap, Drop and Undrop functionality.
Semi-Structured Data
- Learn about Snowflake VARIANT Data Type, Semi-Structured Data Processing via Dot and Bracket Notation and Lateral Flattening, Array Functions, View creation, and Snowsight Charting.
Governance with Snowflake Horizon
- Learn about Snowflake System Defined Roles, Role Based Access Control, Tag Based Masking, Policies (Row-Access, Aggregation, and Projection), Data Classification, Access History and Universal Search.
Collaboration
- Learn about the Snowflake Marketplace by leveraging free, instantly available, live data from Weathersource to conduct data driven analysis harmonizing first and third party sources.
Geospatial
- Learn Snowflake's Geospatial capabilities, beginning with obtaining free, real-time data from SafeGraph. Progress through creating geographic points (ST_POINT), measuring distances (ST_DISTANCE), aggregating coordinates (ST_COLLECT), establishing a Minimum Bounding Polygon (ST_ENVELOPE), determining areas (ST_AREA), identifying central points (ST_CENTROID), and executing advanced Geospatial Analysis using the H3 (Hexagonal Hierarchical Geospatial Indexing System).