connecting-streamlit-to-snowflake

To connect Streamlit to Snowflake, use the st.connection API with credentials stored in .streamlit/secrets.toml. This approach securely manages secrets and supports both single and multiple Snowflake connections within your app.

st.secrets securely stores Snowflake credentials in a local secrets.toml file. The st.connection API reads these credentials to establish secure, auditable database connections without hardcoding sensitive information in your application code.

Yes, you need Streamlit 1.53 or later to connect Streamlit to Snowflake using st.connection. This version is required to support caller's rights, which allows controlled access and separate connections for different environments.

Yes, you can execute safe parameterized queries and write data to Snowflake directly from Streamlit. Using st.connection ensures these operations are secure, preventing SQL injection and maintaining credential safety.

The best way to manage multiple Snowflake connections in Streamlit is using the st.connection API. It supports separate connections for different environments, enabling controlled access and robust, auditable integrations across your dashboards.

Caller's rights in Streamlit Snowflake connections ensure controlled access by executing queries with the caller's permissions. This creates auditable integrations, prevents unauthorized data access, and supports separate environments securely.