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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
