Snowpark

Discover how to delete rows from a DataFrame in Snowpark using Table.update() and Session.sql() methods.

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.