Snowpark

Snowpark allows direct execution of SQL statements using the session.sql() method in conjunction with collect() method.

Learn how to drop a column from a Snowflake Snowpark DataFrame using drop() method with examples.

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.

The dropDuplicates() method in Snowpark returns a new DataFrame with all duplicate rows removed.

Learn how a CASE statement can be constructed in Snowflake Snowpark using when() and otherwise() methods.

Discover how to create User Defined Functions (UDFs) in Snowpark and register them in Snowflake.

Discover how to update contents of a DataFrame in Snowpark using Table.update() and Session.sql() methods.

Discover how to utilize Window Functions in Snowpark to calculate aggregated values across related rows efficiently.

Learn how to implement IN operator that allows you to specify multiple values in a WHERE clause to filter the data from Snowpark DataFrame.

Learn how to perform a join on the data of the current DataFrame with another DataFrame based on a list of columns in Snowpark.