Ok, So I found a lot of information scanning these boards, but nothing that seems to directly apply to the issue I am running into. That could be due to my inexperience with the combination of tools in play. So thank you in advance for your patience!
I have build a streamlit application that connects to snowflake using snowpark. This is what my connection method looks like:
def create_session(username):
connection_parameters = {
"user":username,
"account": "<account_name>",
"role": "<role_name>",
"warehouse":"<warehouse_name>",
"database": "<database_name>",
"schema": "<schema_name>",
"authenticator": "EXTERNALBROWSER"
}
return Session.builder.configs(connection_parameters).create()
Our company uses Okta, but I am not able to use that method in the “authenticator” method because we have MFA enabled (per the Snowflake docs).
The connection method I used works fine when the application is run locally, but when hosted on our Linux/nginx server, it does not work (as expected from the Snowflake docs).
If I put in a static username/password into the connection, it works fine. However most people don’t know their Snowflake pw because we use Okta. So this method is not ideal either.
I’m looking for suggestions to help me get over this issue.
Thank you in advance!