Managing access to usage data on a cloud-based data warehouse
Managing access to usage data on a cloud-based data warehouse including storing, by a table manager, usage data for a plurality of organizations in a table within a cloud-base data warehouse; receiving, by the table manager from a first client, a request for usage data for a first organization of the plurality of organizations, wherein the first client is associated with the first organization; and retrieving, by the table manager, the requested usage data for the first organization using a parameterized connection to the cloud-based data warehouse, wherein the parameterized connection provides access to the usage data for the first organization and blocks access to usage data for each other organization in the plurality of organizations.
1. A method for managing access to usage data on a cloud-based data warehouse, the method comprising:
storing, by a table manager, usage data for a plurality of organizations in a table within a cloud-base data warehouse, including:
monitoring activities for each user associated with each of the plurality of organizations; and
storing information about the monitored activities as usage data in the table within the cloud-based data warehouse;
receiving, by the table manager from a first client, a request for usage data for a first organization of the plurality of organizations, wherein the first client is associated with the first organization; and
retrieving, by the table manager, the requested usage data for the first organization using a parameterized connection to the cloud-based data warehouse, wherein the parameterized connection provides access to the usage data for the first organization and blocks access to usage data for each other organization in the plurality of organizations.
2. The method of claim 1 , wherein retrieving, by the table manager, the requested usage data for the first organization comprises generating a database statement targeting the table on the cloud-based data warehouse.
3. The method of claim 1 , wherein retrieving, by the table manager, the requested usage data for the first organization comprises generating the parameterized connection using an organization identifier for the first organization.
4. The method of claim 1 , wherein the request for usage data for the first organization comprises an instruction to manipulate the usage data for the first organization.
5. The method of claim 1 , wherein the parameterized connection filters out the usage data for each other organization in the plurality of organizations.
6. The method of claim 1 , wherein the usage data for a plurality of organizations comprises information about interactions between members of each organization and the table manager.
7. The method of claim 1 , wherein credentials used to access the cloud-based data warehouse using the parameterized connection authenticate the table manager.
8. The method of claim 1 , wherein the table manager is on an intermediary computing system between the cloud-based data warehouse and the computing system sending the request for usage data.
9. The method of claim 1 , wherein the first client does not have access to the cloud-based data warehouse.
10. The method of claim 1 , wherein the table is one of a plurality of tables storing usage data for the plurality of organizations.
11. An apparatus for managing access to usage data on a cloud-based data warehouse, 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:
storing, by a table manager, usage data for a plurality of organizations in a table within a cloud-base data warehouse, including:
monitoring activities for each user associated with each of the plurality of organizations; and
storing information about the monitored activities as usage data in the table within the cloud-based data warehouse;
receiving, by the table manager from a first client, a request for usage data for a first organization of the plurality of organizations, wherein the first client is associated with the first organization; and
retrieving, by the table manager, the requested usage data for the first organization using a parameterized connection to the cloud-based data warehouse, wherein the parameterized connection provides access to the usage data for the first organization and blocks access to usage data for each other organization in the plurality of organizations.
12. The apparatus of claim 11 , wherein retrieving, by the table manager, the requested usage data for the first organization comprises generating a database statement targeting the table on the cloud-based data warehouse.
13. The apparatus of claim 11 , wherein retrieving, by the table manager, the requested usage data for the first organization comprises generating the parameterized connection using an organization identifier for the first organization.
14. The apparatus of claim 11 , wherein the request for usage data for the first organization comprises an instruction to manipulate the usage data for the first organization.
15. The apparatus of claim 11 , wherein the parameterized connection filters out the usage data for each other organization in the plurality of organizations.
16. The apparatus of claim 11 , wherein the usage data for a plurality of organizations comprises information about interactions between members of each organization and the table manager.
17. The apparatus of claim 11 , wherein credentials used to access the cloud-based data warehouse using the parameterized connection authenticate the table manager.
18. The apparatus of claim 11 , wherein the table manager is on an intermediary computing system between the cloud-based data warehouse and the computing system sending the request for usage data.
19. The apparatus of claim 11 , wherein the first client does not have access to the cloud-based data warehouse.
20. A computer program product for managing access to usage data on a cloud-based data warehouse, the computer program product disposed upon a computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:
storing, by a table manager, usage data for a plurality of organizations in a table within a cloud-base data warehouse, including:
monitoring activities for each user associated with each of the plurality of organizations; and
storing information about the monitored activities as usage data in the table within the cloud-based data warehouse;
receiving, by the table manager from a first client, a request for usage data for a first organization of the plurality of organizations, wherein the first client is associated with the first organization; and
retrieving, by the table manager, the requested usage data for the first organization using a parameterized connection to the cloud-based data warehouse, wherein the parameterized connection provides access to the usage data for the first organization and blocks access to usage data for each other organization in the plurality of organizations.