Okta authenticated credentials with sqlalchemy

[harshi...@gmail.com]

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):

'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',
    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()

[Jonathan Vanasco]

you should ask snowflake/ snowflake-sqlalchemy developers. snowflake is a commercial product and they maintain their own sqlalchemy product.  the chance of somewhere here being able to answer this question is very low, and you're already paying snowflake for support.

      https://github.com/snowflakedb/snowflake-sqlalchemy

note the message at the bottom:

      Support
      Feel free to file an issue or submit a PR here for general cases. For official support, contact Snowflake support at:https://support.snowflake.net/s/snowflake-support