Blog Post

Azure Data Factory Blog
1 MIN READ

ADF now supports data integration with Snowflake

Linda_Wang's avatar
Linda_Wang
Icon for Microsoft rankMicrosoft
Jun 08, 2020
Azure Data Factory provides 90+ built-in connectors allowing you to easily integrate with various data stores regardless of variety of volume, whether they are on premises or in the cloud.   We a...
Updated Aug 31, 2020
Version 4.0
azure data factory
Azure Data Integration
oleksandrkravchuk's avatar
oleksandrkravchuk
Copper Contributor
Jul 09, 2020

Hello, Linda_Wang.

Thanks for responding to questions on this topic. It really helps us understand all the possibilities and limitations of this connector.

I wanted to clarify if the "ROLE" connection parameter is supported. I can see that there is no such field in the linked service view, but it can be added through "Additional connection properties".

Anyway, even having a specified role in properties or directly in a connection string - I was not able to query Snowflake due to this error:

ERROR [57P03] No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.

Despite that warehouse is specified for the linked service.

'use warehouse' in a query text does not work also.

Is there any way to work around this issue?