Can an app use multiple snowflake databases/schemas?

Per Connect Streamlit to Snowflake - Streamlit Docs, it seems that an application can only use one snowflake database and schema specified in secrets.toml. Is this true? Thanks for any help!

Hi @jiangok-open,

Secrets are really just environment variables, so you can connect to as many Snowflake accounts as you like – you would just have to initiate a new connection which references the relevant environment variables if you want to switch accounts. If you’re looking to access multiple databases in the same account, you can definitely do that as well. Feel free to share the code that you’ve already written and we can push you in the right direction.

Best,

Caroline

1 Like