Invention Grant
- Patent Title: Stream object type for query processing
-
Application No.: US17650604Application Date: 2022-02-10
-
Publication No.: US11514023B1Publication Date: 2022-11-29
- Inventor: Istvan Cseri , Tyler Jones , Daniel Mills , Daniel E. Sotolongo
- Applicant: Snowflake Inc.
- Applicant Address: US MT Bozeman
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US MT Bozeman
- Agency: Schwegman Lundberg & Woessner, P.A.
- Main IPC: G06F16/23
- IPC: G06F16/23 ; G06F16/22 ; G06F16/2455 ; G06F16/27

Abstract:
Provided herein are systems and methods for a stream object configuration, including configuring and processing streams on views. For example, a method includes configuring by at least one hardware processor at a first computing node, a view on a source table for shared access with at least a second computing node. The view includes a query associated with the source table. The query associated with the source table is executed to obtain a plurality of query results. A stream object is generated on the view. The stream object includes the plurality of query results of executing the query and a corresponding plurality of time stamps associated with times the plurality of query results are obtained. The generated stream object is configured for the shared access with at least the second computing node.
Information query