使用snowflake.connector.connect创建到数据库的PEP-249连接-请参阅文档。然后使用create_engine（docs）的参数creator-它接受返回PEP-249连接的可调用对象。如果使用它，则URL参数将被忽略。
示例代码：

def get_connection():
    return snowflake.connector.connect(
        user="<username>",
        host="<hostname>",
        account="<account_identifier>",
        authenticator="oauth",
        token="<oauth_access_token>",
        warehouse="test_warehouse",
        database="test_db",
        schema="test_schema"
    )
engine = create_engine("snowflake://not@used/db", creator=get_connection)

我得到了这个工作，但只是在连接URL中添加更多的参数：

from sqlalchemy.engine import create_engine
import urllib.parse

connection_url = f"snowflake://{user}:@{account}/{database}/{schema}?warehouse={warehouse}&authenticator=oauth&token={urllib.parse.quote(access_token)}"
engine = create_engine(connection_url)

with engine.begin() as connection:
    print(connection.execute('select count(*) from lineitem').fetchone())

如果您不想自己构造URL，可以使用snowflake.sqlalchemy.URL，如下所示：

from snowflake.sqlalchemy import URL
connection_url = URL(
    user=user,
    authenticator="oauth",
    token=access_token,
    host=host,
    account=account,
    warehouse=warehouse,
    database=database,
    schema=schema
)