Database redaction for semi-structured and unstructured data

    公开(公告)号:US11954224B1

    公开(公告)日:2024-04-09

    申请号:US18239527

    申请日:2023-08-29

    Applicant: SNOWFLAKE INC.

    CPC classification number: G06F21/6227 G06F16/285 G06F21/6254

    Abstract: 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.

    HYBRID TABLE SECONDARY INDEX FOR LOOKUPS, UNIQUE CHECKS, AND REFERENTIAL INTEGRITY CONSTRAINTS

    公开(公告)号:US20240104116A1

    公开(公告)日:2024-03-28

    申请号:US18524784

    申请日:2023-11-30

    Applicant: Snowflake Inc.

    CPC classification number: G06F16/283 G06F16/2264 G06F16/284

    Abstract: The subject technology generates a nested object based on a set of metadata, the set of metadata including information linking the nested object to a table object associated with a base table. The subject technology generates a second table object associated with the nested object, the second table object representing a secondary index of the base table, the second table object including information linking the second table object to the nested object. The subject technology generates a second nested object based on a particular set of metadata, the particular set of metadata including information linking the second nested object to the table object. The subject technology generates a third table object associated with the second nested object, the third table object representing a particular secondary index of the base table, the third table object including information linking the third table object to the second nested object.

    SYSTEMS AND METHODS FOR ATTACHABLE-AND-DETACHABLE DATABASE SESSIONS

    公开(公告)号:US20240095217A1

    公开(公告)日:2024-03-21

    申请号:US18522182

    申请日:2023-11-28

    Applicant: Snowflake Inc.

    Abstract: In an embodiment, a database platform maintains a first account and a second account, where the second account has stored therein an attachable-and-detachable database session. The database platform receives, from a second-account user in the second account, a request to grant, to a first-account user in the first account, access to the attachable-and-detachable database session, and responsively grants the requested access. The database platform receives, from the first-account user, an attachment request requesting that the first-account user attach to the attachable-and-detachable database session, and responsively sets the attachable-and-detachable database session as a current database session for the first-account user. The database platform executes at least one command received from the first-account user with respect to the attachable-and-detachable database session.

    IDENTIFYING SOFTWARE REGRESSIONS BASED ON QUERY RETRY ATTEMPTS IN A DATABASE ENVIRONMENT

    公开(公告)号:US20240086397A1

    公开(公告)日:2024-03-14

    申请号:US18511204

    申请日:2023-11-16

    Applicant: Snowflake Inc.

    CPC classification number: G06F16/2365 G06F16/2455

    Abstract: Systems, methods, and devices for retrying a query. A method includes receiving a query directed to database data and assigning execution of the query to one or more execution nodes of an execution platform, the one or more execution nodes configured to execute the query on a first version of a database platform. The method includes determining that execution of the query was unsuccessful. The method includes assigning a first retry execution of the query to the one or more execution nodes of the execution platform and determining whether a regression or an intermittent fault caused the execution of the query to be unsuccessful based at least in part on whether the first retry execution of the query was successful or unsuccessful.

    Two-way data sharing between private and public clouds

    公开(公告)号:US11929986B1

    公开(公告)日:2024-03-12

    申请号:US18325388

    申请日:2023-05-30

    Applicant: Snowflake Inc.

    CPC classification number: H04L63/0263 G06F21/6218 H04L63/0272 H04L63/083

    Abstract: Methods, systems, and computer programs are presented for enabling automated secure data sharing from a private cloud region to a public cloud region and vice versa. A cloud data platform confirms a relationship establishment procedure between a provider and a consumer is recorded with a cloud data platform, the provider being associated with a private cloud deployment and the consumer being associated with a public cloud deployment in a public region. The cloud data platform enables disabling of a firewall policy that is preventing data traffic between the private cloud deployment and the public cloud deployment and enables data sharing between the private cloud deployment and the public cloud deployment. The cloud data platform enables data sharing in a database of the cloud data platform.

Patent Agency Ranking