Data Load using COPY INTO Command in Snowflake
The COPY INTO command in Snowflake is a powerful tool for efficiently loading data from staged files into tables.
Snowflake
HOW TO: Make External API calls from Snowflake?
Explore how Snowflake offers a secure and efficient way to make external API calls directly within its environment.
RESULT_SCAN in Snowflake
RESULT_SCAN in Snowflake retrieves the results of a previously executed query and presents them as a virtual table allowing to run subsequent queries
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.
Introduction to Snowflake Notebooks
Snowflake Notebooks provide an interactive environment to write, execute, and document SQL and Python code in one interface.
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.