公开(公告)号：US20240289470A1

公开(公告)日：2024-08-29

申请号：US18173609

申请日：2023-02-23

Applicant: Snowflake Inc.

Inventor： Andrew Clauson ,  Martin S. Heyder ,  Shiva Dutt Paladugu ,  Falguni Sonawala ,  Cameron Tekiyeh

IPC: G06F21/60 ,  G06F21/62

CPC classification number: G06F21/604 ,  G06F21/6227 ,  G06F2221/2113 ,  G06F2221/2141

Abstract: Provided herein are systems and methods for configuring user access review (UAR). A system includes at least one hardware processor coupled to a memory and configured to retrieve user data associated with a plurality of users of a database system. The user data includes current access privileges and a role of a plurality of roles assigned to each user of the plurality of users. The policy data is associated with the plurality of users and includes a list of allowed access privileges for each of the plurality of roles. A mismatch between the current access privileges of a user of the plurality of users and the allowed access privileges associated with the role of the user is detected. A remediation action is performed to adjust the current access privileges of the user based on the detected mismatch. A notification is generated to confirm the remediation action is performed.

公开(公告)号：US12072998B2

公开(公告)日：2024-08-27

申请号：US17389100

申请日：2021-07-29

Applicant: Snowflake Inc.

Inventor： Ishaan Nerurkar ,  Christopher Hockenbrocht ,  Liam Damewood ,  Mihai Maruseac ,  Alexander Rozenshteyn

IPC: G06F21/62 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/2458 ,  G06F16/248 ,  G06F16/25 ,  G06N5/01 ,  G06N20/00 ,  G06N20/20 ,  H04L9/40

CPC classification number: G06F21/6227 ,  G06F16/24547 ,  G06F16/2455 ,  G06F16/2462 ,  G06F16/2465 ,  G06F16/248 ,  G06F16/25 ,  G06F21/6218 ,  G06F21/6245 ,  G06F21/6254 ,  G06N5/01 ,  G06N20/00 ,  G06N20/20 ,  H04L63/105

Abstract: A hardware database privacy device is communicatively coupled to a private database system. The hardware database privacy device receives a request from a client device to perform a query of the private database system and identifies a level of differential privacy corresponding to the request. The identified level of differential privacy includes privacy parameters (ε,δ) indicating the degree of information released about the private database system. The hardware database privacy device identifies a set of operations to be performed on the set of data that corresponds to the requested query. After the set of data is accessed, the set of operations is modified based on the identified level of differential privacy such that a performance of the modified set of operations produces a result set that is (ε,δ)-differentially private.

公开(公告)号：US20240281530A1

公开(公告)日：2024-08-22

申请号：US18650636

申请日：2024-04-30

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Pui Kei Johnston Chu ,  Benoit Dageville ,  Iulia Ion ,  Unmesh Jagtap ,  Subramanian Muralidhar ,  James Pan ,  Nihar Pasala ,  Hrushikesh Shrinivas Paralikar ,  Jake Tsuyemura ,  Ryan Charles Quistorff ,  Rishabh Gupta

IPC: G06F21/56 ,  G06F8/60

CPC classification number: G06F21/565 ,  G06F8/60 ,  G06F2221/033

Abstract: An anti-abuse system is provided for a data-platform. An anti-abuse scanner of the data-platform detects a creation of an application package by a provider of content to the data platform where the application package includes a set of files for deployment on the data platform. The anti-abuse scanner performs a review o the set of files to detect malicious content where the review is based on a set of analysis rules and generates a deployment decision for the application package based on a result of the review.

公开(公告)号：US20240281472A1

公开(公告)日：2024-08-22

申请号：US18443903

申请日：2024-02-16

Applicant: Snowflake Inc.

Inventor： Cooper Paul LaRhette ,  Seth Michael Li ,  Muhua Ngan ,  Vivek Raghunathan ,  Sridhar Ramaswamy

IPC: G06F16/9032

CPC classification number: G06F16/90328

Abstract: An interactive search method is disclosed, utilizing a browser-based interface and generative artificial intelligence to enhance user search experiences. The method involves receiving an initial search query from a user, generating a proposed search result via hardware processors, and displaying the result to the user. To refine search accuracy, the method recommends clarifying questions, soliciting additional search parameters. Upon receiving an updated search query, the system interactively refines the initial query and displays an updated search result. This process allows for dynamic query adjustment and improved search result relevance in real-time.

公开(公告)号：US20240281446A1

公开(公告)日：2024-08-22

申请号：US18444078

申请日：2024-02-16

Applicant: Snowflake Inc.

Inventor： Rahil Bathwal ,  Daniel Fernando Campos ,  Ashwin Devaraj ,  Seth Michael Li ,  Yash Pande ,  Vivek Raghunathan ,  Rajhans Samdani ,  Danmei Xu

IPC: G06F16/2457 ,  G06F16/248

CPC classification number: G06F16/24575 ,  G06F16/248

Abstract: An advanced search system leverages a pre-trained large language model to enhance user query responses. The system, equipped with hardware processors, a search query via an interface and accesses a pre-trained large language model designed to respond to the search query. The system fine-tunes the model to generate a task-specific generative model. The system employs the task-specific generative model to generate a search result to the search query and analyzes the search result based on a performance metric associated with the task-specific generative model. The system refines the task-specific generative model based on the analyzing of the search result.

