Snowflake Database - Querying Data Part 1

Part 1 of our discussion on worksheets, where you will spend most of your time writing queries.

Part 2 of our discussion on worksheets, where you will spend most of your time writing queries.

A brief note about the two getting started lectures on Snowsight.

Part 1 of our discussion on Snowsight. The replacement for Snowflake worksheets.

Here we discuss what appears to be a large variety of data types Snowflake supports. But, in reality, they all boil down to a relatively few types.

In this lecture we demonstrate how to get the DDL statement for any object in Snowflake

In this lecture we talk about the data dictionary built into Snowflake, the Information_Schema.

In this lecture we talk about the account usage views and queries, which are similar to information schema

Oracle developers have been able to use Connect By for a long time. Snowflake supports it as well.

In this discussion we demonstrate the user of Limit (Postgres), Fetch (Ansi standard) for retrieve a certain number of rows of data. And we discuss the Offset statement.

Part 1 of a discussion on Snowflake's support for Windowing functions

Part 2 of our discussion on Snowflake Windowing functions

There will be times you will need to generate data. Snowflake has a number of queries you can execute to generate various types of data.

In this lecture we cover the fascinating topic of row pattern recognition queries.

In this lecture we discuss the types of joins available in Snowflake

In this lecture we talk about Snowflake's support for different types of subqueries

A discussion about how to create and use CTEs (Common Table Expressions)

In this lecture we cover some very common and some very interesting date/time functions.

In this lecture we demonstrate how to do some time travel queries

In this lecture we talk a bit about queries to pivot and unpivot data

Snowflake supports regular expression queries. In this lecture we demonstrate how to use them.

These are queries you will frequently use in Snowflake

This lecture goes into some detail on how to perform query performance monitoring in Snowflake

This lecture demonstrated how to execute and interpret the Snowflake Explain statement.

An overview of semi-structured data

Snowflake allows you to query data sitting in external stages and external tables. We talk about this in this lecture.

There are types of stages other than external. We briefly talk about those in this lecture.

Here we wrap up our discussion of stages, specifically external stages and tables.

In this lecture we talk about a few file formats that are not as well known as CSV but Snowflake is still able to query them.

In this lecture we demonstrate work with, and querying, Parquet files.

A short prelude about the lecture that is to follow

In this lecture we talk about the fantastic way Snowflake allows us to query JSON data.

Time for a little practice to test what you have learned