Taylor Paddock on 30 Jan 2019 00:14:56
Currently, the Snowflake user's default role is used for the connection. Need the ability to specify a Snowflake role if a user is assigned to more than one role. Role is already an optional parameter in the ODBC connector that is required to be installed. Using the ODBC connector instead will not work as DirectQuery is needed from the Snowflake Connector.
- Comments (17)
RE: Add support for Role in Snowflake Connector
This is basic connection parameter which should be made available. Without role selection the Snowflake Security cannot be utilized through Power BI. In real scenario, a user will have multiple roles based on profile/project and this idea should be considered as Snowflake Connector is GA.
RE: Add support for Role in Snowflake Connector
This is something that we need for any user that has more than one role assigned. in my business case i have a standard user in snowflake with several roles applied to it, this user's sole purpose is to read data into a power bi dataset/report therefore we need the flexibility to configure which role to apply depending on the data to visualize.
RE: Add support for Role in Snowflake Connector
This is a basic feature and required for users with multiple roles
RE: Add support for Role in Snowflake Connector
As an enterprise, we use Azure SCIM to provision users and roles in Snowflake based on Active Directory users and groups.
Azure SCIM does not assign a default role to users in Snowflake.
Therefore, new users in Snowflake cannot use direct query in PowerBI until an administrator manually assigns a default role because they get an error on login.
Also, because security within Snowflake is based on the currently used Snowflake role, and PowerBI relies on the users default role (not a role specified at design-time), there is no guarantee that results will be consistent or a query can even execute successfully.
This is because a users default role may not allow access to the tables/views required - as a user's roles in Snowflake are not cumulative as per SQL Server - only a single role can be used at a point in time.
RE: Add support for Role in Snowflake Connector
This is basic feature for working with Snowflake
RE: Add support for Role in Snowflake Connector
this driver is kinda useless without this feature
RE: Add support for Role in Snowflake Connector
It is crucial to have this ability to properly utilize all the power of Snowflake in Power BI
RE: Add support for Role in Snowflake Connector
I think this is very important feature needed for handling different subject areas in a company..Workaround to do this also helps..
RE: Add support for Role in Snowflake Connector
How is this not implemented right from the beginning? This is literally core functionality!
RE: Add support for Role in Snowflake Connector
Come on guys, this is a core requirement for recommended ways of working with Snowflake. It really seems like the Snowflake connector was coded up in a couple of days to fill in a checkbox on some manager's feature list, then thrown out to customers as a ****** MVP and abandonded.