ASOF Join in Snowflake
ASOF JOIN in Snowflake matches each row in one table to the closest row in another table based on a specified condition, typically involving time series data.
Snowflake
MIN_BY and MAX_BY Functions in Snowflake
MIN_BY and MAX_BY are aggregate functions in Snowflake that calculate the minimum or maximum value of a column and return the value of another column in that row.
HOW TO: Drop a Column from a Snowpark DataFrame?
Learn how to drop a column from a Snowflake Snowpark DataFrame using drop() method with examples.
HOW TO: Add a New Column to a Snowpark DataFrame?
Learn multiple ways to add a new column to a Snowpark DataFrame that includes adding a column with default value, based on a condition, and adding multiple columns with examples.
HOW TO: Remove Duplicates in a Snowpark DataFrame?
The dropDuplicates() method in Snowpark returns a new DataFrame with all duplicate rows removed.
CASE Statement in Snowflake Snowpark
Learn how a CASE statement can be constructed in Snowflake Snowpark using when() and otherwise() methods.
INSERT and Multi-Table Inserts in Snowflake
Learn how to perform Insert, Multi-Row Insert and Multi-Table Inserts in Snowflake using INSERT and INSERT ALL statements.
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.
Creating Snowflake Iceberg tables using AWS Glue as Catalog
An Externally Managed Iceberg Table is a table where an external system such as AWS Glue manages both the table data and metadata.
HOW TO: Create Snowflake Iceberg Tables?
A Snowflake Iceberg table Snowflake employs the Apache Iceberg format for organizing and storing data within the Snowflake data warehouse environment.