App is in running mode but does not complete

Using Streamlit
1

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!

2

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

3

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.

4

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
5

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