Hi, Do you know if “Snowflake SQLAlchemy” connector supports connection parameter to integrate with Okta for authentication? Below are the connection parameters I have seen so far and I haven't found parameter to specify the authenticator ( *https://github.com/snowflakedb/snowflake-sqlalchemy* <https://github.com/snowflakedb/snowflake-sqlalchemy>):
'snowflake://<user_login_name>:<password>@<account_name>/<database_name>/<schema_name>?warehouse=<warehouse_name>?role=<role_name>' In Snowflake connector for python (base implementation on sqlalchemy dialect), we can authenticate with Okta using the authenticator parameter as shown below: #!/usr/bin/env python import snowflake.connector # Gets the version ctx = snowflake.connector.connect( user='xxx' <user='i58513@'>, password='xxx', account='xxx', *authenticator='https://xxx.okta.com'* ) cs = ctx.cursor() try: cs.execute("SELECT current_version()") one_row = cs.fetchone() print(one_row[0]) finally: cs.close() ctx.close() -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.