-
公开(公告)号:US20240394244A1
公开(公告)日:2024-11-28
申请号:US18790664
申请日:2024-07-31
Applicant: Snowflake Inc.
Inventor: Cristian Diaconu , Nikolaos Romanos Katsipoulakis , Alexander Miller , Dimitrios Tsirogiannis , William Waddington , Zhaohui Zhang
Abstract: The subject technology initiates an online index building process of an index of a hybrid table. The subject technology includes, in the index, a new index record for each record from the hybrid table. The subject technology validates the index. The subject technology retrieves a first metadata version of the hybrid table from a metadata database. The subject technology retrieves a second metadata version of the hybrid table from a distributed data store. The subject technology compares the first metadata version with the second metadata version. The subject technology determines that the second metadata version is less than or equal to the first metadata version. The subject technology, in response to successfully validating the index, indicates in a particular entry of the index that validation of the index has succeeded.
-
公开(公告)号:US12153971B2
公开(公告)日:2024-11-26
申请号:US18243609
申请日:2023-09-07
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
Abstract: Disclosed is an execution information sharing system that duplicates execution information to a provider target (and other targets) as it is being loaded to a consumer target. A first log information object and a second log information object are generated. The first and second log information objects comprise information indicating a consumer target and information indicating a provider target respectively where execution information generated by an application shared with a consumer account of a data exchange is written. A first event unloader and a second event unloader are generated based on the first and second log information objects respectively, wherein the first and second event unloaders are both linked to the application using a mapping. In response to receiving execution information from the application, the execution information is forwarded to the consumer target and the provider target using the first event unloader and the second event unloader respectively.
-
公开(公告)号:US12153602B2
公开(公告)日:2024-11-26
申请号:US17815389
申请日:2022-07-27
Applicant: Snowflake Inc.
Inventor: Sebastian Breß , Moritz Eyssen , Max Heimel
IPC: G06F16/00 , G06F16/2455 , G06F16/27
Abstract: A global and local row count limit associated with a limit query are received by a stop operator of a first execution node among a set of execution nodes that are assigned to process the limit query. Local distributed row count data is generated based on a local row count corresponding to a number of rows output by the first execution node in processing the query. Based on determining the local row count satisfies the local limit, the first execution node buffers rows produced in processing the query. The local distributed row count data is updated based on remote distributed row count data received from a second execution node. A stopping condition is detected based on determining the global limit is satisfied based on updated local distributed row count data and query processing by the first execution node based on detecting the stopping condition.
-
公开(公告)号:US20240388584A1
公开(公告)日:2024-11-21
申请号:US18317370
申请日:2023-05-15
Applicant: Snowflake Inc.
Inventor: Damien Carru , Benoit Dageville , Scott C. Gray , Unmesh Jagtap , Subramanian Muralidhar , James Pan
Abstract: An application package and application instance for a data platform. The application is created in a consumer account of a consumer using the application package. The consumer grants permissions for performing privileged actions in the consumer account to an application role of the application. The application creates objects in the application, creates objects outside of the application in the consumer account, and accesses external systems using permissions granted by the consumer.
-
公开(公告)号:US20240378305A1
公开(公告)日:2024-11-14
申请号:US18316787
申请日:2023-05-12
Applicant: Snowflake Inc.
Inventor: Suraj P. Acharya , Jennifer Wenjun Bi , Khalid Zaman Bijon , Damien Carru , Lin Chan , Tianyi Chen , Jeremy Yujui Chen , Thierry Cruanes , Benoit Dageville , Simon Holm Jensen , Boxin Jiang , Dmitry A. Lychagin , Subramanian Muralidhar , Shuaishuai Nie , Eric Robinson , Sahaj Saini , David Schultz , Kevin Wang , Wenqi Wei , Zixi Zhang , Xingzhe Zhou
Abstract: Systems and methods for generating object references with selectable scopes are provided. The systems and methods perform operations including calling, by a first entity, a reference generator function using one or more arguments associated with a database object that the first entity is authorized to access according to a first set of access privileges, the one or more arguments comprising a scope definition that defines persistence of a reference. The operations include obtaining, from the reference generator function, a reference to the database object, the reference persisting according to the scope definition. The operations include passing the reference to a second entity to enable the second entity to perform one or more database operations on the database object according to a second set of access privileges derived from the first set of access privileges.
-
公开(公告)号:US20240370461A1
公开(公告)日:2024-11-07
申请号:US18772913
申请日:2024-07-15
Applicant: Snowflake Inc.
Inventor: Balachander Atur , Hazem Elmeleegy , Jung Lin Lee , Aditya G. Parameswaran , Devin Petersohn , Mahesh Shankar Vashishtha
IPC: G06F16/28 , G06F9/54 , G06F16/21 , G06F16/2452 , G06F16/248
Abstract: Systems and methods for providing access to information in a relational database via API-operations for dataframes, are disclosed. Exemplary implementations may: store information that represents an input dataframe; generate a first relation that represents the input dataframe, the first relation having a first schema; obtain a dataframe query to be performed on the input dataframe; translate the dataframe query into a sequence of relational database operations; perform the sequence of relational database operations on the first relation to generate a second relation; and present at least a portion of the second relation to a user, and/or perform other steps.
-
公开(公告)号:US12135745B2
公开(公告)日:2024-11-05
申请号:US18461897
申请日:2023-09-06
Applicant: Snowflake Inc.
Inventor: Polita Paulus , Aravind Ramarathinam , Saurin Shah , Sukruth Komarla Sukumar
IPC: G06F16/00 , G06F16/22 , G06F16/2455 , G06F16/901 , G06F16/908 , G06F16/955
Abstract: Disclosed herein are embodiments of systems and methods for synchronizing file-catalog table with a file stage. In an embodiment, a data platform receives a notification of a modification to one or more files in a file stage. The file stage includes data storage having a storage location. The data platform updates, based on receiving the notification of the modification, a first file-catalog table for the file stage based on the modification. The first file-catalog table includes a row for each file in the file stage, as well as a column for each of one or more metadata properties of the one or more files in the file stage.
-
公开(公告)号:US12135734B2
公开(公告)日:2024-11-05
申请号:US18324787
申请日:2023-05-26
Applicant: Snowflake Inc.
Inventor: Pui Kei Johnston Chu , Benoit Dageville , Shreyas Narendra Desai , Nithin Mahesh , Subramanian Muralidhar , Vishnu Dutt Paladugu , Sahaj Saini , Chieh-Sheng Wang , Di Wu
Abstract: Various embodiments provide for replicating a share across deployments of a data platform, where the share can be on a source deployment and the share can be replicated on one or more target deployments, and where the share is replicated with one or more database objects of the source deployment associated with the share. Some embodiments analyze the share to be replicated and, based on the analysis, determine one or more database objects that would be replicated to the one or more target deployments to enable a replica of the share on the one or more target deployments.
-
公开(公告)号:US20240362231A1
公开(公告)日:2024-10-31
申请号:US18764977
申请日:2024-07-05
Applicant: Snowflake Inc.
Inventor: Rachel Frances Blum , Justin Langseth , Michael Earle Rainey
IPC: G06F16/2455 , G06F16/242 , G06F16/27 , G06F21/62
CPC classification number: G06F16/24565 , G06F16/2443 , G06F16/27 , G06F21/6227
Abstract: Embodiments of the present disclosure may provide a data clean room architecture that dynamically restricts data included in the clean room. The data clean room architecture can implement row access policy or dynamic data masking for row and column based restrictions of data provided through the clean room. The data clean room architecture can provide a limited set of data that does not require obfuscation of data for direction matching and correlation of data in the different datasets, such as matching user identifiers or emails.
-
公开(公告)号:US12130835B2
公开(公告)日:2024-10-29
申请号:US18447897
申请日:2023-08-10
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.
-
-
-
-
-
-
-
-
-