IP Library Granted Patent US 11,843,608
Granted Patent B2
US 11,843,608 · App. 18/184,145 · Granted Dec 12, 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/2455G06F21/606G06F21/6218H04L41/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,843,608
App. No.
18/184,145
Granted
Dec 12, 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, each of the plurality of listings comprising version metadata and referencing a data set within a database. The method further includes receiving a request for access to a first listing of the plurality of listings and, in response to the request, accessing a first version of the data set that is compatible with first version metadata of the first listing.

Claims (54)

1. A method comprising:

generating a plurality of listings in a data exchange, each of the plurality of listings comprising version metadata and referencing a data set within a database;

receiving a request for access to a first listing of the plurality of listings; and

in response to the request, accessing, by a processing device, a first version of the data set that is compatible with first version metadata of the first listing, wherein:

the first version of the data set within the database comprises a first structure;

a second listing of the plurality of listings within the database comprises a second version of the data set; and

the second version comprises a second structure that is incompatible with the first structure of the first version.

2. The method of claim 1 , further comprising:

requesting a confirmation for access to the second version of the data set;

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

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

3. The method of claim 1 , wherein accessing the first version of the data set that is compatible with the first version metadata of the first listing comprises limiting the access to the first listing to a portion of the data set that is less than all of the database.

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

5. The method of claim 1 , wherein the request is a first request, and wherein the method further comprises:

receiving a second request for access to the second listing of the plurality of listings, wherein the second listing comprises a reference to the second version of the data set, different from the first version; and

in response to the second request, accessing the second version of the data set that is compatible with second version metadata of the second listing.

6. The method of claim 5 , wherein the second version of the data set comprises one or more of a different formatting from the first version of the data set, different columns from the first version of the data set, or a structure that is incompatible with the first version of the data set.

7. 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, each of the plurality of listings comprising version metadata and referencing a data set within a database;

receive a request for access to a first listing of the plurality of listings; and

in response to the request, access a first version of the data set that is compatible with first version metadata of the first listing, wherein:

the first version of the data set within the database comprises a first structure;

a second listing of the plurality of listings within the database comprises a second version of the data set; and

the second version comprises a second structure that is incompatible with the first structure of the first version.

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

request a confirmation for access to the second version of the data set;

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

limit access to the second version of the data set of the database referenced by the first listing.

9. The system of claim 7 , wherein, to access the first version of the data set that is compatible with the first version metadata of the first listing, the processing device is to limit the access to the first listing to a portion of the data set that is less than all of the database.

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

11. The system of claim 7 , wherein the request is a first request, and

wherein the processing device is further to:

receive a second request for access to the second listing of the plurality of listings, wherein the second listing comprises a reference to the second version of the data set, different from the first version; and

in response to the second request, access the second version of the data set that is compatible with second version metadata of the second listing.

12. The system of claim 11 , wherein the second version of the data set comprises one or more of a different formatting from the first version of the data set, different columns from the first version of the data set, or a structure that is incompatible with the first version of the data set.

13. 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, each of the plurality of listings comprising version metadata and referencing a data set within a database;

receive a request for access to a first listing of the plurality of listings; and

in response to the request, access, by the processing device, a first version of the data set that is compatible with first version metadata of the first listing, wherein:

the first version of the data set within the database comprises a first structure;

a second listing of the plurality of listings within the database comprises a second version of the data set; and

the second version comprises a second structure that is incompatible with the first structure of the first version.

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

request a confirmation for access to the second version of the data set;

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

limit access to the second version of the data set of the database referenced by the first listing.

15. The non-transitory computer-readable medium of claim 13 , wherein, to access the first version of the data set that is compatible with the first version metadata of the first listing, the processing device is to limit the access to the first listing to a portion of the data set that is less than all of the database.

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

17. The non-transitory computer-readable medium of claim 13 , wherein the request is a first request, and

wherein the processing device is further to:

receive a second request for access to the second listing of the plurality of listings, wherein the second listing comprises a reference to the second version of the data set, different from the first version; and

in response to the second request, access the second version of the data set that is compatible with second version metadata of the second listing.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 15, 2023
From: GLICKMAN, MATTHEW; KLEINERMAN, CHRISTIAN; KRISHNAN, PRASANNA; LANGSETH, JUSTIN; DAGEVILLE, BENOIT; CHU, PUI KEI JOHNSTON
To: SNOWFLAKE INC.
Reel/Frame 062991/0262 →
Continuity (7)
Continuation 17702115 · Mar 23, 2022
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 20230231853A1 · Jul 20, 2023