-
公开(公告)号:US20240378305A1
公开(公告)日:2024-11-14
申请号:US18316787
申请日:2023-05-12
Applicant: Snowflake Inc.
Inventor: Suraj P. Acharya , Jennifer Wenjun Bi , Khalid Zaman Bijon , Damien Carru , Lin Chan , Tianyi Chen , Jeremy Yujui Chen , Thierry Cruanes , Benoit Dageville , Simon Holm Jensen , Boxin Jiang , Dmitry A. Lychagin , Subramanian Muralidhar , Shuaishuai Nie , Eric Robinson , Sahaj Saini , David Schultz , Kevin Wang , Wenqi Wei , Zixi Zhang , Xingzhe Zhou
Abstract: Systems and methods for generating object references with selectable scopes are provided. The systems and methods perform operations including calling, by a first entity, a reference generator function using one or more arguments associated with a database object that the first entity is authorized to access according to a first set of access privileges, the one or more arguments comprising a scope definition that defines persistence of a reference. The operations include obtaining, from the reference generator function, a reference to the database object, the reference persisting according to the scope definition. The operations include passing the reference to a second entity to enable the second entity to perform one or more database operations on the database object according to a second set of access privileges derived from the first set of access privileges.
-
公开(公告)号:US20240370406A1
公开(公告)日:2024-11-07
申请号:US18775830
申请日:2024-07-17
Applicant: Snowflake Inc.
Inventor: Lin Chan , Tianyi Chen , Robert Bengt Benedikt Gernhardt , Nithin Mahesh , Eric Robinson
Abstract: Techniques for executing show commands are described herein. A plurality of navigation steps is utilized, each navigation step corresponding to a different layer in a database structure and each navigation step including an operator to fetch items from a metadata database up to respective bounded limits. Dependency information is also fetched for objects of the specified object type in the show command. After a set of objects from the last layer are processed, memory for the navigation steps is flushed and the next set of objects are processed.
-
公开(公告)号:US12007997B2
公开(公告)日:2024-06-11
申请号:US18183483
申请日:2023-03-14
Applicant: Snowflake Inc.
Inventor: Lin Chan , Tianyi Chen , Benoit Dageville , Yiming Kang , Jun Luo , Nithin Mahesh , Eric Robinson , Brian Smith
CPC classification number: G06F16/24549 , G06F7/14 , G06F16/2228 , G06F16/2379 , G06F21/6218 , G06F21/6227
Abstract: As described herein, a N-Gram index may be created and the search may be conducted using the index, which will lead to faster search results. The N-Gram index may also include partial N-Gram components to capture more relevant data. Moreover, as described herein, the search may also take into account recent log data that has not yet been indexed. Techniques for building an index store using log data and efficiently searching the index store and log data to process search requests are described herein.
-
公开(公告)号:US20230214391A1
公开(公告)日:2023-07-06
申请号:US18183483
申请日:2023-03-14
Applicant: Snowflake Inc.
Inventor: Lin Chan , Tianyi Chen , Benoit Dageville , Yiming Kang , Jun Luo , Nithin Mahesh , Eric Robinson , Brian Smith
CPC classification number: G06F16/2379 , G06F16/2228 , G06F7/14 , G06F21/6218
Abstract: As described herein, a N-Gram index may be created and the search may be conducted using the index, which will lead to faster search results. The N-Gram index may also include partial N-Gram components to capture more relevant data. Moreover, as described herein, the search may also take into account recent log data that has not yet been indexed. Techniques for building an index store using log data and efficiently searching the index store and log data to process search requests are described herein.
-
公开(公告)号:US12072840B2
公开(公告)日:2024-08-27
申请号:US18179793
申请日:2023-03-07
Applicant: Snowflake Inc.
Inventor: Lin Chan , Tianyi Chen , Robert Bengt Benedikt Gernhardt , Nithin Mahesh , Eric Robinson
CPC classification number: G06F16/148 , G06F16/164
Abstract: Techniques for executing show commands are described herein. A plurality of navigation steps is utilized, each navigation step corresponding to a different layer in a database structure and each navigation step including an operator to fetch items from a metadata database up to respective bounded limits. Dependency information is also fetched for objects of the specified object type in the show command. After a set of objects from the last layer are processed, memory for the navigation steps is flushed and the next set of objects are processed.
-
公开(公告)号:US20230205735A1
公开(公告)日:2023-06-29
申请号:US18179793
申请日:2023-03-07
Applicant: Snowflake Inc.
Inventor: Lin Chan , Tianyi Chen , Robert Bengt Benedikt Gernhardt , Nithin Mahesh , Eric Robinson
CPC classification number: G06F16/148 , G06F16/164
Abstract: Techniques for executing show commands are described herein. A plurality of navigation steps is utilized, each navigation step corresponding to a different layer in a database structure and each navigation step including an operator to fetch items from a metadata database up to respective bounded limits. Dependency information is also fetched for objects of the specified object type in the show command. After a set of objects from the last layer are processed, memory for the navigation steps is flushed and the next set of objects are processed.
-
公开(公告)号:US20240289333A1
公开(公告)日:2024-08-29
申请号:US18656126
申请日:2024-05-06
Applicant: Snowflake Inc.
Inventor: Lin Chan , Tianyi Chen , Benoit Dageville , Yiming Kang , Jun Luo , Nithin Mahesh , Eric Robinson , Brian Smith
IPC: G06F16/2453 , G06F7/14 , G06F16/22 , G06F16/23 , G06F21/62
CPC classification number: G06F16/24549 , G06F7/14 , G06F16/2228 , G06F16/2379 , G06F21/6218 , G06F21/6227
Abstract: As described herein, a N-Gram index may be created and the search may be conducted using the index, which will lead to faster search results. The N-Gram index may also include partial N-Gram components to capture more relevant data. Moreover, as described herein, the search may also take into account recent log data that has not yet been indexed. Techniques for building an index store using log data and efficiently searching the index store and log data to process search requests are described herein.
-
公开(公告)号:US20230138110A1
公开(公告)日:2023-05-04
申请号:US17809829
申请日:2022-06-29
Applicant: Snowflake Inc.
Inventor: Lin Chan , Tianyi Chen , Robert Bengt Benedikt Gernhardt , Nithin Mahesh , Eric Robinson
Abstract: Techniques for executing show commands are described herein. A plurality of navigation steps is utilized, each navigation step corresponding to a different layer in a database structure and each navigation step including an operator to fetch items from a metadata database up to respective bounded limits. Dependency information is also fetched for objects of the specified object type in the show command. After a set of objects from the last layer are processed, memory for the navigation steps is flushed and the next set of objects are processed.
-
公开(公告)号:US20250013453A1
公开(公告)日:2025-01-09
申请号:US18348490
申请日:2023-07-07
Applicant: Snowflake Inc.
Inventor: Tianyi Chen , Benoit Dageville , Subramanian Muralidhar , Shuaishuai Nie , Eric Robinson , Sahaj Saini
Abstract: Techniques for creating, sharing, and using bundles (also referred to as packages) in a multi-tenant database are described herein. The bundle includes an interface directly accessible to the consumer account and a hidden bundle schema not directly accessible by the consumer account. A consumer account can upgrade from a first version to a second version by way of an intermediate version.
-
公开(公告)号:US11645232B1
公开(公告)日:2023-05-09
申请号:US17809829
申请日:2022-06-29
Applicant: Snowflake Inc.
Inventor: Lin Chan , Tianyi Chen , Robert Bengt Benedikt Gernhardt , Nithin Mahesh , Eric Robinson
CPC classification number: G06F16/148 , G06F16/164
Abstract: Techniques for executing show commands are described herein. A plurality of navigation steps is utilized, each navigation step corresponding to a different layer in a database structure and each navigation step including an operator to fetch items from a metadata database up to respective bounded limits. Dependency information is also fetched for objects of the specified object type in the show command. After a set of objects from the last layer are processed, memory for the navigation steps is flushed and the next set of objects are processed.
-
-
-
-
-
-
-
-
-