-
公开(公告)号:US20230334167A1
公开(公告)日:2023-10-19
申请号:US18341935
申请日:2023-06-27
Applicant: Snowflake Inc.
Inventor: Artin Avanes , Khalid Zaman Bijon , Zheng Mi , Subramanian Muralidhar , David Schultz , Jian Xu
CPC classification number: G06F21/6227 , G06F21/604 , G06F16/2282 , G06F21/62 , G06F21/6218 , G06F2221/2141
Abstract: Row-level security (RLS) may provide fine-grained access control based on flexible, user-defined access policies to databases, tables, objects, and other data structures. A RLS policy may be an entity or object that defines rules for row access. A RLS policy may be decoupled or independent from any specific table. This allows more robust and flexible control. A RLS policy may then be attached to one or more tables. The RLS policy may include a Boolean-valued expression.
-
公开(公告)号:US20230315700A1
公开(公告)日:2023-10-05
申请号:US17971482
申请日:2022-10-21
Applicant: Snowflake Inc.
IPC: G06F16/215 , G06F16/248 , G06F16/2455 , G06F16/2457
CPC classification number: G06F16/215 , G06F16/248 , G06F16/24552 , G06F16/24573
Abstract: Embodiments of the present disclosure provide techniques for deduplicating files to be ingested by a database. A bloom filter may be built for each of a first set of files to be ingested into a data exchange to generate a set of bloom filters, wherein the data exchange includes a metadata storage where metadata including a list of files ingested is stored. The set of bloom filters may be stored in the metadata storage of the data exchange. In response to receiving a set of candidate files to be ingested into the data exchange, the set of bloom filters may be used to identify from within the set of candidate files, each candidate file that is duplicative of a file in the first set of files.
-
公开(公告)号:US11748374B2
公开(公告)日:2023-09-05
申请号:US17457751
申请日:2021-12-06
Applicant: Snowflake Inc.
Inventor: Robert Bengt Benedikt Gernhardt , Mikhail Kazhamiaka , Nithin Mahesh , Laxman Mamidi , Subramanian Muralidhar , Vishnu Dutt Paladugu , Sahaj Saini
IPC: G06F16/00 , G06F16/27 , G06F11/14 , G06F16/25 , G06F11/20 , G06F16/182 , G06F16/13 , G06F16/178 , G06F16/11
CPC classification number: G06F16/27 , G06F11/1461 , G06F11/1464 , G06F11/2023 , G06F11/2097 , G06F16/128 , G06F16/137 , G06F16/1787 , G06F16/184 , G06F16/1827 , G06F16/1844 , G06F16/256
Abstract: Provided herein are systems and methods for configuring replication group objects. A system includes at least one hardware processor coupled to memory and configured to decode a replication request received from a client device of a data provider. The replication request indicates a plurality of account objects for replication. The plurality of account objects associated with a corresponding plurality of account object types. A replication group object is generated based on the replication request. The replication group object includes a manifest. The manifest lists the plurality of account objects. The replication of the plurality of account objects is performed from a source account of the data provider into at least one target account. The replication is based on the manifest of the replication group object.
-
公开(公告)号:US20230252189A1
公开(公告)日:2023-08-10
申请号:US18161574
申请日:2023-01-30
Applicant: Snowflake Inc.
Inventor: Raja Suresh Krishna Balakrishnan , Khalid Zaman Bijon , Subramanian Muralidhar , David Schultz
IPC: G06F21/62 , G06F16/28 , G06F16/245
CPC classification number: G06F21/6254 , G06F16/284 , G06F16/245
Abstract: Various embodiments provide for tag-based application of a masking policy, which can be used in connection with a data platform. In particular, various embodiments enable enforcement of one or more masking policies against an entity (e.g., object) of a data platform, such as a database, a table, a row, or a column, based on one or more tags associated with the entity.
-
公开(公告)号:US20230252039A1
公开(公告)日:2023-08-10
申请号:US18302515
申请日:2023-04-18
Applicant: Snowflake Inc.
CPC classification number: G06F16/254 , G06F16/2282 , G06F16/258
Abstract: Techniques for configuring event tables include retrieving, by at least one hardware processor of a computing node, log data at a first process of the computing node. The log data is associated with a function executing at a second process of the computing node. The log data is revised using a table stage to generate revised log data. The table stage is configured as a dedicated storage location of the first process. The revising includes a data enrichment process based on metadata associated with execution of the function at the second process. The revised log data is ingested into an event table.
-
公开(公告)号:US11704338B1
公开(公告)日:2023-07-18
申请号:US17652721
申请日:2022-02-28
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
CPC classification number: G06F16/27 , G06F16/213 , G06F16/256
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.
-
公开(公告)号:US20230185952A1
公开(公告)日:2023-06-15
申请号:US18167950
申请日:2023-02-13
Applicant: Snowflake Inc.
Inventor: Damien Carru , Jeremy Yujui Chen , Pui Kei Johnston Chu , Thierry Cruanes , Istvan Cseri , Benoit Dageville , Unmesh Jagtap , Subramanian Muralidhar
CPC classification number: G06F21/6227 , G06F9/44505 , G06Q30/06 , G06F2221/2141
Abstract: Embodiments of the present disclosure enable users of a data sharing system to build native applications that can be shared with other users of the data sharing system. The native applications can be published and discovered in the data sharing system like any other data listing, and consumers can install them in their local data sharing system account to serve their data processing needs. A provider may define an installation script for installing an application and create a share object to which the installation script may be attached. In response to an imported database being created in a consumer account based on the share object, a native application framework may automatically execute the installation script in the consumer account and may create a set of database roles to manage execution of the application in the consumer account.
-
公开(公告)号:US20230177039A1
公开(公告)日:2023-06-08
申请号:US18162513
申请日:2023-01-31
Applicant: Snowflake Inc.
Inventor: Subramanian Muralidhar , Istvan Cseri , Torsten Grabs , Benoit Dageville
IPC: G06F16/23 , G06F16/27 , G06F16/245 , G06F16/18
CPC classification number: G06F16/2358 , G06F16/278 , G06F16/2365 , G06F16/245 , G06F16/2322 , G06F16/1865 , G06F9/466
Abstract: A method for table data processing includes retrieving, by at least one hardware processor, first table data associated with a first table version from a plurality of partitions of a storage device. The method further includes detecting, by the at least one hardware processor, an executed transaction causing a modification to the first table data resulting in a second table data associated with a second table version. The second table data is modified to include partition metadata. The partition metadata includes table version information with a mapping of the first table version and the second table version to a plurality of transactions associated with generating the first table data and the second table data.
-
公开(公告)号:US11669630B1
公开(公告)日:2023-06-06
申请号:US18051401
申请日:2022-10-31
Applicant: Snowflake Inc.
Inventor: Durga Mahesh Arikatla , Subramanian Muralidhar , Vishnu Dutt Paladugu , Shakhina Pulatova , Di Wu , Ziqi Xu
CPC classification number: G06F21/6218 , G06F21/604 , G06F2221/2141
Abstract: A data dictionary generation system utilizes a background service that is programmed to automatically populate and update a data dictionary for listings offering shared data. A data dictionary includes metadata describing the shared data overall as well as the individual objects included in the listing, such as the individual tables, schemas, views, and functions. To generate the data dictionary, the data dictionary generation system analyzes the shared data to identify objects, identifies a set of data fields associated with each identified object and populates the set of data fields associated with each identified object based on the shared data offered by the listing. To ensure that a data dictionary for each listing remains up to date, the data dictionary generation system periodically scans the listings to identify any changes to share access granted to the listings.
-
公开(公告)号:US20230169090A1
公开(公告)日:2023-06-01
申请号:US17457751
申请日:2021-12-06
Applicant: Snowflake Inc.
Inventor: Robert Bengt Benedikt Gernhardt , Mikhail Kazhamiaka , Nithin Mahesh , Laxman Mamidi , Subramanian Muralidhar , Vishnu Dutt Paladugu , Sahaj Saini
CPC classification number: G06F16/27 , G06F11/1464 , G06F11/1461 , G06F11/2023 , G06F16/256
Abstract: Provided herein are systems and methods for configuring replication group objects. A system includes at least one hardware processor coupled to memory and configured to decode a replication request received from a client device of a data provider. The replication request indicates a plurality of account objects for replication. The plurality of account objects associated with a corresponding plurality of account object types. A replication group object is generated based on the replication request. The replication group object includes a manifest. The manifest lists the plurality of account objects. The replication of the plurality of account objects is performed from a source account of the data provider into at least one target account. The replication is based on the manifest of the replication group object.
-
-
-
-
-
-
-
-
-