HOW TO: Execute SQL Statements in Snowflake Snowpark?
Snowpark allows direct execution of SQL statements using the session.sql() method in conjunction with collect() method.
Snowflake
DATEADD Function in Snowflake: Add or Subtract Time Intervals from Dates
DATEADD Function in Snowflake calculates a date or timestamp value by adding a specified interval to a given date or timestamp.
Snowflake Alerts: Schedule Conditional SQL Statements
A Snowflake Alert allows scheduled execution of conditional SQL statements, enabling users to monitor specific events or thresholds within their environment.
HOW TO: Send Email Notification in Snowflake?
Snowflake offers built-in stored procedures SYSTEM$SEND_EMAIL and SYSTEM$SEND_SNOWFLAKE_NOTIFICATION for sending email notifications.
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.
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.