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.
Get Started Today
Recent Posts
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.
Take a quick peek into all Course offerings
Automation
Ideas
Best Automation ideas with detailed explanation to implement in IICS Projects
TEST YOUR KNOWLEDGE
Test your knowledge on important various IICS and Snowflake concepts
Interview Preparation
Top Interview Questions to get you prepared before your interview