Common Table Expressions (CTEs) in Snowflake
A Common Table Expression (CTE) in Snowflake is a named subquery used within the execution scope of the query in which it is specified.
Data Management and Utilities
DATEDIFF Function in Snowflake: Calculate the difference between two dates
The DATEDIFF function in Snowflake facilitates the calculation of the difference between two date, time, or timestamp values.
GREATEST and LEAST Functions in Snowflake
The GREATEST function in Snowflake retrieves the largest value whereas the LEAST function returns the smallest value from a list of expressions.
Change Data Capture using Snowflake Dynamic Tables
Snowflake Dynamic Tables track the changes in the query data specified and refresh the materialized results incrementally through an automated process.
QUALIFY in Snowflake: Filter Window Functions
QUALIFY clause in a SELECT statement allows you to filter query results of Window functions within the same query.
GROUP BY ALL in Snowflake
The GROUP BY ALL clause is similar to GROUP BY clause except that it automatically include all non-aggregate items in the SELECT clause for grouping.
HOW TO: Find and Kill long running queries in Snowflake?
Learn how to find and kill long running queries in Snowflake using the QUERY_HISTORY table functions available under Information Schema.
HOW TO: Get DDL of database objects in Snowflake?
Snowflake provides GET_DDL Function using which DDL of database objects like tables, views, procedures etc., can be extracted.
HOW TO: Remove Duplicates in Snowflake?
Learn different ways to remove duplicate records from a Snowflake table using SWAP WITH and INSERT OVERWRITE commands.
Snowflake Resource Monitors
Snowflake Resource Monitors assist in cost management and prevent unforeseen credit usage caused by operating warehouses.