Patents Assigned to SNOWFLAKE INC.
-
Patent number: 11973763Abstract: Embodiments of the present disclosure provide a region-specific events account that is used as a central place to store the events shared by consumers of shared applications in that region. Use of such an account helps reduce the operational burden of a provider of the applications as they do not need to determine which accounts have shared events for each different consumer. The provider only needs to login to the events account which is in the same region as the consumer and can query all shared events from different applications that are being used in that region. Also, since the provider can designate an events account in each region, the shared events could be directly ingested into the events account without traveling to a different region.Type: GrantFiled: March 28, 2023Date of Patent: April 30, 2024Assignee: SNOWFLAKE INC.Inventors: Damien Carru, Pui Kei Johnston Chu, Unmesh Jagtap, Xiaodi Ke, Subramanian Muralidhar, James Pan
-
Patent number: 11966417Abstract: Example caching systems and methods are described. In one implementation, a method identifies multiple files used to process a query and distributes each of the multiple files to a particular execution node to execute the query. Each execution node determines whether the distributed file is stored in the execution node's cache. If the execution node determines that the file is stored in the cache, it processes the query using the cached file. If the file is not stored in the cache, the execution node retrieves the file from a remote storage device, stores the file in the execution node's cache, and processes the query using the file.Type: GrantFiled: May 26, 2023Date of Patent: April 23, 2024Assignee: SNOWFLAKE INC.Inventors: Thierry Cruanes, Benoit Dageville, Marcin Zukowski
-
Patent number: 11968258Abstract: Provided herein are systems and methods to provide a way to share metrics regarding shared data access and accesses associated with data providers for different data listings of the data exchange. For example, the method may comprise detecting one or more client interactions with a set of data listings of a data exchange, the set of data listings associated with one or data providers. The method may further comprise collecting metrics corresponding to the one or more client interactions. In addition, the method may share metrics relevant to the one or more data providers with the one or more data providers.Type: GrantFiled: October 27, 2023Date of Patent: April 23, 2024Assignee: SNOWFLAKE INC.Inventors: Edmond T. Chan, Pui Kei Johnston Chu, Chao Ren, Stephanie Stillman, Dangfu Wang
-
Patent number: 11954224Abstract: Embodiments of the present disclosure describe systems, methods, and computer program products for redacting sensitive data within a database. An example method can include receiving a masking policy for a column of a database, the masking policy identifying a category of sensitive data, examining a column of a database to identify a category of sensitive data in a first location of the column, and, in response to a data query accessing the column, the first location of the column exceeding a threshold probability of comprising sensitive data, executing a redaction operation to redact the category of sensitive data from the first location of the column to generate redacted data for a response to the data query.Type: GrantFiled: August 29, 2023Date of Patent: April 9, 2024Assignee: SNOWFLAKE INC.Inventors: Yimeng Li, Carl Yates Perry, Raghavendran Ramakrishnan, Frantisek Rolinek, Yunqiao Zhang
-
Patent number: 11418577Abstract: Sharing data in a data exchange across multiple cloud computing platforms and/or cloud computing platform regions is described. An example computer-implemented method can include receiving data sharing information from a data provider for sharing a data set in a data exchange from a first cloud computing entity to a set of second cloud computing entities. In response to receiving the data sharing information, the method may also include creating an account with each of the set of second cloud computing entities. The method may also further include sharing the data set from the first cloud computing entity with the set of second cloud computing entities using at least the corresponding account of that second cloud computing entity.Type: GrantFiled: March 31, 2022Date of Patent: August 16, 2022Assignee: SNOWFLAKE INC.Inventors: Pui Kei Johnston Chu, Benoit Dageville, Matthew Glickman, Christian Kleinerman, Prasanna Krishnan, Justin Langseth
-
Patent number: 11379605Abstract: Systems, methods, and devices for secure view-based data sharing are disclosed. A method in accordance with embodiments disclosed herein comprises associating, by one or more processors, view privileges of a secure view with one or more of a plurality of underlying details of a share object of a first account such that each of the one or more underlying details of the share object comprises a definition of the secure view. The method further comprises: in response to receiving a request from a second account to access any underlying details of the share object, using a secure projection that does not match any rewrite rule preconditions to rewrite a query plan of the request to prevent expressions that do not originate from the secure view from being pushed down below a boundary of the secure view.Type: GrantFiled: May 27, 2021Date of Patent: July 5, 2022Assignee: SNOWFLAKE INC.Inventors: Allison Waingold Lee, Peter Povinec, Martin Hentschel, Robert Muglia
-
Patent number: 11341162Abstract: A method, apparatus, and system for join operations of a plurality of relations that are distributed over a plurality of storage locations over a network of computing components.Type: GrantFiled: August 30, 2021Date of Patent: May 24, 2022Assignee: SNOWFLAKE INC.Inventors: Benoit Dageville, Thierry Cruanes, Marcin Zukowski, Allison Waingold Lee, Philipp Thomas Unterbrunner
-
Patent number: 11321352Abstract: A method and apparatus managing a set of processors for a set of queries is described. In an exemplary embodiment, a device receives a set of queries for a data warehouse, the set of queries including one or more queries to be processed by the data warehouse. The device further provisions a set of processors from a first plurality of processors, where the set of processors to process the set of queries, and a set of storage resources to store data for the set of queries. In addition, the device monitors a utilization of the set of processors as the set of processors processes the set of queries. The device additionally updates a number of the processors in the set of processors provisioned based on the utilization/Furthermore, the device processes the set of queries using the updated set of processors.Type: GrantFiled: June 28, 2021Date of Patent: May 3, 2022Assignee: SNOWFLAKE INC.Inventors: Thierry Cruanes, Benoit Dageville, Marcin Zukowski
-
Patent number: 11294868Abstract: Provided herein are systems and methods for an efficient method of replicating share objects to remote deployments. For example, the method may comprise modifying a share object of a first account of a data exchange into a global object wherein the share object includes grant metadata indicating share grants to a set of objects of a database. The method may further comprise creating, in a second account of the data exchange, a local replica of the share object on the remote deployment based on the global object, wherein the second account is located in a remote deployment. The set of objects of the database may be replicated to a local database replica on the remote deployment and the share grants may be replicated to the local replica of the share object.Type: GrantFiled: August 27, 2021Date of Patent: April 5, 2022Assignee: SNOWFLAKE INC.Inventors: Pui Kei Johnston Chu, Benoit Dageville, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Vishnu Dutt Paladugu, Bowen Zhang
-
Patent number: 11295030Abstract: A method for sharing data in a multi-tenant database includes generating a share object in a first account comprising a share role. The method includes associating one or more access rights with the share role, wherein the one or more access rights indicate which objects in the first account are accessible based on the share object. The method includes granting, to a second account, cross-account access rights to the share role or share object in the first account. The method includes receiving a request from the second account to access data or services of the first account. The method further includes providing a response to the second account based on the data or services of the first account.Type: GrantFiled: October 1, 2020Date of Patent: April 5, 2022Assignee: SNOWFLAKE INC.Inventors: Benoit Dageville, Thierry Cruanes, Martin Hentschel, Peter Povinec
-
Patent number: 11294933Abstract: A method, apparatus, and system for join operations of a plurality of relations that are distributed over a plurality of storage locations over a network of computing components.Type: GrantFiled: June 25, 2021Date of Patent: April 5, 2022Assignee: SNOWFLAKE INC.Inventors: Benoit Dageville, Thierry Cruanes, Marcin Zukowski, Allison Waingold Lee, Philipp Thomas Unterbrunner
-
Patent number: 11290496Abstract: The disclosure relates generally to methods, systems, and apparatuses for managing network connections. A method may include identifying a first state of a first end-point connection of a first networked machine and a second state of a second endpoint connection of a second network machine, and confirming the first state and the second state based on expected states for the first networked machine and the second network machine, wherein the expected states includes a list of expected connections.Type: GrantFiled: July 24, 2020Date of Patent: March 29, 2022Assignee: SNOWFLAKE INC.Inventors: James Calvin Armstrong, Jonathan Claybaugh
-
Patent number: 11288393Abstract: A method of sharing data in a multi-tenant database includes generating a share object in a first account comprising a share role. The method includes associating one or more access rights with the share role, wherein the one or more access rights indicate which objects in the first account are accessible based on the share object. The method includes granting, to a second account, cross-account access rights to the share role or share object in the first account. The method includes receiving a request from the second account to access data or services of the first account. The method further includes providing a response to the second account based on the data or services of the first account.Type: GrantFiled: June 22, 2021Date of Patent: March 29, 2022Assignee: SNOWFLAKE INC.Inventors: Benoit Dageville, Thierry Cruanes, Martin Hentschel, Peter Povinec
-
Patent number: 11269921Abstract: A method and apparatus managing a set of processors for a set of queries is described. In an exemplary embodiment, a device receives a set of queries for a data warehouse, the set of queries including one or more queries to be processed by the data warehouse. The device further provisions a set of processors from a first plurality of processors, where the set of processors to process the set of queries, and a set of storage resources to store data for the set of queries. In addition, the device monitors a utilization of the set of processors as the set of processors processes the set of queries. The device additionally updates a number of the processors in the set of processors provisioned based on the utilization/Furthermore, the device processes the set of queries using the updated set of processors.Type: GrantFiled: July 16, 2021Date of Patent: March 8, 2022Assignee: SNOWFLAKE INC.Inventors: Thierry Cruanes, Benoit Dageville, Marcin Zukowski
-
Patent number: 11269920Abstract: A method and apparatus managing a set of processors for a set of queries is described. In an exemplary embodiment, a device provision a set of computing resources of a database system, the set of computing resources to process a set of queries of the database system and determines a utilization of the set of computing resources during processing of the set of queries. The device further updates the set of computing resources based on the utilization of the set of computing resources by the set of queries. Updating the set of computing resources includes updating a number of processors and a set of storage resources to process the set of queries of the database system, the set of storage resources being shared by each of the processors and processes the set of queries using the set of computing resources as updated.Type: GrantFiled: April 29, 2021Date of Patent: March 8, 2022Assignee: SNOWFLAKE INC.Inventors: Thierry Cruanes, Benoit Dageville, Marcin Zukowski
-
Patent number: 11132380Abstract: Example resource management systems and methods are described. In one implementation, a resource manager is configured to manage data processing tasks associated with multiple data elements. An execution platform is coupled to the resource manager and includes multiple execution nodes configured to store data retrieved from multiple remote storage devices. Each execution node includes a cache and a processor, where the cache and processor are independent of the remote storage devices. A metadata manager is configured to access metadata associated with at least a portion of the multiple data elements.Type: GrantFiled: December 4, 2020Date of Patent: September 28, 2021Assignee: SNOWFLAKE INC.Inventors: Benoit Dageville, Thierry Cruanes, Marcin Zukowski
-
Patent number: 11048721Abstract: A method, apparatus, and system for join operations of a plurality of relations that are distributed over a plurality of storage locations over a network of computing components.Type: GrantFiled: October 26, 2020Date of Patent: June 29, 2021Assignee: SNOWFLAKE INC.Inventors: Benoit Dageville, Thierry Cruanes, Marcin Zukowski, Allison Waingold Lee, Philipp Thomas Unterbrunner
-
Patent number: 11048817Abstract: Systems, methods, and devices for generating a secure join of database data are disclosed. A method includes determining data stored in a first account to be compared with data stored in a second account. The method includes determining a function for generating a secure join key, wherein the secure join key includes a hashed string that hashes one or more of a data entry of the first account and a data entry of the second account. The method includes providing the secure join key to the first account and/or the second account.Type: GrantFiled: August 27, 2020Date of Patent: June 29, 2021Assignee: SNOWFLAKE INC.Inventors: Justin Langseth, Matthew J. Glickman, Christian Kleinerman, Robert Muglia, Daniel Freundel, Thierry Cruanes, Allison Waingold Lee
-
Patent number: 10997201Abstract: A method, apparatus, and system for join operations of a plurality of relations that are distributed over a plurality of storage locations over a network of computing components.Type: GrantFiled: July 19, 2018Date of Patent: May 4, 2021Assignee: SNOWFLAKE INC.Inventors: Benoit Dageville, Thierry Cruanes, Marcin Zukowski, Allison Waingold Lee, Philipp Thomas Unterbrunner
-
Patent number: 10437780Abstract: A system, apparatus, and method for processing queries wherein the query includes a request to access or delete data and accessing metadata associated with the set of data, the metadata defining data characteristics of the set of data and identifying at least sets of data that need or not need to be accessed or deleted based on the metadata without accessing the actual data in the set of data; also methods to optimize processing of some operations based on the collected metadata on data.Type: GrantFiled: July 14, 2016Date of Patent: October 8, 2019Assignee: SNOWFLAKE INC.Inventors: Marcin Zukowski, Benoit Dageville, Thierry Cruanes, Ashish Motivala