Snowflake inc. (20250094418). DYNAMIC PIVOT IMPLEMENTATION USING OBJECT AGGREGATION
DYNAMIC PIVOT IMPLEMENTATION USING OBJECT AGGREGATION
Organization Name
Inventor(s)
Srilakshmi Chintala of Seattle WA US
Naresh Kumar of Santa Clara CA US
Srinath Shankar of Belmont CA US
Leonhard Franz Spiegelberg of San Francisco CA US
Eric Shawn Vandenberg of Saratoga CA US
Andong Zhan of San Mateo CA US
DYNAMIC PIVOT IMPLEMENTATION USING OBJECT AGGREGATION
This abstract first appeared for US patent application 20250094418 titled 'DYNAMIC PIVOT IMPLEMENTATION USING OBJECT AGGREGATION
Original Abstract Submitted
examples provide a method for performing dynamic pivot queries employing panda-compatible semantics inside a cloud data platform workload. a sql engine receives a pivot query specifying a pivot column for dynamically determining pivot values in a dynamic pivot operation. the sql engine identifies, in the pivot query, a keyword or a subquery indicating dynamic determination of the pivot values. based on identifying the keyword or the subquery indicating the dynamic determination of the pivot values, the sql engine determines distinct pivot values for the pivot column by evaluating the keyword or executing the subquery. the evaluating of the keyword includes issuing a query to a data store to obtain the distinct pivot values for the pivot column. the sql engine performs the dynamic pivot operation using the distinct pivot values for the pivot column.
- Snowflake inc.
- Srilakshmi Chintala of Seattle WA US
- Jianzhun Du of Kirkland WA US
- Naresh Kumar of Santa Clara CA US
- Jaeyun Noh of Sunnyvale CA US
- Srinath Shankar of Belmont CA US
- Leonhard Franz Spiegelberg of San Francisco CA US
- Eric Shawn Vandenberg of Saratoga CA US
- Jiaqi Yan of Menlo Park CA US
- Andong Zhan of San Mateo CA US
- Yun Zou of Sunnyvale CA US
- G06F16/2453
- CPC G06F16/24534
