'Connecting to a MySQL DB with SnowFlake in a Jupyter Notebook

New to all of this.

I have a MySQL database, set up with a connection to Snowflake which allows me to query all of the data I have inside the MySql workbench. The connections looks like this

I am now trying to query the data inside a jupyter notebook (hosted locally), and tried using this code to connect, which is telling me theres an issue, and from the error message I am assuming this is due to the hostname. Can anyone clarify this?


conn=pymysql.connect(host='jdbc:snowflake://xy12345.location.snowflakecomputing.com/',
                     port=int(3306), 
                     user='myname',
                     passwd='thepasswordiuse',
                     db='TRAINING_DB')

Solution 1:^[1]

The account name itself is missing in front of the location, see here: https://docs.snowflake.com/en/user-guide/admin-account-identifier.html

One example is xy12345.us-east-1.snowflakecomputing.com/ and the xy12345-part is missing in your example.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Marcel

'Connecting to a MySQL DB with SnowFlake in a Jupyter Notebook

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]