SNOW-2057533: Support for connections.toml

[larsrinn]

What is the current behavior?

I find the process of connecting to Snowflake using key-base-authentication quite painful. The core Snowflake connector for Python however makes it quite easy by defining everything in the connections.toml. I don't find a possibility to use this via snowflake-sqlalchemy, even though it seems to be using the other connector under the hood.

What is the desired behavior?

It should be possible to create a sqlalchemy engine by just specifying a profile from connections.toml

How would this improve snowflake-connector-python?

It would be much easier/DRYer to use. Especially when it's used from many different scripts, notebooks, etc.

References, Other Background

[sfc-gh-dszmolka]

hi, thank you for submitting this improvement request. This is not planned to be done for the foreseeable future. We'll hopefully be able to post a more comprehensive update on the state of this project; in the README or some more visible place.

[afeld]

My hacky workaround:

from snowflake.sqlalchemy.snowdialect import SnowflakeDialect
from snowflake.sqlalchemy import URL
from sqlalchemy import create_engine


def create_connect_args(self, url):
    # pass the `connection_name` (only) to the Snowflake Python connector
    # https://docs.snowflake.com/en/developer-guide/python-connector/python-connector-connect#connecting-using-the-connections-toml-file
    opts = {"connection_name": "NAME"}
    return ([], opts)

# monkey-patch
SnowflakeDialect.create_connect_args = create_connect_args

# `account` is required but ignored
url = URL(drivername="snowflake", account="")
engine = create_engine(url)