thomasaarholt opened a new issue, #918: URL: https://github.com/apache/arrow-adbc/issues/918
Hello! Thank you very much for adding Snowflake support to arrow-adbc! I'm running arrow-adbc in Python 3.11 on macOS. I've got the connection working as follows, but I have to accept multi-factor-authentication (MFA) each time I make a request (even within the same python session), despite the [documentation stating that `cache_mfa_token` is true on MacOS](https://arrow.apache.org/adbc/0.5.0/driver/snowflake.html#client-options) (search for `adbc.snowflake.sql.client_option.cache_mfa_token`): ```python from adbc_driver_snowflake import dbapi user = password = account = database = schema = warehouse = role = "..." uri = f"{user}:{password}@{account}/{database}/{schema}?warehouse={warehouse}&role={role}" query = "select * from my_table limit 10" with dbapi.connect(uri=uri) as conn: cursor = conn.cursor() cursor.execute(query) tbl = cursor.fetch_arrow_table() cursor.close() print(tbl) ``` I've also tried passing `db_kwargs={"cache_mfa_token":"true"}` to `connect`, without success. Does anyone have any ideas? I would quite like to replace usage of snowflake-connector-python with adbc, but it's a major hassle to accept MFA on each request. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
