Trying to use Azure Synapse Linked Service to Pull Data from Snowflake

Question

Trying to use Azure Synapse Linked Service to Pull Data from Snowflake

Darin Spence 1

Looks like I can successfully connect to Snowflake, but I don't get any tables back. If I create an ODBC connection on a local computer, everything works fine. Any ideas on how to adjust Azure Synapse's Linked Connection to pull data from Snowflake?

2 answers

Your answer

Answer 1

Vinodh247 40,056 MVP Volunteer Moderator

Hi

Thanks for reaching out to Microsoft Q&A.

Have you followed this when setting up? you cannot adjust a linked service, better to drop and create a new one and then test.

https://learn.microsoft.com/en-us/azure/data-factory/connector-snowflake?tabs=data-factory

Please Upvote and Accept as answer if the reply was helpful, this will be helpful to other community members.

Darin Spence 1 Reputation point

2022-11-26T22:22:49.737+00:00

Good idea. I created a Linked Service to Snowflake, the connection tests passed, but I was still not able to see any tables.
PRADEEPCHEEKATLA 91,576 Reputation points Moderator

2022-11-29T07:57:52.91+00:00

Hello @Darin Spence ,

Could you please click on the Failed More and share the error message here?
PRADEEPCHEEKATLA 91,576 Reputation points Moderator

2022-12-05T05:15:43+00:00

Hello @Darin Spence ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond with more details and we will try to help.
Darin Spence 1 Reputation point

2022-12-05T05:18:29.157+00:00

Sadly there has been no resolution. The Power BI Service Snowflake Connector appears to not be working.
PRADEEPCHEEKATLA 91,576 Reputation points Moderator

2022-12-07T05:55:59.29+00:00

Hello @Darin Spence ,

Thanks for the confirmation, kindly share the complete stack trace of the error message which you are experiencing?

Answer 2

Darin Spence 1

Microsoft is looking into it.

Share via

Trying to use Azure Synapse Linked Service to Pull Data from Snowflake

2 answers

Your answer