NAMESPACE-BASED SYSTEM-USER ACCESS OF DATABASE PLATFORMS

    公开(公告)号:US20210365438A1

    公开(公告)日:2021-11-25

    申请号:US16945546

    申请日:2020-07-31

    Applicant: Snowflake Inc.

    Abstract: A database platform authenticates a system user for access via an application to a database that is associated with a customer account of the database platform. The system user is a first object in a first account-level namespace of the customer account, and the first account-level namespace is distinct from a default account-level namespace of the customer account. The database platform sends, as the system user, a query to the database via the application. The database platform receives, as the system user, results of the query from the database, and stores, as the system user, the results of the query in a first-namespace stage, which is a second object in the first account-level namespace.

    ACCOUNT-LEVEL NAMESPACES FOR DATABASE PLATFORMS

    公开(公告)号:US20210365437A1

    公开(公告)日:2021-11-25

    申请号:US16945344

    申请日:2020-07-31

    Applicant: Snowflake Inc.

    Abstract: A database platform receives an object identifier from a client in association with a database session. The client is associated with a customer account of the database platform, and the database session is associated with the client. In response to receiving the object identifier, the database platform identifies a resolution namespace for the object identifier, where the resolution namespace for the object identifier is a namespace that is specified in the object identifier if the object identifier includes a specified namespace, and where the resolution namespace is otherwise a current account-level namespace of the database session. The database platform resolves the object identifier with reference to the identified resolution namespace for the object identifier, including identifying an object corresponding to the object identifier in the customer account.

    Database replication to remote deployment with automated fulfillment

    公开(公告)号:US11163798B1

    公开(公告)日:2021-11-02

    申请号:US17302397

    申请日:2021-04-30

    Applicant: Snowflake Inc.

    Abstract: Disclosed herein are systems and methods for database replication to a remote deployment with automated fulfillment. In an embodiment, a data platform detects receipt of a database-replication request associated with a data consumer, requesting availability of a local instance of a primary-deployment database in a remote-deployment account of a data provider at a remote deployment of the data platform. The data platform responsively performs remote-deployment-activation operations including provisioning the remote-deployment account with a set of one or more replication-preparation objects associated with the primary-deployment database, and also including invoking at least one refresh command with respect to the set of one or more replication-preparation objects, which makes available to the data consumer a local instance of the primary-deployment database in the remote-deployment account of the data provider at the remote deployment of the data platform.

    Data pruning based on metadata
    566.
    发明授权

    公开(公告)号:US11163724B2

    公开(公告)日:2021-11-02

    申请号:US16861516

    申请日:2020-04-29

    Applicant: Snowflake Inc.

    Abstract: A system and method for pruning data based on metadata. The method may include receiving a query comprising a plurality of predicates and identifying one or more applicable files comprising database data satisfying at least one of the plurality of predicates. The identifying the one or more applicable files including reading metadata stored in a metadata store that is separate from the database data. The method further includes pruning inapplicable files comprising database data that does not satisfy at least one of the plurality of predicates to create a reduced set of files and reading the reduced set of files to execute the query.

    DATA SHARING USING ALIAS OBJECTS
    568.
    发明申请

    公开(公告)号:US20210312070A1

    公开(公告)日:2021-10-07

    申请号:US17354972

    申请日:2021-06-22

    Applicant: SNOWFLAKE INC.

    Abstract: A method of sharing data in a multi-tenant database includes generating a share object in a first account comprising a share role. The method includes associating one or more access rights with the share role, wherein the one or more access rights indicate which objects in the first account are accessible based on the share object. The method includes granting, to a second account, cross-account access rights to the share role or share object in the first account. The method includes receiving a request from the second account to access data or services of the first account. The method further includes providing a response to the second account based on the data or services of the first account.

Patent Agency Ranking