Unable to connect to Snowflake from Microsoft Fabric Datapipeline

[NagaRK]

Hi Team,

 I was trying to pull the data from Snowflake to Fabric using Data pipeline copy activity. I am getting the error" Invalid Credentials". Could you please help me ? I have double checked the credenttials, its correct only  and also I hvave tried to organization account its same issues.  I have whitelisted region specific Ips of the Data factory in Snowflake, Snowflake allows IP4 addresses so whitelisted only those Ips. Could you pleas help me? PFA screenshot.

[NagaRK]

@v-sathmakuri sorry for late reply. The issue is with the IP whitelisting only.  We can find the IP that is getting blocked using the below sql command in Snowflake whenever we try to use Snowflake connector in Fabric . We have to just whitelist that IP in snowflake. Also all Fabric Ips needs to be whitelisted. 

 select *

from table(snowflake.information_schema.login_history())

where user_name = 'Your Snowflake user Name'

and is_success = 'NO';

[v-sathmakuri]

Hi @NagaRK ,

Thank you for sharing the solution here.

[v-sathmakuri]

Hi @NagaRK ,

Thank you for reaching out to Microsoft Fabric Community.

Open your SnowFlake account, click on admin, and you will find warehouses. Use the same warehouse name when creating the connection in Fabrics. 

Ensure there are no spaces in the connection name. Make sure you have access to the SnowFlake account and the database. I tried the connection, and it was successful for me. PFBS for reference.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you!!

[NagaRK]

@v-sathmakuri  Thank for your reply. It just worked for sometime without any whitelisting of IPs  and then I started getting same error again " Invalid Credentials" . This seems to be Fabric Major issue. I dont know what to do now. 

[smeetsh]

I have some question, which may help or maybe not.

1 can you create the connector of the type "snowflake" to snowflake seperately, in the connectors and gateways page? What happens if you try to save it there first?
In my snowflake connector I dont have the below section

This is what our connector looks like:

2 Make sure that the warehouse you are connecting to is specified correctly, snowflake is case sensitive if i recall correctly

3 Can you log in to the snowflake portal with the credentials provide, and run a simple select on a table in the warehouse you try to connect to?

When we set up our connector, we had to login to the snowflake portal, with the credentials provided, and when we did we got a message we needed to change our password...it looked like our provider basically forced us to change the password we were given by them, to make sure we would not sue the initial setup password.

4 contact the provider of the snowflake warehouse you try to connect to.

Hope this helps you a bit further

Cheers

Hans

[v-sathmakuri]

Hi@NagaRK ,

sorry for the delay in my response!!

Are you experiencing an intermittent issue, or were you unable to establish a connection at all?

Thank you!!

[NagaRK]

HI @v-sathmakuri 

I am experiencing this issue intermittent. Sometimes it works and sometime it does not work.

Thanks.

[v-sathmakuri · Accepted solution]

Hi @NagaRK ,

If the issue is intermittent, it could be due to dynamic IP addresses. In such cases, retrying the operation may work. Additionally, consider whitelisting a range of IP addresses to improve connection stability.

If you still face the same issue, Can you please raise a Microsoft support ticket for further investigation. You can create a Microsoft support ticket using the link below.

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.

Thank you!!