公开(公告)号：US11860896B2

公开(公告)日：2024-01-02

申请号：US17935869

申请日：2022-09-27

Applicant: Snowflake Inc.

Inventor： Robert Bengt Benedikt Gernhardt ,  Chao-Yang Lo ,  Nithin Mahesh ,  Subramanian Muralidhar ,  Sahaj Saini

IPC: G06F16/00 ,  G06F16/27 ,  G06F16/185 ,  G06F16/11 ,  G06F16/13

CPC classification number: G06F16/273 ,  G06F16/11 ,  G06F16/13 ,  G06F16/185

Abstract: A system for data object replication includes at least one hardware processor and at least one memory storing instructions. The instructions cause the at least one hardware processor to perform operations including decoding a replication request to obtain a data object. Object dependencies associated with the data object and a plurality of additional data objects are determined. A replication sequence of the data object and the plurality of additional data objects is determined based on the object dependencies. A replication of the data object and at least one of the plurality of additional data objects is performed according to the replication sequence. A notification of a successful completion of the replication is generated.

公开(公告)号：US20230401333A1

公开(公告)日：2023-12-14

申请号：US18060504

申请日：2022-11-30

Applicant: Snowflake Inc.

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

IPC: G06F21/62 ,  G06F21/53

CPC classification number: G06F21/6245 ,  G06F21/53 ,  G06F2221/032

Abstract: In an embodiment, an application is created on a data-provider platform. The application includes one or more application programming interfaces (APIs) corresponding to one or more underlying code blocks. Provider data is shared with the application on the data-provider platform. An application instance of the application is installed in a trusted execution environment (TEE). The application instance includes one or more APIs corresponding to the one or more APIs in the application on the data-provider platform. Consumer data is shared with the application instance from a data-consumer platform. One or more of the APIs of the application instance are invoked to execute, on the TEE, respective associated underlying code blocks that are not visible on the TEE. The output of the one or more respective associated underlying code blocks is saved to the data-consumer platform.

公开(公告)号：US11841849B2

公开(公告)日：2023-12-12

申请号：US17812878

申请日：2022-07-15

Applicant: Snowflake Inc.

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

IPC: G06F16/20 ,  G06F16/242 ,  G06F3/06 ,  G06F16/23 ,  G06F16/16 ,  G06F16/25 ,  G06F9/54 ,  G06F16/22 ,  G06F16/2455

CPC classification number: G06F16/2423 ,  G06F3/0605 ,  G06F3/067 ,  G06F3/0644 ,  G06F3/0653 ,  G06F9/542 ,  G06F16/164 ,  G06F16/2282 ,  G06F16/2358 ,  G06F16/2393 ,  G06F16/24557 ,  G06F16/256

Abstract: In an embodiment, a database platform receives a query that is directed at least in part to external data in an external table stored on a data storage platform that is external to the database platform. The external table includes a plurality of partitions. The database platform identifies, from external-table metadata, a subset of the plurality of partitions of the external table as including data that potentially satisfies the query. The external-table metadata is stored by the database platform. The database platform identifies data that satisfies the query by scanning the identified subset of the partitions, and responds to the query at least in part with the identified data that satisfies the query.

公开(公告)号：US11816239B2

公开(公告)日：2023-11-14

申请号：US18048560

申请日：2022-10-21

Applicant: Snowflake Inc.

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

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

CPC classification number: G06F21/6227 ,  G06F16/245 ,  G06F16/248 ,  H04L9/3213 ,  H04L63/102 ,  H04L63/105

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.

公开(公告)号：US20230316348A1

公开(公告)日：2023-10-05

申请号：US17710598

申请日：2022-03-31

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Sameer Deshpande ,  Eric Dorf ,  Subramanian Muralidhar ,  Chao Ren ,  Dangfu Wang

IPC: G06Q30/04 ,  G06Q20/14 ,  G06F9/54 ,  G06F16/25

CPC classification number: G06Q30/04 ,  G06Q20/145 ,  G06F9/547 ,  G06F16/256

Abstract: Embodiments of the present disclosure describe techniques for monitoring usage of data listings and pricing data listings based thereon. Metadata comprising a pricing plan may be added to a data listing to generate a monetized data listing. The monetized data listing may be imported to the consumer account. The usage data of the monetized data listing and listing data of the monetized data listing may be exported to a data warehousing and analysis module. A usage level for a set of jobs processed using the monetized data listing during a current incremental interval of a current billing interval may be calculated and combined with a usage level of all previous incremental intervals of the current billing interval to generate a cumulative usage record. An invoice for the billing interval may be generated based on the cumulative usage record.

公开(公告)号：US11775559B1

公开(公告)日：2023-10-03

申请号：US17977817

申请日：2022-10-31

Applicant: Snowflake Inc.

