Unable to connect Snowflake on Fabric Notebook

[Sean500]

Hi

I am trying to connect Snowflake using Python snowflake connector with Fabric Notebook. However, I am getting the below error

OperationalError: 250001: Could not connect to Snowflake backend after 2 attempt(s).Aborting

My Code as follow,

# Installing the snowflake connector
!pip install snowflake-connector-python

import snowflake.connector
import requests
import json


# Replace the placeholders with your Snowflake credentials and connection details
account = 'go64215.australia-east.azure'
user = 'XXXXXX'
password = 'XXXXXX'
database = 'TEST'
schema = 'DBO'
warehouse = 'COMPUTE_WH'
role = 'ACCOUNTADMIN'

conn = snowflake.connector.connect(
    user=user,
    password=password,
    account=account,
    warehouse=warehouse,
    database=database,
    schema=schema,
    role=role
)

The same code is working with Google Colab as well as in my local machine. Howevr, I am not able to connect with notebook. All my credentials are correct.

Also I used the same crednetials, I am able to connect Snowflake using Pipeline and it works well.

Can anyone advise what would be an issue?

Regards,

Dhilip

[Sean500]

@Anonymous Thanks.. I just come across this Linkedin post where he connects the Snowflake with spark connector. Unforutnately I am not able to replicate.  

https://www.linkedin.com/pulse/snowflake-onelake-arvind-periyasamy/

[Anonymous]

Hi @Sean500 
Apologies for the issue you have been facing.

I would suggest you to create a support ticket. This is the most direct way to get official assistance and specific insights into your situation. The support team can access detailed logs and metrics to pinpoint the issue and suggest solutions.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support
Please provide the ticket number here as we can keep an eye on it.

Hope this is helpful. Please let me know incase of further queries.

[Anonymous]

Hi @Sean500 
We haven’t heard from you on the last response and was just checking back to see if you got a chance to create a support ticket. If yes please provide the details here.
Otherwise, will respond back with the more details and we will try to help.
Thanks

[Anonymous]

Hi @Sean500 
Thanks for using Fabric Community.
Currently Snowflake connector is only available in Fabric Pipelines and Dataflow Gen2. Hence you are getting the error.
For more information please refer this link: https://learn.microsoft.com/en-us/fabric/data-factory/connector-snowflake-overview

Hope this helps. Please let me know if you have any further questions. 

[Sean500]

Thanks @Anonymous  for the info. 

[Anonymous]

Hi @Sean500 
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.