As the BI or data warehouse administrator, you’d typically have two choices in this situation:
Create accounts on the cloud data warehouse for every individual user OR use a single “shared service” account that connects to the cloud data warehouse through one account and pulls data for thousands of BI users. This approach leaves too many holes from a security standpoint. Because of these gaps and risks, companies often leave sensitive data out of their analytics workflows.