公开(公告)号：US20240272900A1

公开(公告)日：2024-08-15

申请号：US18525359

申请日：2023-11-30

Applicant: Snowflake Inc.

Inventor： Karol Pawel Bienkowski ,  Damien Carru ,  Jeremy Yujui Chen ,  Pui Kei Johnston Chu ,  Benoit Dageville ,  Scott C. Gray ,  Unmesh Jagtap ,  Subramanian Muralidhar

IPC: G06F8/71 ,  G06F9/448

CPC classification number: G06F8/71 ,  G06F9/4488

Abstract: An in-database application package and application instance for a data platform. The data platform creates an application instance of an application package having a versioned schema, creates one or more system roles for the application instance, creates a user role and an administrator role for the application instance, creates one or more objects of the application instance based on a versioned schema, and grants one or more use privileges to the one or more roles. Application instances of the application package are upgraded or patched on the data platform based on application package versions. To ensure a proper upgrade or patch, the data platform tracks versions of executing objects of application instances in a call context.

公开(公告)号：US20240256570A1

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

申请号：US18587151

申请日：2024-02-26

Applicant: Snowflake Inc.

Inventor： Thierry CRUANES ,  Benoit DAGEVILLE ,  Marcin ZUKOWSKI

IPC: G06F16/27 ,  A61F5/56 ,  G06F9/48 ,  G06F9/50 ,  G06F16/14 ,  G06F16/182 ,  G06F16/21 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/2458 ,  G06F16/25 ,  G06F16/28 ,  G06F16/951 ,  G06F16/9535 ,  G06F16/9538 ,  H04L67/1095 ,  H04L67/1097 ,  H04L67/568

CPC classification number: G06F16/273 ,  A61F5/566 ,  G06F9/4881 ,  G06F9/5016 ,  G06F9/5044 ,  G06F9/5083 ,  G06F9/5088 ,  G06F16/148 ,  G06F16/1827 ,  G06F16/211 ,  G06F16/221 ,  G06F16/2365 ,  G06F16/24532 ,  G06F16/24545 ,  G06F16/24552 ,  G06F16/2456 ,  G06F16/2471 ,  G06F16/254 ,  G06F16/27 ,  G06F16/283 ,  G06F16/951 ,  G06F16/9535 ,  G06F16/9538 ,  H04L67/1095 ,  H04L67/1097 ,  H04L67/568

Abstract: Example caching systems and methods are described. In one implementation, a method receives a set of queries to be processed by a set of virtual warehouses. The method distributes the set of queries to the set of virtual warehouses to be executed and creates, during the processing of the set of queries by the set of virtual warehouses, a new virtual warehouse, wherein cache resources associated with the new virtual warehouse are populated with data files associated with the set of queries at the time the virtual warehouse is created and the cache resources vary among the processors, wherein a first subset of the processors comprises minimal cache resources and a second subset of processors comprises cache resources providing faster input-output operations. The method redistributes the set of queries across the set of virtual warehouses.

公开(公告)号：US12050605B2

公开(公告)日：2024-07-30

申请号：US17804248

申请日：2022-05-26

Applicant: Snowflake Inc.

Inventor： Matthias Carl Adams ,  Mahmud Allahverdiyev ,  Ismail Oukid ,  Peter Popov ,  Alejandro Salinger

IPC: G06F16/22 ,  G06F16/2455 ,  G06F16/28 ,  G06F16/9035 ,  G06F17/18

CPC classification number: G06F16/24557 ,  G06F16/2272 ,  G06F16/283 ,  G06F16/9035 ,  G06F17/18

Abstract: Provided herein are systems and methods for indexed geospatial predicate search. An example method performed by at least one hardware processor includes decoding a query with a geospatial predicate. The geospatial predicate is configured between a geography data column and a constant geography object. The method further includes computing a first covering for a data value of a plurality of data values in the geography data column. The first covering includes a first set of cells in a hierarchical grid representation of a geography. The first set of cells represents a surface of the geography associated with the data value. A second covering is computed for the constant geography object. A determination is made on whether to prune at least one partition of a database organized into a set of partitions and including the geography data column based on a comparison between the first covering and the second covering.

公开(公告)号：US12032595B2

公开(公告)日：2024-07-09

申请号：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/00 ,  G06F16/182 ,  G06F16/245 ,  G06F16/27

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

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.

公开(公告)号：US12026153B2

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

申请号：US18179762

申请日：2023-03-07

Applicant: Snowflake Inc.

Inventor： Torsten Grabs ,  Istvan Cseri ,  Benoit Dageville

IPC: G06F16/00 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2455

CPC classification number: G06F16/2379 ,  G06F16/2282 ,  G06F16/24554 ,  G06F16/2456

Abstract: Systems, methods, and devices for tracking a series of changes to database data are disclosed. A method includes executing a transaction to modify data in a micro-partition of a table of a database by generating a new micro-partition that embodies the transaction. The method includes associating transaction data with the new micro-partition, wherein the transaction data comprises a timestamp when the transaction was fully executed, and further includes associating modification data with the new micro-partition that comprises an indication of one or more rows of the table that were modified by the transaction. The method includes joining the transaction data with the modification data to generate joined data and querying the joined data to determine a listing of intermediate modifications made to the table between a first timestamp and a second timestamp.