Sharing data across cloud-based data warehouses
Sharing data across cloud-based data warehouses establishing a link between a first cloud-based data warehouse and a second cloud-based data warehouse, wherein the link facilitates access to data stored in the second cloud-based data warehouse via the first cloud-based data warehouse; receiving, by the first cloud-based data warehouse, a first query referencing first data stored in the second cloud-based data warehouse; accessing, by the first cloud-based data warehouse, from the second cloud-based data warehouse, the first data; and sending a response to the first query based on the accessed first data.
1. A method of sharing data across cloud-based data warehouses, the method comprising:
establishing a link between a first cloud-based data warehouse and a second cloud-based data warehouse, wherein the link facilitates access to data stored in the second cloud-based data warehouse via the first cloud-based data warehouse;
receiving, by the first cloud-based data warehouse, a first query referencing first data stored in the second cloud-based data warehouse;
accessing, by the first cloud-based data warehouse, from the second cloud-based data warehouse, the first data; and
sending a response to the first query based on the accessed first data.
2. The method of claim 1 , wherein establishing the link further comprises:
sending, to the second cloud-based data warehouse, a request to establish the link; and
establishing, based on a response to the request, the link.
3. The method of claim 1 , wherein accessing the first data comprises:
generating, based on the first query, a second query for the first data; and
querying the second cloud-based data warehouse using the second query.
4. The method of claim 1 , wherein the data stored in the second cloud-based data warehouse is accessible to a plurality of cloud-based data warehouses via a plurality of links.
5. The method of claim 1 , wherein establishing the link comprises including, in a schema of the first cloud-based data warehouse, at least a portion of a schema of the second cloud-based data warehouse.
6. The method of claim 5 , wherein the at least a portion of the schema of the second cloud-based data warehouse comprises one or more of a table schema or a view schema.
7. The method of claim 1 , further comprising:
accessing second data from the first cloud-based data warehouse; and
wherein sending the response to the first query based on the accessed first data comprises sending the response to the first query based on the accessed first data and the accessed second data.
8. An apparatus for sharing data across cloud-based data warehouses, the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of:
establishing a link between a first cloud-based data warehouse and a second cloud-based data warehouse, wherein the link facilitates access to data stored in the second cloud-based data warehouse via the first cloud-based data warehouse;
receiving, by the first cloud-based data warehouse, a first query referencing first data stored in the second cloud-based data warehouse;
accessing, by the first cloud-based data warehouse, from the second cloud-based data warehouse, the first data; and
sending a response to the first query based on the accessed first data.
9. The apparatus of claim 8 , wherein establishing the link further comprises:
sending, to the second cloud-based data warehouse, a request to establish the link; and
establishing, based on a response to the request, the link.
10. The apparatus of claim 8 , wherein accessing the first data comprises:
generating, based on the first query, a second query for the first data; and
querying the second cloud-based data warehouse using the second query.
11. The apparatus of claim 8 , wherein the data stored in the second cloud-based data warehouse is accessible to a plurality of cloud-based data warehouses via a plurality of links.
12. The apparatus of claim 8 , wherein establishing the link comprises including, in a schema of the first cloud-based data warehouse, at least a portion of a schema of the second cloud-based data warehouse.
13. The apparatus of claim 12 , wherein the at least a portion of the schema of the second cloud-based data warehouse comprises one or more of a table schema or a view schema.
14. The apparatus of claim 8 , wherein the steps further comprise:
accessing second data from the first cloud-based data warehouse; and
wherein sending the response to the first query based on the accessed first data comprises sending the response to the first query based on the accessed first data and the accessed second data.
15. A computer program product for sharing data across cloud-based data warehouses, the computer program product comprising a non-transitory computer readable storage medium having computer program instructions stored therein that, when executed, cause a computer to carry out the steps of:
establishing a link between a first cloud-based data warehouse and a second cloud-based data warehouse, wherein the link facilitates access to data stored in the second cloud-based data warehouse via the first cloud-based data warehouse;
receiving, by the first cloud-based data warehouse, a first query referencing first data stored in the second cloud-based data warehouse;
accessing, by the first cloud-based data warehouse, from the second cloud-based data warehouse, the first data; and
sending a response to the first query based on the accessed first data.
16. The computer program product of claim 15 , wherein establishing the link further comprises:
sending, to the second cloud-based data warehouse, a request to establish the link; and
establishing, based on a response to the request, the link.
17. The computer program product of claim 15 , wherein accessing the first data comprises:
generating, based on the first query, a second query for the first data; and
querying the second cloud-based data warehouse using the second query.
18. The computer program product of claim 15 , wherein the data stored in the second cloud-based data warehouse is accessible to a plurality of cloud-based data warehouses via a plurality of links.
19. The computer program product of claim 15 , wherein establishing the link comprises including, in a schema of the first cloud-based data warehouse, at least a portion of a schema of the second cloud-based data warehouse.
20. The computer program product of claim 19 , wherein the at least a portion of the schema of the second cloud-based data warehouse comprises one or more of a table schema or a view schema.