I am running streamlit in snowflake. When I create a new streamlit app, I do not see the stage associated with it in the schema where the app is living.
I’d like to be able to find the stage so that I can upload some images that I want the app to have access to.
Some googling tells me to use the SHOW STREAMLITS or DESCRIBE STREAMLIT commands to grab a property called ROOT_LOCATION but I am not seeing that come back from either of those.
Thank you!
Hello William,
Could you let me know which role you used to create the Streamlit app? I suspect it might be a privilege issue. Otherwise, the following command should work:
SHOW STREAMLITS IN APP_DB.PUBLIC;
fyi: APP_DB is my Database and PUBLIC is my Schema where I created all SIS apps.
Hi Prakash,
I created the streamlit app with the owner role of the database that it is in, and I am running the commands with that same role. Now, I do see results from the SHOW STREAMLITS and DESCRIBE STREAMLIT but I do not see the ROOT_LOCATION as a column nor do I see anything that looks like a stage name in any other column.
Got it. I think you are checking from worksheet, right?
Please try accessing it from outside the worksheet.
This was the first thing I tried, but I don’t see “Stages” at all in the schema where I created my app. I only see “Tables”. I know it must exist somewhere though because the app itself has to be stored somewhere.
It looks like the behavior has changed. Previously, we could see the sis app stages, but that’s no longer the case. In your situation, you can create a custom stage, upload all your images there, and then reference them from your SIS app.
@William_Garrard , I believe you can upload files directly from the editor itself. Please see the image below for reference.
Yep, that works. Thank you for your help! I wonder why the stages were changed to be hidden?