Source
Aggregation policies
Aggregation policies allow a provider (data owner) to exercise control over what can be done with their data even after it is shared with a consumer. Specifically, the provider can require a consumer of a table to aggregate the data rather…
Python user-defined aggregate functions
An aggregate function aggregates state in child nodes and then, eventually, those aggregate states are serialized and sent to the parent node where they get merged and the final result is calculated.
Creating User-Defined Aggregate Functions (UDAFs) for DataFrames in Python
You can use Snowpark Python APIs to create and call user - defined aggregate functions (UDAFs). A UDAF takes one or more rows as input and produces a single row of output.
Considerations for semi-structured data stored in VARIANT
This topic provides best practices, general guidelines, and important considerations for loading and working with VARIANT values that contain semi - structured data. This can be explicitly - constructed hierarchical data or data that you have…
How to Search, Create, Vote & Follow Ideas
Snowflake Ideas is a great place for our customers to share feature requests, enhancements, and general ideas while allowing us to share where they are on our roadmap.
Cross DB platform table data validation using MD5 BITXOR aggregation
ISSUE: Often after data from other database vendors like Oracle, MS SQL, PostgreSQL, and Teradata is migrated, data needs to be validated in a meaningful and timely manner.
Implicit aggregation could happen when using disjunctive condition in EXISTS clause
There are aggregation operations being put after join operations. And in fact, such aggregations could bring performance issues when tables get large vertically or horizontally.
DESCRIBE MODEL MONITOR
PARTIALLY_SUSPENDED: An error condition in which one of the underlying tables has stopped refreshing at the expected interval. See DESCRIBE for more details. UNKNOWN: An error condition in which the state of the underlying tables cannot be…
Selecting objects for AI code conversion
This topic describes the functions available on the Select Objects page, when running AI code conversion. Tree view The tree view as shown above displays the structure of databases and schemas in the converted workload, along with the…
HowTo: Update properties for all Snowflake Users
FAQ: The following sample script informs you on how to update the 'email' property for every user to a different domain (xyz.com). This can be altered for other properties as well.