Aggregate Functions in Snowflake Snowpark
Aggregate functions perform a calculation on a set of values and return a single value, often used in conjunction with the GROUP BY clause.
Snowflake
HOW TO: COPY Data from CSV Files INTO Snowflake Table using Snowpark?
A comprehensive guide to copy data from CSV files into Snowflake tables using Snowpark
HOW TO: Write data into Snowflake from a Snowpark DataFrame?
Learn how to write data into Snowflake and save as table from a Snowpark DataFrame.
HOW TO: Create and Read Data from Snowflake Snowpark DataFrames?
DataFrame is a core abstraction in Snowpark representing a query in your chosen language which gets converted into SQL to execute your code in Snowflake.
Introduction to Snowflake Snowpark for Python
The Snowpark is an intuitive library that offers an API for querying and processing data at scale in Snowflake.
DATEDIFF Function in Snowflake: Calculate the difference between two dates
The DATEDIFF function in Snowflake facilitates the calculation of the difference between two date, time, or timestamp values.
GREATEST and LEAST Functions in Snowflake
The GREATEST function in Snowflake retrieves the largest value whereas the LEAST function returns the smallest value from a list of expressions.
Snowflake Dynamic Tables: Change Data Capture Simplified
Snowflake Dynamic Tables track the changes in the query data specified and refresh the materialized results incrementally through an automated process.
QUALIFY in Snowflake: Filter Window Functions
QUALIFY clause in a SELECT statement allows you to filter query results of Window functions within the same query.
GROUP BY ALL in Snowflake
The GROUP BY ALL clause is similar to GROUP BY clause except that it automatically include all non-aggregate items in the SELECT clause for grouping.