HOW TO: Delete Rows From a DataFrame in Snowflake Snowpark?
Discover how to delete rows from a DataFrame in Snowpark using Table.update() and Session.sql() methods.
Snowflake
Introduction to Snowflake Notebooks
Snowflake Notebooks provide an interactive environment to write, execute, and document SQL and Python code in one interface.
HOW TO: Merge two DataFrames in Snowflake Snowpark?
Table.merge() method in Snowpark allows merging the contents of a Snowpark table object with a DataFrame source based on a specified join condition.
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.
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.