Snowflake Data Warehouse Tutorials

In this Snowflake tutorial, you will learn what is Snowflake, it’s advantages, using SonwSQL CLI to interact with the cloud and different connectors.

Snowflake database is a purely cloud-based data storage and analytics Data warehouse provided as a Software-as-a-Service (SaaS). Snowflake database is architecture and designed an entirely new SQL database engine to work with cloud infrastructure.

Unlike traditional databases, you don’t have to download and install the database to use Snowflake, instead, you just need to create an account online, this gives you access to the web console, access the console and create the database, schema, and tables. Access the database and tables either by Web console, ODBC, and JDBC drivers and third party connectors.

Though underlying architecture is different it shares the same ANSI SQL syntax and features hence learning Snowflake is easy and fast if you are coming from SQL background.

Snowflake Advantages

In this section of the Snowflake tutorials, we will see some advantages of the Snowflake data warehouse database.

  • No software to Install except SnowSQL to interact with the cloud database server.
  • No hardware setup and regular patch updates are not required.
  • Its architecture allows us to execute queries very fast.
  • Supports large datasets.
  • Easy to scale.
  • Supports standard SQL and analytics queries.

SnowSQL

In this Snowflake SnowSQL tutorials, you will learn to install SnowSQL on windows/Mac and interacting with the cloud database using SnowSQL CLI from your system.

General SQL

Loading data files to Snowflake table

In this section of the Snowflake tutorial, you will learn how to load the CSV, Parquet, Avro, JSON data files from the local file system or cloud (Amazon, Azure, GCP e.t.c) into Snowflake table.

Unloading data from Snowflake table

In this section, you will learn how to unload the Snowflake table into CSV, Parquet, JSON or Avro files and download it to either your local file system or to Cloud storage.

Snowflake Drivers & Connectors

In this section of the Snowflake database tutorial, you will learn different connectors and drivers available and how to use these to connect to Snowflake database and execute DDL, DML e.t.c

Snowflake Spark Tutorials with Examples

Here you will learn working scala examples of Snowflake with Spark Connector, Snowflake Spark connector “spark-snowflake” enables Apache Spark to read data from, and write data to Snowflake tables. When you use a connector, Spark treats Snowflake as data sources similar to HDFS, S3, JDBC, e.t.c.

Snowflake Scala Examples

Snowflake Java Examples

References