Syncing data warehouse permissions using single sign-on authentication
Syncing data warehouse permissions using single sign-on authentication including 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 syncing data warehouse permissions using single sign-on (SSO) authentication, the method comprising:
determining a data warehouse user account of a cloud-based data warehouse corresponding to a data analytics user account of a data analytics service, wherein the data analytics user account has one or more permissions in the data analytics service, and wherein the data warehouse user account and the data analytics user account are authenticated to correspond to a same user using a single sign-on (SSO) authentication credential from an SSO authentication provider;
determining one or more permissions in the cloud-based data warehouse for the data warehouse user account; and
updating the one or more permissions in the data analytics user account to match the one or more permissions in the cloud-based data warehouse for the data warehouse user account in response to determining a permission in the cloud-based data warehouse for the data warehouse user account is more restrictive than a permission in the data analytics user account.
2. The method of claim 1 , wherein determining the one or more permissions comprises:
requesting, from the cloud-based data warehouse, database metadata; and
determining, based on the database metadata, the one or more permissions.
3. The method of claim 1 , wherein determining the one or more permissions and applying the one or more permissions are performed at a predefined interval.
4. The method of claim 1 , further comprising accessing the cloud-based data warehouse using the data warehouse user account.
5. The method of claim 1 , wherein determining the data warehouse user account comprises receiving a notification indicating a creation of the data warehouse user account.
6. The method of claim 5 , further comprising creating the data analytics user account in response to the notification.
7. The method of claim 1 , wherein the one or more permissions comprise one or more role-level permissions associated with a role of the data warehouse user account.
8. An apparatus for syncing data warehouse permissions using single sign-on (SSO) authentication, 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 steps of:
determining a data warehouse user account of a cloud-based data warehouse corresponding to a data analytics user account of a data analytics service, wherein the data analytics user account has one or more permissions in the data analytics service, and wherein the data warehouse user account and the data analytics user account are authenticated to correspond to a same user using a single sign-on (SSO) authentication credential from an SSO authentication provider;
determining one or more permissions in the cloud-based data warehouse for the data warehouse user account; and
updating the one or more permissions in the data analytics user account to match the one or more permissions in the cloud-based data warehouse for the data warehouse user account in response to determining a permission in the cloud-based data warehouse for the data warehouse user account is more restrictive than a permission in the data analytics user account.
9. The apparatus of claim 8 , wherein determining the one or more permissions comprises:
requesting, from the cloud-based data warehouse, database metadata; and
determining, based on the database metadata, the one or more permissions.
10. The apparatus of claim 8 , wherein determining the one or more permissions and applying the one or more permissions are performed at a predefined interval.
11. The apparatus of claim 8 , wherein the steps further comprise accessing the cloud-based data warehouse using the data warehouse user account.
12. The apparatus of claim 8 , wherein determining the data warehouse user account comprises receiving a notification indicating a creation of the data warehouse user account.
13. The apparatus of claim 12 , wherein the steps further comprise creating the data analytics user account in response to the notification.
14. The apparatus of claim 8 , wherein the one or more permissions comprise one or more role-level permissions associated with a role of the data warehouse user account.
15. A computer program product for syncing data warehouse permissions using single sign-on (SSO) authentication, the computer program product disposed upon a computer readable storage medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out steps of:
determining a data warehouse user account of a cloud-based data warehouse corresponding to a data analytics user account of a data analytics service, wherein the data analytics user account has one or more permissions in the data analytics service, and wherein the data warehouse user account and the data analytics user account are authenticated to correspond to a same user using a single sign-on (SSO) authentication credential from an SSO authentication provider;
determining one or more permissions in the cloud-based data warehouse for the data warehouse user account; and
updating the one or more permissions in the data analytics user account to match the one or more permissions in the cloud-based data warehouse for the data warehouse user account in response to determining a permission in the cloud-based data warehouse for the data warehouse user account is more restrictive than a permission in the data analytics user account.
16. The computer program product of claim 15 , wherein determining the one or more permissions comprises:
requesting, from the cloud-based data warehouse, database metadata; and
determining, based on the database metadata, the one or more permissions.
17. The computer program product of claim 15 , wherein determining the one or more permissions and applying the one or more permissions are performed at a predefined interval.
18. The computer program product of claim 15 , wherein the steps further comprise accessing the cloud-based data warehouse using the data warehouse user account.
19. The computer program product of claim 15 , wherein determining the data warehouse user account comprises receiving a notification indicating a creation of the data warehouse user account.
20. The computer program product of claim 19 , wherein the steps further comprise creating the data analytics user account in response to the notification.