This page only contains the `st.connections.SnowflakeConnection` class. For a deeper dive into creating and managing data connections within Streamlit apps, read [Connecting to data](/develop/concepts/connections/connecting-to-data).

Configuration

{/** Internal note: This section is deep-linked from the library in 1.28.1 via /st.connections.snowflakeconnection-configuration through a redirect. Maintain the redirect if moved or modified. **/}

st.connection("snowflake") can be configured using Streamlit secrets or keyword args just like any other connection. It can also use existing Snowflake connection configuration when available.

Note that snowflake-snowpark-python must be installed to use this connection.

Using Streamlit secrets

For example, if your Snowflake account supports SSO, you can set up a quick local connection for development using browser-based SSO and secrets.toml as follows:

# .streamlit/secrets.toml

[connections.snowflake]
account = "<ACCOUNT ID>"
user = "<USERNAME>"
authenticator = "EXTERNALBROWSER"

Learn more about account indentifier here. You could also specify the full configuration and credentials in your secrets file, as in the example here.

Using existing Snowflake configuration

Snowflake’s python driver also supports a connection configuration file, which is well integrated with Streamlit SnowflakeConnection. If you already have one or more connections configured, all you need to do is pass Streamlit the name of the connection to use. This can be done in several ways:

  • Set connection_name in your app code, such as st.connnection("<name>", type="snowflake").
  • Set connection_name = "<name>" in the [connections.snowflake] section of your Streamlit secrets.
  • Set the environment variable SNOWFLAKE_DEFAULT_CONNECTION_NAME=<name>.
  • Set a default connection in your Snowflake configuration.

When available in Streamlit in Snowflake, st.connection("snowflake") will connect automatically using the app owner role and does not require any configuration.

Learn more about setting up connections in the Connecting Streamlit to Snowflake tutorial and Connecting to data.