Managing membership rights in a data exchange
Systems and methods for managing membership in a private data exchange are provided herein. In one embodiment, the method includes generating, by a first member of a data exchange a listing. The listing comprises a reference to shared data within a database controlled by the first member. The method further includes providing a second member of the data exchange with a set of rights with respect to listing. The method further includes limiting, by a processing device, access for the second member to a portion of the shared data that is less than all of the database referenced by the listing based on the set of rights of the second member with respect to the listing.
1. A method comprising:
generating, by a first member of a data exchange, a listing comprising a reference to shared data within a database controlled by the first member;
providing a second member of the data exchange with a set of rights with respect to the listing; and
limiting, by a processing device, access for the second member to a portion of the shared data that is less than all of the database referenced by the listing based on the set of rights of the second member with respect to the listing.
2. The method of claim 1 , wherein the access for the second member comprises running queries on the portion of the shared data referenced by the listing.
3. The method of claim 2 , wherein the queries comprise structured query language (SQL) commands.
4. The method of claim 1 , wherein providing the set of rights to the second member comprises assigning an account type to the second member.
5. The method of claim 4 , wherein the set of rights with respect to the listing for the second member is based on the account type assigned to the second member.
6. The method of claim 1 , wherein the listing is a first listing of a plurality of listings of the data exchange and the database is a first database, and
wherein the method further comprises:
generating, by a third member of the data exchange, a second listing comprising a reference to shared data within a second database controlled by the third member; and
limiting access for the second member to a portion of the shared data of the second database that is less than all of the second database.
7. The method of claim 1 , wherein the listing is one of a plurality of listings in a catalog of the data exchange, and
wherein the method further comprises controlling visibility of the second member to the listing in the catalog based on the set of rights of the second member.
8. A system comprising:
a memory; and
a processing device operatively coupled to the memory, the processing device to:
generate, by a first member of a data exchange, a listing comprising a reference to shared data within a database controlled by the first member;
provide a second member of the data exchange with a set of rights with respect to the listing; and
limit, by the processing device, access for the second member to a portion of the shared data that is less than all of the database referenced by the listing based on the set of rights of the second member with respect to the listing.
9. The system of claim 8 , wherein the access for the second member comprises running queries on the portion of the shared data referenced by the listing.
10. The system of claim 9 , wherein the queries comprise structured query language (SQL) commands.
11. The system of claim 8 , wherein providing the set of rights to the second member comprises assigning an account type to the second member.
12. The system of claim 11 , wherein the set of rights with respect to the listing for the second member is based on the account type assigned to the second member.
13. The system of claim 8 , wherein the listing is a first listing of a plurality of listings of the data exchange and the database is a first database, and
wherein the processing device is further to:
generate, by a third member of the data exchange, a second listing comprising a reference to shared data within a second database controlled by the third member; and
limit access for the second member to a portion of the shared data of the second database that is less than all of the second database.
14. The system of claim 8 , wherein the listing is one of a plurality of listings in a catalog of the data exchange, and
wherein the processing device is further to control visibility of the second member to the listing in the catalog based on the set of rights of the second member.
15. A non-transitory computer-readable medium having instructions stored thereon which, when executed by a processing device, cause the processing device to:
generate, by a first member of a data exchange, a listing comprising a reference to shared data within a database controlled by the first member;
provide a second member of the data exchange with a set of rights with respect to the listing; and
limit, by the processing device, access for the second member to a portion of the shared data that is less than all of the database referenced by the listing based on the set of rights of the second member with respect to the listing.
16. The non-transitory computer-readable medium of claim 15 , wherein the access for the second member comprises running queries on the portion of the shared data referenced by the listing.
17. The non-transitory computer-readable medium of claim 15 , wherein providing the set of rights to the second member comprises assigning an account type to the second member.
18. The non-transitory computer-readable medium of claim 17 , wherein the set of rights with respect to the listing for the second member is based on the account type assigned to the second member.
19. The non-transitory computer-readable medium of claim 15 , wherein the listing is a first listing of a plurality of listings of the data exchange and the database is a first database, and
wherein the processing device is further to:
generate, by a third member of the data exchange, a second listing comprising a reference to shared data within a second database controlled by the third member; and
limit access for the second member to a portion of the shared data of the second database that is less than all of the second database.
20. The non-transitory computer-readable medium of claim 15 , wherein the listing is one of a plurality of listings in a catalog of the data exchange, and
wherein the processing device is further to control visibility of the second member to the listing in the catalog based on the set of rights of the second member.