IP Library Granted Patent US 11,637,836
Granted Patent B2
US 11,637,836 · App. 17/702,115 · Granted Apr 25, 2023

Managing version sharing in a data exchange

Inventors: Pui Kei Johnston Chu (San Mateo, CA); Benoit Dageville (Foster City, CA); Matthew J. Glickman (Larchmont, NY); Christian Kleinerman (Burlingame, CA); Prasanna Krishnan (Palo Alto, CA); Justin Langseth (Kailua, HI)
Assignee: Snowflake Inc.
H04L63/102G06F16/2455H04L41/22H04L51/212H04L63/101H04L67/1097
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,637,836
App. No.
17/702,115
Granted
Apr 25, 2023
Kind
B2
Abstract

Systems and methods for managing membership in a private data exchange are provided herein. In one embodiment, the method includes generating a plurality of listings in a data exchange. A first listing of the plurality of listings may include a reference to a first version of shared data within a first database, where the first version is one of a plurality of versions of the shared data within the first database. The method further includes receiving a request from a member of the data exchange for access to the first listing and limiting, by a processing device, access for the member to the first version of the shared data of the first database referenced by the first listing.

Claims (51)

1. A method comprising:

generating a plurality of listings in a data exchange, wherein a first listing of the plurality of listings comprises a reference to a first version of shared data within a first database, wherein the first version is one of a plurality of versions of the shared data within the first database, wherein a data set within the first version of the shared data within the first database comprises a first structure, wherein the data set within a second version of the plurality of versions of the shared data within the first database comprises a second structure, and wherein the first structure of the first version is incompatible with the second structure of the second version;

receiving a request from a member of the data exchange for access to the first listing; and

limiting, by a processing device, access for the member to the first version of the shared data of the first database referenced by the first listing.

2. The method of claim 1 , wherein the first listing comprises metadata, and

wherein the metadata comprises version metadata corresponding to the first version.

3. The method of claim 1 , further comprising:

requesting a confirmation from the member for access to the second version of the shared data;

modifying the first listing to comprise a reference to the second version of the shared data responsive to receiving the confirmation from the member; and

limiting, by the processing device, access for the member to the second version of the shared data of the first database referenced by the first listing.

4. The method of claim 1 , wherein limiting, by the processing device, access for the member to the first version of the shared data of the first database referenced by the first listing comprises limiting the access for the member to a portion of the shared data that is less than all of the first database.

5. The method of claim 1 , wherein access for the member to the first version of the shared data is further limited based on a set of visibility and access rules for the first listing.

6. The method of claim 1 , wherein the member is a first member, and

wherein the method further comprises:

receiving a request from a second member of the data exchange for access to a second listing of the data exchange, wherein the second listing comprises a reference to the second version of the shared data, different from the first version; and

limiting, by the processing device, access for the second member to the second version of the shared data of the first database referenced by the second listing.

7. The method of claim 6 , wherein the second version of the shared data comprises the data set having one or more of a different formatting from the first version of the shared data or different columns from the first version of the shared data.

8. A system comprising:

a memory; and

a processing device operatively coupled to the memory, the processing device to:

generate a plurality of listings in a data exchange, wherein a first listing of the plurality of listings comprises a reference to a first version of shared data within a first database, wherein the first version is one of a plurality of versions of the shared data within the first database, wherein a data set within the first version of the shared data within the first database comprises a first structure, wherein the data set within a second version of the plurality of versions of the shared data within the first database comprises a second structure, and wherein the first structure of the first version is incompatible with the second structure of the second version;

receive a request from a member of the data exchange for access to the first listing; and

limit access for the member to the first version of the shared data of the first database referenced by the first listing.

9. The system of claim 8 , wherein the first listing comprises metadata, and

wherein the metadata comprises version metadata corresponding to the first version.

10. The system of claim 8 , wherein the processing device is further to:

request a confirmation from the member for access to the second version of the shared data;

modify the first listing to comprise a reference to the second version of the shared data responsive to receiving the confirmation from the member; and

limit access for the member to the second version of the shared data of the first database referenced by the first listing.

11. The system of claim 8 , wherein to limit access for the member to the first version of the shared data of the first database referenced by the first listing the processing device is to limit the access for the member to a portion of the shared data that is less than all of the first database.

12. The system of claim 8 , wherein access for the member to the first version of the shared data is further limited based on a set of visibility and access rules for the first listing.

13. The system of claim 8 , wherein the member is a first member, and

wherein the processing device is further to:

receive a request from a second member of the data exchange for access to a second listing of the data exchange, wherein the second listing comprises a reference to the second version of the shared data, different from the first version; and

limit, by the processing device, access for the second member to the second version of the shared data of the first database referenced by the second listing.

14. The system of claim 13 , wherein the second version of the shared data comprises the data set having one or more of a different formatting from the first version of the shared data or different columns from the first version of the shared data.

15. A non-transitory computer-readable medium having instructions stored thereon which, when executed by a processing device, cause the processing device to:

generate a plurality of listings in a data exchange, wherein a first listing of the plurality of listings comprises a reference to a first version of shared data within a first database, wherein the first version is one of a plurality of versions of the shared data within the first database, wherein a data set within the first version of the shared data within the first database comprises a first structure, wherein the data set within a second version of the plurality of versions of the shared data within the first database comprises a second structure, and wherein the first structure of the first version is incompatible with the second structure of the second version;

receive a request from a member of the data exchange for access to the first listing; and

limit, by the processing device, access for the member to the first version of the shared data of the first database referenced by the first listing.

16. The non-transitory computer-readable medium of claim 15 , wherein the processing device is further to:

request a confirmation from the member for access to the second version of the shared data;

modify the first listing to comprise a reference to the second version of the shared data responsive to receiving the confirmation from the member; and

limit access for the member to the second version of the shared data of the first database referenced by the first listing.

17. The non-transitory computer-readable medium of claim 15 , wherein to limit access for the member to the first version of the shared data of the first database referenced by the first listing the processing device is to limit the access for the member to a portion of the shared data that is less than all of the first database.

18. The non-transitory computer-readable medium of claim 15 , wherein access for the member to the first version of the shared data is further limited based on a set of visibility and access rules for the first listing.

19. The non-transitory computer-readable medium of claim 15 , wherein the member is a first member, and

wherein the processing device is further to:

receive a request from a second member of the data exchange for access to a second listing of the data exchange, wherein the second listing comprises a reference to the second version of the shared data, different from the first version; and

limit, by the processing device, access for the second member to the second version of the shared data of the first database referenced by the second listing.

20. The non-transitory computer-readable medium of claim 19 , wherein the second version of the shared data comprises the data set having one or more of a different formatting from the first version of the shared data or different columns from the first version of the shared data.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Feb 9, 2023
From: GLICKMAN, MATTHEW; KLEINERMAN, CHRISTIAN; KRISHNAN, PRASANNA; LANGSETH, JUSTIN; DAGEVILLE, BENOIT; CHU, PUI KEI JOHNSTON
To: SNOWFLAKE INC.
Reel/Frame 062639/0714 →
Continuity (6)
Continuation 17513360 · Oct 28, 2021
Continuation 17237416 · Apr 22, 2021
Continuation 17027863 · Sep 22, 2020
Continuation 16746758 · Jan 17, 2020
Provisional Application 62899571 · Sep 12, 2019
Related Publication 20220217150A1 · Jul 7, 2022