Add support for Role in Snowflake Connector
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.
Snowflake security administrators can assign only one default role to a user account. Per vendor recommendations, members of built-in roles (e.g. SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN) are encouraged to assign a low-privilege default role. Those users must elevate their security token to perform DBA like tasks and will generally have insufficient permissions to read from user-defined content hosted in the Snowflake account. With interactive sessions and other BI tools, those user accounts can issue statements like "USE ROLE mydatabase_db_reader" to change security contexts for BI client purposes. The inability to alter the default role limits some users from being able to access all of the database tables and views that would otherwise be available using other BI tools that support the USE ROLE semantics.