Introduction to Snowflake SQL

1. Introduction to Snowflake SQL

Welcome to the course, where we will discuss Snowflake SQL! In this video, we'll explore various methods of connecting to Snowflake and some of the common syntax between Snowflake SQL and other SQL flavors, such as PostgreSQL. Let's dive right in!

2. Connecting to Snowflake

There are different ways to connect to Snowflake. One of the most user-friendly options is the Snowflake Web Interface, called Snowsight.

3. Worksheets

For those looking to execute SQL queries, Snowflake provides 'Worksheets', an interface for creating and running SQL queries. Here, as shown, we can create a Worksheet containing the query, results, and execution details such as query duration.

4. Notebooks

Within Snowsight, we can also create Notebooks. These can be used to run both SQL and Python code, a powerful combination for tasks such as building and maintaining data pipelines!

5. Connecting to Snowflake: Drivers

Beyond its web interface, Snowflake can be used via drivers, which allow communication between its databases and external applications and tools such as Tableau. Two common drivers include ODBC, which stands for Open Database Connectivity, and JDBC, or Java Database Connectivity. Additionally, there are specialized connectors for programming languages like Python, to enhance Snowflake integration.

6. Connecting to Snowflake: Snowflake CLI

The Snowflake CLI is another way to directly connect to our Snowflake account using the command line. Before using the Snowflake CLI, we need to install it. Snowflake offers versions for Linux, Windows, and Mac. Throughout this course, we'll mainly interact via the Snowflake CLI, occasionally referencing PostgreSQL for comparative understanding.

7. SQL flavors

Regardless of how we connect to Snowflake and execute queries, we will always use Snowflake SQL, a flavor of SQL. Snowflake SQL is similar to other SQL flavors, such as PostgreSQL, T-SQL, and MySQL. These flavors have similarities and differences in terms of data types, functions, and general syntax.

8. Common syntax

The majority of Snowflake SQL and PostgreSQL syntax is the same, including keywords and functions such as `SELECT`, `FROM`, `WHERE`, `GROUPBY`, and many others. This means that if we've been working with PostgreSQL then we can already execute a variety of queries using Snowflake SQL!

9. Let's practice!

In the next video we will begin examining some of Snowflake SQL's unique syntax. In the meantime, let's practice writing some queries.

Create Your Free Account

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.