App is in running mode but does not complete

Hello,

I have a database web app that I have deployed where I can click to run predefined SQL queries on BigQuery but it gets stuck on Running. It works fine locally and the only warning I gto from the log was my pip package needed to be updated.

Would appreciate some feedback as to what I may be missing.
https://share.streamlit.io/mmoralls/web_app/main/main-app.py

Thanks all!

Hi @Mark_Moralls -

For this BigQuery instance, is it one you set up, a work one, something else? My first thought here would be that BigQuery isnโ€™t letting in traffic from the Streamlit Cloud infrastructure.

Best,
Randy

Hi Randy!

Thanks for responding. It is set up by myself. I didnโ€™t think about that (obvious) part. My requirements file probably needs to be tweaked by adding a specific role or similar, so will have to look into this.

Think I found the problem. I was using local environment configuration in my scripts so thatโ€™s not going to in a cloud environment.

1 Like

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.