公开(公告)号：US20200334231A1

公开(公告)日：2020-10-22

申请号：US16775110

申请日：2020-01-28

Applicant: Snowflake Inc.

Inventor： Subramanian Muralidhar ,  Benoit Dageville ,  Thierry Cruanes ,  Nileema Shingte ,  Saurin Shah ,  Torsten Grabs ,  Istvan Cseri

IPC: G06F16/23 ,  G06F16/248 ,  G06F16/2458 ,  G06F16/25 ,  G06F3/06

Abstract: Systems, methods, and devices for generating a materialized view over an external table. A method includes connecting a database platform to an external table such that the database platform has read access for the external table and does not have write access for the external table. The method includes generating, by the database platform, a materialized view over the external table. The method includes receiving a notification that a modification has been made to the external table, the modification comprising one or more of an addition of a file, a deletion of a file, or an update to a file in a source location for the external table. The method includes, in response to the external table being modified, refreshing the materialized view such that the materialized view comprises an accurate representation of the external table.

公开(公告)号：US20200334230A1

公开(公告)日：2020-10-22

申请号：US16385720

申请日：2019-04-16

Applicant: Snowflake Inc.

Inventor： Subramanian Muralidhar ,  Benoit Dageville ,  Thierry Cruanes ,  Nileema Shingte ,  Saurin Shah ,  Torsten Grabs ,  Istvan Cseri

IPC: G06F16/23 ,  G06F16/25 ,  G06F16/248 ,  G06F16/2458 ,  G06F3/06

Abstract: Systems, methods, and devices for generating a materialized view over an external table. A method includes connecting a database platform to an external table such that the database platform has read access for the external table and does not have write access for the external table. The method includes generating, by the database platform, a materialized view over the external table. The method includes receiving a notification that a modification has been made to the external table, the modification comprising one or more of an addition of a file, a deletion of a file, or an update to a file in a source location for the external table. The method includes, in response to the external table being modified, refreshing the materialized view such that the materialized view comprises an accurate representation of the external table.

公开(公告)号：US20250103610A1

公开(公告)日：2025-03-27

申请号：US18472849

申请日：2023-09-22

Applicant: Snowflake Inc.

Inventor： Abdullah Al Mahmood ,  Ganeshan Ramachandran lyer ,  Subramanian Muralidhar

IPC: G06F16/25 ,  G06F16/215 ,  G06F16/2453

Abstract: Techniques for ingestion of unstructured files into a target table stored in a network-based database system are described. The unstructured files may include formats not natively supported by a database system. An external service may be used to process the unstructured files. The database system may employ external calls to request the external service to process the unstructured files and provide the results in a specified response schema including metadata.

公开(公告)号：US12235985B2

公开(公告)日：2025-02-25

申请号：US18359360

申请日：2023-07-26

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Thierry Cruanes ,  Subramanian Muralidhar ,  Nicola Dan Onose ,  Ryan Michael Thomas Shelly ,  Brian Smith ,  Jaeyun Noh

IPC: G06F21/00 ,  G06F16/245 ,  G06F16/248 ,  G06F21/62 ,  H04L9/32 ,  H04L9/40

Abstract: Techniques described herein can allow users to share cached results of an original query with other users while protecting sensitive information. The techniques described herein can check whether the other users have access to the underlying data queried before allowing those users to see the stored query results. That is, the system may perform privilege checks on the shared users before giving them access to the stored query results but without having to re-run the original query.

公开(公告)号：US20250061473A1

公开(公告)日：2025-02-20

申请号：US18452189

申请日：2023-08-18

Applicant: SNOWFLAKE INC.

Inventor： Dhiraj Gupta ,  Laszlo Kovacs ,  Subramanian Muralidhar ,  Souptik Sen ,  Dangfu Wang

IPC: G06Q30/0201

Abstract: A deployment infrastructure for sharing usage metrics with customers is described. An example method includes transforming a usage view file into an anonymous block build file. The usage view file corresponds to a view of customer usage data. The method includes embedding the anonymous block build file into a task, and executing the task to produce a share object that is based on the anonymous block build file. The method includes deploying the share object to a customer account, which enables the customer account to access the view of the customer usage data.

公开(公告)号：US12222828B2

公开(公告)日：2025-02-11

申请号：US18329348

申请日：2023-06-05

Applicant: Snowflake Inc.

Inventor： Loc Duc Bui ,  Hitesh Madan ,  Nithin Mahesh ,  Subramanian Muralidhar ,  Sahaj Saini ,  Di Wu

IPC: G06F16/25 ,  G06F11/20 ,  G06F16/27

Abstract: The subject technology determines a set of share objects in a replication group. The subject technology, for each object from the set of share objects, determines a set of permissions for a set of objects of databases that has been granted to each share object from the replication group. The subject technology, for each permission from the set of permissions, determines a set of dependencies, the set of dependencies comprising a second set of objects. The subject technology generates a graph structure based at least in part on the set of share objects, the set of permissions, and the set of dependencies. The subject technology traverses at least a portion of the graph structure to determine a final set of dependencies for replication. The subject technology performs a replication process based at least in part on the final set of dependencies.

公开(公告)号：US20250045131A1

公开(公告)日：2025-02-06

申请号：US18922111

申请日：2024-10-21

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Pui Kei Johnston Chu ,  Unmesh Jagtap ,  Xiaodi Ke ,  Haroldo Level ,  Subramanian Muralidhar ,  James Pan ,  Steven Parkes ,  Xie Xu ,  Tyson J. Hamilton

IPC: G06F9/54 ,  G06F16/25

Abstract: Disclosed is a system and method of using an event loader to share application information. The method includes generating a first log information object indicating a consumer target where execution information generated by an application shared with a consumer account of a data exchange is written. The method includes generating a first event unloader based on the first log information object. The first event unloader is linked to the application using a mapping. The method includes sending, by a processing device, the execution information generated by the application to the consumer target using the first event unloader.

公开(公告)号：US12210650B2

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

申请号：US18462044

申请日：2023-09-06

Applicant: Snowflake Inc.

Inventor： Artin Avanes ,  Thierry Cruanes ,  Monica J. Holboke ,  Allison Waingold Lee ,  Subramanian Muralidhar ,  David Schultz

IPC: G06F21/62 ,  G06F9/54 ,  G06F16/2455 ,  G06F21/53

Abstract: In an embodiment, a data platform creates an application in a data-provider account. The application includes one or more APIs corresponding to one or more underlying code blocks. The data platform shares provider data with the application in the data-provider account, and also installs, in a data-consumer account, an application instance of the application. The application instance includes one or more APIs corresponding to the one or more APIs in the application in the data-provider account. The data platform shares consumer data with the application instance in the data-consumer account, and invokes one or more of the APIs of the application instance to execute respective associated underlying code blocks, which are not visible to the data-consumer account. The data platform also saves output of the one or more respective associated underlying code blocks locally within the data-consumer account.

公开(公告)号：US12182099B2

公开(公告)日：2024-12-31

申请号：US18426772

申请日：2024-01-30

Applicant: Snowflake Inc.

Inventor： Abdullah Al Mahmood ,  Tyler Jones ,  Xin Huang ,  Ganeshan Ramachandran Iyer ,  Jiaxing Liang ,  Daniel Mills ,  Subramanian Muralidhar ,  Daniel E. Sotolongo

IPC: G06F16/23 ,  G06F11/14 ,  G06F16/22

Abstract: Techniques for creating and using error tables to track errors associated with a base table are described. A command to perform an operation on a base table stored in a network-based data system can be received and executed, causing at least one error. At least one error record corresponding to the at least one error can be inputted into an error table, which is nested with the base table. Contextual information can be added to the at least one error record.

公开(公告)号：US20240427755A1

公开(公告)日：2024-12-26

申请号：US18517744

申请日：2023-11-22

Applicant: Snowflake Inc.

Inventor： Selcuk Aya ,  Thierry Cruanes ,  Istvan Cseri ,  Benoit Dageville ,  Marcia Feitel ,  Steven P. Herbert ,  Dennis Huo ,  Xinglian Liu ,  Nithin Mahesh ,  James Malone ,  Subramanian Muralidhar ,  Muthunagappan Muthuraman ,  Ronald Lee Ortloff ,  Polita Paulus ,  Marianne Shaw ,  Nileema Shingte ,  Wai Sing Wong ,  Jiaqi Yan

IPC: G06F16/22 ,  G06F16/215 ,  G06F16/2457

Abstract: The subject technology provides embodiments for supporting a unified table which may be a managed table or an unmanaged table. Managed tables are those where the subject technology manages the metastore/catalog for the table, whereas unmanaged tables are tables where an external catalog controls the table and the subject technology integrates with that catalog to work with the table, but does not assume control of the table.