Bundle creation and distribution

Patent metadata

Field	Value
Publication number	US-11797497-B2
Application number	US-202218068998-A
Country	US
Kind code	B2
Filing date	Dec 20, 2022
Priority date	Feb 25, 2022
Publication date	Oct 24, 2023
Grant date	Oct 24, 2023

Abstract

Techniques for creating, sharing, and using bundles (also referred to as packages) in a multi-tenant database are described herein. A bundle is a schema object with associated hidden schemas. A bundle can be created by a provider user and can be shared with a plurality of consumer users. The bundle can be used to enable code sharing and distribution without losing control while maintaining security protocols.

First claim

What is claimed is:

1. A method comprising:
providing, by a provider account, a bundle to a consumer account, the bundle including an interface directly accessible to the consumer account and a hidden bundle schema not directly accessible by the consumer account, the bundle schema including a code portion;
receiving, from the consumer account, a command referencing the bundle;
executing the code portion of the bundle in context of a hidden bundle role; and
transmitting results of the command to the consumer account.

2. The method of claim 1 , wherein the bundle resides in an account associated with the provider account in a multi-tenant database and the bundle is shared by the provider account to the consumer account.

3. The method of claim 1 , wherein the bundle includes a plurality of versions, and the provider account provides access to a first version of the plurality of versions to the consumer account.

4. The method of claim 3 , wherein the consumer account is a first consumer account;
wherein the provider account provides access to a second version of the plurality of versions to a second consumer account while providing access to the first version to the first consumer account.

5. The method of claim 1 , further comprising:
providing a security barrier between the interface and the hidden bundle schema, wherein the security barrier restricts access of the consumer account to non-exposed objects in the hidden bundle schema, and wherein the security barrier restricts objects in the hidden bundle schema from accessing objects outside the hidden bundle schema.

6. The method of claim 1 , wherein the code portion includes a procedure or a function.

7. The method of claim 1 , wherein the hidden bundle schema includes a stage or a table.

8. A machine-storage medium embodying instructions that, when executed by a machine, cause the machine to perform operations comprising:
providing, by a provider account, a bundle to a consumer account, the bundle including an interface directly accessible to the consumer account and a hidden bundle schema not directly accessible by the consumer account, the bundle schema including a code portion;
receiving, from the consumer account, a command referencing the bundle;
executing the code portion of the bundle in context of a hidden bundle role; and
transmitting results of the command to the consumer account.

9. The machine-storage medium of claim 8 , wherein the bundle resides in an account associated with the provider account in a multi-tenant database and the bundle is shared by the provider account to the consumer account.

10. The machine-storage medium of claim 8 , wherein the bundle includes a plurality of versions, and the provider account provides access to a first version of the plurality of versions to the consumer account.

11. The machine-storage medium of claim 10 , wherein the consumer account is a first consumer account;
wherein the provider account provides access to a second version of the plurality of versions to a second consumer account while providing access to the first version to the first consumer account.

12. The machine-storage medium of claim 8 , further comprising:
providing a security barrier between the interface and the hidden bundle schema, wherein the security barrier restricts access of the consumer account to non-exposed objects in the hidden bundle schema, and wherein the security barrier restricts objects in the hidden bundle schema from accessing objects outside the hidden bundle schema.

13. The machine-storage medium of claim 8 , wherein the code portion includes a procedure or a function.

14. The machine-storage medium of claim 8 , wherein the hidden bundle schema includes a stage or a table.

15. A system comprising:
at least one hardware processor; and
at least one memory storing instructions that, when executed by the at least one hardware processor, cause the at least one hardware processor to perform operations comprising:
providing, by a provider account, a bundle to a consumer account, the bundle including an interface directly accessible to the consumer account and a hidden bundle schema not directly accessible by the consumer account, the bundle schema including a code portion;
receiving, from the consumer account, a command referencing the bundle;
executing the code portion of the bundle in context of a hidden bundle role; and
transmitting results of the command to the consumer account.

16. The system of claim 15 , wherein the bundle resides in an account associated with the provider account in a multi-tenant database and the bundle is shared by the provider account to the consumer account.

17. The system of claim 15 , wherein the bundle includes a plurality of versions, and the provider account provides access to a first version of the plurality of versions to the consumer account.

18. The system of claim 17 , wherein the consumer account is a first consumer account;
wherein the provider account provides access to a second version of the plurality of versions to a second consumer account while providing access to the first version to the first consumer account.

19. The system of claim 15 , the operations further comprising:
providing a security barrier between the interface and the hidden bundle schema, wherein the security barrier restricts access of the consumer account to non-exposed objects in the hidden bundle schema, and wherein the security barrier restricts objects in the hidden bundle schema from accessing objects outside the hidden bundle schema.

20. The system of claim 15 , wherein the code portion includes a procedure or a function.

21. The system of claim 15 , wherein the hidden bundle schema includes a stage or a table.

Assignees

• Snowflake Inc

Inventors

• Carru Damien
• Dageville Benoit
• Muralidhar Subramanian
• Robinson Eric
• Saini Sahaj
• Schultz David

Classifications

• G06F16/212 Primary

  with details for data modelling support · CPC title

• G06F16/285

  Clustering or classification · CPC title

• G06F21/6245 Primary

  Protecting personal data, e.g. for financial or medical purposes · CPC title

• G06F21/604

  Tools and structures for managing or administering access control systems · CPC title