Inventor： Durga Mahesh Arikatla ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Shakhina Pulatova ,  Di Wu ,  Ziqi Xu

IPC: G06F16/27 ,  G06Q30/0201 ,  G06Q30/0601

CPC classification number: G06F16/27 ,  G06Q30/0206 ,  G06Q30/0601

Abstract: A data dictionary generation system automatically populates and updates a data dictionary for listings offering shared data. The data listing distribution component distributes the data dictionaries to various remote deployments in a data exchange by using a global messaging framework and replication method. For example, the data listing distribution component replicates a data dictionary generated for the listing and its shared data from a source deployment to one or more destination deployments associated with various geographic regions. The data listing distribution component distributes the listing to the various remote deployments to allow for the listing, including its shared data and data dictionary, to be accessed by users within the geographic region associated with the remote deployment.

公开(公告)号：US20230297590A1

公开(公告)日：2023-09-21

申请号：US18323155

申请日：2023-05-24

Applicant: Snowflake Inc.

Inventor： Robert Bengt Benedikt Gernhardt ,  Mikhail Kazhamiaka ,  Nithin Mahesh ,  Laxman Mamidi ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Sahaj Saini

IPC: G06F16/27 ,  G06F11/14 ,  G06F16/25 ,  G06F11/20 ,  G06F16/182 ,  G06F16/13 ,  G06F16/178 ,  G06F16/11

CPC classification number: G06F16/27 ,  G06F11/1464 ,  G06F16/256 ,  G06F11/2023 ,  G06F11/1461 ,  G06F16/184 ,  G06F16/1827 ,  G06F16/137 ,  G06F16/1787 ,  G06F16/1844 ,  G06F16/128 ,  G06F11/2097

Abstract: A method includes generating at a source account of a database system user, a replication group object (RGO). The RGO includes a manifest identifying one or more data object types and one or more databases. A replication of data objects of the one or more data object types is performed from the one or more databases to a target account of the database system user. The replication of the data objects is performed as a unit. The RGO is replicated as a failover group object (FGO) within the target account of the database system user. A network failure is detected at the source account of the database system user. The target account of the database system user is promoted as a new source account based on the detecting of the network failure.

公开(公告)号：US11763029B2

公开(公告)日：2023-09-19

申请号：US18162506

申请日：2023-01-31

Applicant: Snowflake Inc.

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

IPC: H04L29/06 ,  G06F21/62 ,  G06F21/53

CPC classification number: G06F21/6245 ,  G06F21/53 ,  G06F2221/032

Abstract: A data platform creates an application in a data-provider account, where the application includes one or more application programming interfaces (APIs) corresponding to one or more underlying code blocks. The data platform shares homomorphically encrypted provider data with the application in the data-provider account. The data platform installs, in a data-consumer account, an application instance of the application. The data platform shares homomorphically encrypted consumer data with the application instance in the data-consumer account. The data platform 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, and which operate on the shared homomorphically encrypted provider data and the shared homomorphically encrypted consumer data. The data platform saves homomorphically encrypted output of the one or more respective associated underlying code blocks locally within the data-consumer account.

公开(公告)号：US11755311B1

公开(公告)日：2023-09-12

申请号：US18169823

申请日：2023-02-15

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Benoit Dageville ,  Unmesh Jagtap ,  Subramanian Muralidhar ,  Jan Michael Timmerman

IPC: G06F8/65 ,  G06F16/21

CPC classification number: G06F8/65 ,  G06F16/219

Abstract: A versioned schema of a data platform. A process of maintaining a call stack of executing objects of an application package having a versioned schema includes calling, by a first procedure executed by one or more processors, a second procedure of a versioned application instance, and determining, by the first procedure, a version of the second procedure based on a call context. In response to determining that the version of the second procedure is not in the call context, the first procedure determines a current version of the versioned application package adds the current version to the call context as the version of the second procedure.

公开(公告)号：US20230237069A1

公开(公告)日：2023-07-27

申请号：US18128130

申请日：2023-03-29

Applicant: Snowflake Inc.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Sameer Deshpande ,  Subramanian Muralidhar ,  Di Wu

IPC: G06F16/27 ,  G06F16/182 ,  G06F16/245

CPC classification number: G06F16/273 ,  G06F16/245 ,  G06F16/1844

Abstract: Techniques for database replication for a remote deployment include a method performed by a data platform executing instructions on at least one hardware processor. The method includes detecting receipt of a database replication request associated with a data consumer. The database replication request is requesting availability of an instance of a primary deployment database at a remote deployment of a data platform. In response to detecting the receipt of the database replication request, an account of a data provider at the remote deployment of the data platform is provisioned with a set of replication-preparation objects associated with the primary deployment database. A database refresh operation is invoked, causing database data be pushed from the primary deployment database to a database shell in the account of the data provider at the remote deployment, to create the instance of the primary deployment database.