-
公开(公告)号：US12222954B2
公开(公告)日：2025-02-11
申请号：US18513140
申请日：2023-11-17
Applicant: Snowflake Inc.
Inventor： Kavinder S. Dhaliwal , Bicheng Gao , Valeri Kim , Nithin Mahesh , Jiaqi Yan , Jiaqi Zhang
IPC: G06F16/25 , G06F16/22 , G06F16/245
Abstract: The subject technology provides techniques for enabling hidden database objects, which in an example are utilized for testing and verifying new database objects against existing workloads. Hidden database objects are a mechanism for bridging that gap by running user workloads on user data in advance of exposing the feature to users. This mechanism allows placing a database object as a hidden object nested beneath a user's visible object (e.g., table, column, view, and the like). Hidden database objects can be used to verify the functionality, parity, performance, and correctness of new unreleased features.
-
公开(公告)号：US20250045634A1
公开(公告)日：2025-02-06
申请号：US18759210
申请日：2024-06-28
Applicant: Snowflake Inc.
Inventor： Luke Samuel Merrick , Abishek Sridhar
Abstract: Various embodiments described herein provide for systems, methods, devices, instructions, and like for facilitating generation of a row embedding for a row of data table (e.g., of a database system). In particular, various embodiments provide for training and subsequent use of a transformer for generating row embeddings for one or more rows of a data table, where each of the one or more rows share the same plurality of fields (or cells).
-
公开(公告)号：US12216662B2
公开(公告)日：2025-02-04
申请号：US18447231
申请日：2023-08-09
Applicant: Snowflake Inc.
Inventor： Artin Avanes , Khalid Zaman Bijon , Yujie Li , Zheng Mi , Subramanian Muralidhar , David Schultz
Abstract: A method of implementing object tagging framework starts with the processor receiving a tag creation command including a tag name. In response to the tag creation command, the processor creates a current tag. The processor then receives an association command, the tag name and a target object identifier. The processor determines a target object associated with the target object identifier. The target object includes a tag value. The processor associates the current tag with the target object. The processor identifies a first child object of the target object. The target object and the first child object are hierarchical objects. In response to determining that the first child object is tag-unassociated, the processor associates the current tag with the first child object. In response to receiving a query including the tag name, the processor generates an output based on the tag name. Other embodiments are also described herein.
-
公开(公告)号：US12216628B2
公开(公告)日：2025-02-04
申请号：US18470706
申请日：2023-09-20
Applicant: SNOWFLAKE INC.
Inventor： Allison Lee , Shrainik Jain , Qiuye Jin , Stratis Viglas , Jiaqi Yan
IPC: G06F16/00 , G06F11/07 , G06F11/30 , G06F11/34 , G06F16/21 , G06F16/215 , G06F16/2453
Abstract: A system to identify optimal cloud resources for executing workloads. The system deduplicates historical client queries based on a workload selection configuration to determine a grouping of historical client queries. The system generates a workload based on at least a portion of the grouping of historical client queries. The system repeatedly executes a test run of the workload using resources of a cloud environment to determine whether there is a performance difference in the test run. The system, in response to determining that there is no performance difference, identifies one or more sets of decreased resources of the cloud environment. The system re-executes the test run using the one or more sets of decreased resources of the cloud environment to determine whether there is a performance difference in the test run that is attributed to the one or more sets of decreased resources of the cloud environment.
-
公开(公告)号：US12204547B2
公开(公告)日：2025-01-21
申请号：US18471001
申请日：2023-09-20
Applicant: Snowflake Inc.
Inventor： Elliott Brossard , Srilakshmi Chintala , Istvan Cseri , Rodger N. Kline , Nitya Kumar Sharma , Igor Zinkovsky
IPC: G06F16/30 , G06F16/2455 , G06F16/25 , G06F16/27
Abstract: An external function system can be implemented on a database to perform processing on one or more external network services. The external function system can comprise a particular external function for a particular external service, an outbound serializer function, and an inbound serializer function that are linked with the particular external function. The outbound serializer function can be configured to transform the data of a query from a database format to a different format of the particular external network service. The inbound deserializer function can be configured to receive data returned from the external service and transform the data to the format of the database.
-
Patent Agency Ranking
公开(公告)号：US20250021556A1
公开(公告)日：2025-01-16
申请号：US18901289
申请日：2024-09-30
Applicant: Snowflake Inc.
Inventor： Xuelai Cui , Prashant Gaharwar , Vineet Garg , Boyung Lee , Kevin Ye Jie Li , Nicola Dan Onose , Andrew Z. Xue , Jiaqi Yan
IPC: G06F16/2453 , G06F11/34 , G06F16/2452
Abstract: The subject technology receives a query, the query including a statement for performing the query. The subject technology performs a first lookup operation on a multi-phase cache based on the query. The subject technology performs, in response to a first cache miss of the multi-phase cache, parsing of the statement from the query. The subject technology performs, based on the parsing, a compilation process on the query to generate a compiled query plan, the compilation process determining an optimization and a generalization for the query. The subject technology determines that the compiled query plan is cacheable. The subject technology registers, in response to the compiled query plan being cacheable, a dummy entry in the multi-phase cache.
-
公开(公告)号：US12189822B2
公开(公告)日：2025-01-07
申请号：US18475610
申请日：2023-09-27
Applicant: Snowflake Inc.
Inventor： Rachel Frances Blum , Joshua James Chacona , Christian Kleinerman , Justin Langseth , William L. Stratton, Jr.
IPC: G06F21/62 , G06F16/22 , G06F16/2455
Abstract: Embodiments of the present disclosure may provide a data clean room allowing secure data analysis across multiple accounts, without the use of third parties. Each account may be associated with a different company or party. The data clean room may provide security functions to safeguard sensitive information. For example, the data clean room may restrict access to data in other accounts. The data clean room may also restrict which data may be used in the analysis and may restrict the output. The overlap data may be anonymized to prevent sensitive information from being revealed.
-
公开(公告)号：US12189616B2
公开(公告)日：2025-01-07
申请号：US18353317
申请日：2023-07-17
Applicant: Snowflake Inc.
Inventor： Tyler Arthur Akidau , Tyler Jones , Daniel Mills , Leon Papke , Prasanna Rajaperumal , Daniel E. Sotolongo
Abstract: A method includes retrieving a plurality of materialized tables (MTs). Each of the plurality of MTs includes a lag duration and refers to a corresponding base table of a plurality of base tables. The lag duration indicates a maximum time period that a result of a prior refresh of a query on the corresponding base table can lag behind a current time instance. A plurality of time instances for the MT is determined based on the lag duration and a number of prior refreshes of the corresponding base table. A plurality of aligned time instances for the plurality of MTs is determined based on the plurality of time instances for each of the plurality of MTs. Refresh operations are scheduled for the plurality of MTs at one or more of the plurality of aligned time instances that are within the maximum time period.
-
公开(公告)号：US20240427924A1
公开(公告)日：2024-12-26
申请号：US18823014
申请日：2024-09-03
Applicant: Snowflake Inc.
Inventor： Raja Suresh Krishna Balakrishnan , Khalid Zaman Bijon , Subramanian Muralidhar , David Schultz , Jian Xu
IPC: G06F21/62
Abstract: Systems and methods for managing column hiding are provided. The systems and methods receive, from a client device, a query associated with a table. The systems and methods determine an access restriction associated with the client device. The systems and methods identify a column of the table that is restricted by the access restriction associated with the client device. In response to identifying the column of the table that is restricted by the access restriction associated with the client device, the systems and methods provide a result of the query that excludes data corresponding to the column.
-
公开(公告)号：US20240427801A1
公开(公告)日：2024-12-26
申请号：US18827377
申请日：2024-09-06
Applicant: Snowflake Inc.
Inventor： Benoit Dageville , Eric Robinson , Martin Hentschel
IPC: G06F16/27 , G06F16/245 , H04L67/1097
Abstract: Replication and failover of data is disclosed. A method includes replicating the data stored in a primary deployment such that the data is further stored in a secondary deployment. The method includes executing one or more transactions on the data at the primary deployment to cause a change to the data to be stored in the primary deployment. The method includes propagating the one or more transactions on the data to the secondary deployment to perform a failover to the secondary deployment while the change to the data is absent from the secondary deployment.
-
-
-
-
-
-
-
-
-
Search Results
1749
records
(took 0.024 seconds)
