Introduction to Snowflake SQL

Introduction to Snowflake SQL

George Boorman

Senior Curriculum Manager, DataCamp

Connecting to Snowflake

  • Snowsight: Snowflake Web Interface

Snowflake Web UI left panel images showing database objects and worksheets

Introduction to Snowflake SQL

Worksheets

Snowflake Web Interface showing worksheet and results of query

Introduction to Snowflake SQL

Notebooks

Snowflake notebook using Python and SQL code cells

Introduction to Snowflake SQL

Connecting to Snowflake: Drivers

 

Drivers & Connectors

  • ODBC (Open Database Connectivity)
  • JDBC (Java Database Connectivity)
  • Connectors : Python, Spark, and more
1 https://docs.snowflake.com/en/developer-guide/drivers
Introduction to Snowflake SQL

Connecting to Snowflake: Snowflake CLI

Snowflake CLI

 

  • Command-line client
    • Installed on Linux, Windows, or Mac
1 https://docs.snowflake.com/en/user-guide/snowsql
Introduction to Snowflake SQL

SQL flavors

  • Snowflake uses Snowflake SQL

 

  • Other popular SQL flavors:

    • PostgreSQL
    • T-SQL
    • MySQL

  • Some differences in data types, functions, and general syntax

Introduction to Snowflake SQL

Common syntax

  • SELECT
  • FROM
  • WHERE
  • GROUPBY
  • ORDER BY
  • AVG(), COUNT(), SUM() (etc)
  • DISTINCT
  • HAVING
  • JOIN*

*Some differences exist, more on this later!

Introduction to Snowflake SQL

Let's practice!

Introduction to Snowflake SQL

Preparing Video For Download...