Known issue - Pipelines don't support Role property for Snowflake connector
Pipelines don't support Role property for Snowflake connector.
Status: Open
Product Experience: Data Factory
Symptoms
When trying to test the Snowflake connection, you receive an error message similar to: Test connection operation failed. Failed to open the database connection. [Snowflake] 390201 (08004): The requested warehouse does not exist or not authorized
Solutions and workarounds
As a solution, you need to allocate the role to the specific warehouse for the connector to use by default.