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.
Snowflake
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.
UDFs in Snowflake Snowpark
Discover how to create User Defined Functions (UDFs) in Snowpark and register them in Snowflake.
HOW TO: Update a DataFrame in Snowflake Snowpark?
Discover how to update contents of a DataFrame in Snowpark using Table.update() and Session.sql() methods.
Window Functions in Snowflake Snowpark
Discover how to utilize Window Functions in Snowpark to calculate aggregated values across related rows efficiently.
IN Operator in Snowflake Snowpark
Learn how to implement IN operator that allows you to specify multiple values in a WHERE clause to filter the data from Snowpark DataFrame.
Joins in Snowflake Snowpark
Learn how to perform a join on the data of the current DataFrame with another DataFrame based on a list of columns in Snowpark.
GROUP BY in Snowflake Snowpark
Learn how to implement GROUP BY clause in Snowpark that helps in grouping of rows based on specified columns to perform aggregate calculations.