'Use ipython with Snowflake and external browser authenticator

I am able to establish a connection to snowflake from jupyter using the code snippet below. Code to establish the connection

After this, I want to run sql queries using %sql rather than pandas. To do so, I understand I need to run code on these lines.

%sql snowflake://[email protected]

This generates an error.

(snowflake.connector.errors.ProgrammingError) 251006: Password is empty
(Background on this error at: https://sqlalche.me/e/14/f405)
Connection info needed in SQLAlchemy format, example:
               postgresql://username:password@hostname/dbname
               or an existing connection: dict_keys(['sqlite://'])

After establishing the connection, what do I do so that I can run queries using %sql?



Sources

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

Source: Stack Overflow

Solution Source