公开(公告)号：US20250139076A1

公开(公告)日：2025-05-01

申请号：US18496734

申请日：2023-10-27

Applicant: Snowflake Inc.

Inventor： Pradeep Dorairaj ,  Garrett Frere ,  Carsten Stann ,  Boyu Wang ,  Mengjia Xia

IPC: G06F16/22 ,  G06F16/242 ,  G06F16/2453

Abstract: The subject technology receives first data. The subject technology transforms first data to a wide format, the wide format comprising a second table. The subject technology splits a set of rows into a set of shards of rows. The subject technology, for each shard from the set of shards, sends a particular user defined table function (UDTF), including a particular shard of rows, to a different execution node to perform a set of operations for determining a rolling correlation over a window size. The subject technology provides a set of output values of each particular UDTF corresponding to each shard from the set of shards in a second UDTF. The subject technology sends the second UDTF to a particular execution node to perform an aggregate operation. The subject technology receives a value of the rolling correlation from the particular execution node based on the aggregate operation.