Shared object discovery techniques

Patent metadata

Field	Value
Publication number	US-11809586-B2
Application number	US-202217980427-A
Country	US
Kind code	B2
Filing date	Nov 3, 2022
Priority date	Oct 29, 2021
Publication date	Nov 7, 2023
Grant date	Nov 7, 2023

Abstract

A consumer account may invoke an operation referencing a set of shared objects stored within a database of a provider account using an imported database that makes the set of shared objects available within the consumer account. A call context of the operation may be updated to cache the imported database, which references a share created from the provider account database, the share having grants to the set of shared objects. One or more database level objects may be discovered in a context of the share and each role granted to the share may be obtained based on the one or more database level objects. Whether any role granted to the share has access to any of the set of shared objects may be determined and the operation may be executed for each of the set of shared objects to which any role granted to the share has access.

First claim

What is claimed is:

1. A method comprising:
invoking, via a role of a consumer account, an operation referencing a set of shared objects stored within a database of a provider account using an imported database of the consumer account that makes the set of shared objects available within the consumer account;
updating, by a processing device, a call context of the operation to save the imported database as a current database used to resolve the operation, wherein the imported database references a share created from the database of the provider account, the share having grants to the set of shared objects, and wherein the call context comprises a role used to resolve the operation, a virtual warehouse used to resolve the operation, the current database, and a schema used to resolve the operation;
discovering one or more database level objects in a context of the share referenced by the imported database;
obtaining each role granted to the share based on the one or more database level objects;
saving each of the one or more database level objects as a class object that includes a reference to the imported database as a database from which the database level object originated;
using the reference of each of the one or more database level objects to obtain each role granted to the share;
determining whether any role granted to the share has access to any of the set of shared objects; and
executing the operation for each of the set of shared objects to which any role granted to the share has access.

2. The method of claim 1 , further comprising:
setting an active sharing context object such that an identifier (ID) of the share referenced by the imported database is set as a current share ID to mark a dictionary cache tied to the share as active.

3. The method of claim 2 , wherein updating the call context of the operation comprises:
adding the imported database to the active dictionary cache; and
adding a parent identifier (ID) of the imported database to a list of locally imported database identifiers.

4. The method of claim 3 , wherein during an object lookup operation, if a first class object corresponding to a database level object of the one or more database level objects is stored in the active dictionary cache, the first class object is returned and references as a database from which the first class object originated, the imported database.

5. The method of claim 2 , wherein using the reference of each of the database level objects to obtain each role granted to the share comprises:
determining that each of the one or more database level objects is in a sharing context;
identifying the imported database; and
deriving a pointer to the share, wherein the pointer is used to obtain each role granted to the share.

6. The method of claim 1 , wherein the operation is an operation to reveal the set of shared objects within the provider account.

7. The method of claim 1 , wherein the set of shared objects within the provider account comprise a set of views.

8. The method of claim 1 , wherein the set of shared objects within the provider account comprise one or more native applications.

9. The method of claim 1 , wherein the class object is a Java instance.

10. A system comprising:
a memory; and
a processing device operatively coupled to the memory, the processing device to:
invoke, via a role of a consumer account, an operation referencing a set of shared objects stored within a database of a provider account using an imported database of the consumer account that makes the set of shared objects available within the consumer account;
update a call context of the operation to save the imported database as a current database used to resolve the operation, wherein the imported database references a share created from the database of the provider account, the share having grants to the set of shared objects, and wherein the call context comprises a role used to resolve the operation, a virtual warehouse used to resolve the operation, the current database, and a schema used to resolve the operation;
discover one or more database level objects in a context of the share referenced by the imported database;
save each of the one or more database level objects as a class object that includes a reference to the imported database as a database from which the database level object originated;
use the reference of each of the one or more database level objects to obtain each role granted to the share;
determine whether any role granted to the share has access to any of the set of shared objects; and
execute the operation for each of the set of shared objects to which any role granted to the share has access.

11. The system of claim 10 , wherein the processing device is further to:
set an active sharing context object such that an identifier (ID) of the share referenced by the imported database is set as a current share ID to mark a dictionary cache tied to the share as active.

12. The system of claim 11 , wherein to update the call context of the operation, the processing device is to:
add the imported database to the active dictionary cache; and
add a parent identifier (ID) of the imported database to a list of locally imported database identifiers.

13. The system of claim 12 , wherein during an object lookup operation, if a first class object corresponding to a database level object of the one or more database level objects is stored in the active dictionary cache, the first class object is returned and references as a database from which the first class object originated, the imported database.

14. The system of claim 11 , wherein to use the reference of each of the database level objects to obtain each role granted to the share, the processing device is to:
determine that each of the one or more database level objects are in a sharing context;
identify the imported database; and
derive a pointer to the share, wherein the pointer is used to obtain each role granted to the share.

15. The system of claim 10 , wherein the operation is an operation to reveal the set of shared objects within the provider account.

16. The system of claim 10 , wherein the set of shared objects within the provider account comprise a set of views.

17. The system of claim 10 , wherein the set of shared objects within the provider account comprise one or more native applications.

18. The system of claim 10 , wherein the class object is a Java instance.

19. A non-transitory computer-readable medium having instructions stored thereon which, when executed by a processing device, cause the processing device to:
invoke, via a role of a consumer account, an operation referencing a set of shared objects stored within a database of a provider account using an imported database of the consumer account that makes the set of shared objects available within the consumer account;
update, by the processing device, a call context of the operation to save the imported database as a current database used to resolve the operation, wherein the imported database references a share created from the database of the provider account, the share having grants to the set of shared objects, and wherein the call context comprises a role used to resolve the operation, a virtual warehouse used to resolve the operation, the current database, and a schema used to resolve the operation;
discover one or more database level objects in a context of the share referenced by the imported database;
save each of the one or more database level objects as a class object that inc

Assignees

• Snowflake Inc

Inventors

• Carru Damien
• Chen Jeremy Yujui
• Chu Pui Kei Johnston
• Dageville Benoit
• Muralidhar Subramanian

Classifications

• G06F21/6218 Primary

  to a system of files or objects, e.g. local or distributed file system or database · CPC title

• G06F16/213 Primary

  with details for schema evolution support · CPC title

• G06F16/24552

  Database cache management · CPC title

• G06F2221/2141

  Access rights, e.g. capability lists, access control lists, access tables, access matrices · CPC title