Streamlit app in Snoflake

Streamlit and Snowflake
1

Hi there,

How to open the existing app in edit mode if the source database or schema got renamed in Snowflake.

Thanks

2

Hey, thanks for your question and welcome to the community! :blush: If your Streamlit app in Snowflake is no longer editable after renaming the source database or schema, it could be possible that the app has lost its link to the original GitHub coordinates or entrypoint, which is how Streamlit Community Cloud identifies and manages apps. When you rename a database, schema, or move the entrypoint file, you typically need to delete the app and redeploy it with the new coordinates to regain full edit access. If you’ve already made changes and now only have view-only access, reverting the change (renaming back to the original) may restore edit access, after which you can delete and redeploy the app with the new settings.

For Snowflake-native Streamlit apps, if you want to change the main file or entrypoint (for example, after moving files or renaming), you can use the ALTER STREAMLIT SQL command to set the new main file. This allows you to point the app to the correct file without needing to recreate the app. However, if the app is missing or stuck in view-only mode due to coordinate changes, you may need to revert the changes, regain access, delete the app, and redeploy it as described above. More details are available in the official docs and community discussions, which outline these steps and recovery options if you lose admin access after renaming or moving resources.

Sources: