Wrap-up
Introduction to Snowflake SQL
George Boorman
Senior Curriculum Manager, DataCamp
Chapter 1: Snowflake SQL and key concepts
Connecting to Snowflake
- WEB UI
- Drivers & Connectors
- Snowflake CLI
Chapter 1: Snowflake SQL and key concepts
VARCHARNUMBERTIMESTAMP_LTZ
Data Type conversion - What, Why, How?
Conversion Fucntions:
TO_VARCHAR, TO_DATE
STRING functions:
CONCAT, INITCAP
DATE & TIME functions:
CURRENT_DATE, CURRENT_TIME
EXTRACT functions:
GROUP BY ALL
Chapter 2: Advance Snowflake SQL Concepts
JOINS
NATURAL JOINLATERALJOIN
Subquerying
CTEs
Chapter 2: Advance Snowflake SQL Concepts
Snowflake Query Optimization
- Common query problems: Exploding Joins,
UNIONvsUNION ALL - Rewriting queries:
TOP,LIMIT, Early filtering, AvoidSelect *`
Semi structured data
PARSE_JSON,OBJECT_CONSTRUCT- Querying JSON data in Snowflake
Is this all?
- Much more to unfold
Not addressed
- Setting context
- Roles, Users
- Setting up Virtual Warehouses
- Window functions
- Query profiling
- Materialized Views
- Clustering
...
Useful resources
- Snowflake documentation: https://docs.snowflake.com/
- Snowflake forums: https://community.snowflake.com/s/forum
- Introduction to Data Modeling in Snowflake
- Snowflake Tutorial
This is just the beginning!
Introduction to Snowflake SQL
