Error on my deployment in streamlit

[euphyfzhang]

Hi,

I tested the snowpark connection and it worked ( I looked up the query_history in Snowsight, it shows the query I queried in the python code). But the app keeps saying Oh No.

Can anyone please help?

Thanks,

[Navin_Chandra]

Does it works locally? Did you configure the secrets while deploying the app on streamlit cloud?

[Ridaone]

The “Oh No” message in your application suggests an issue in your code or logic. Start by checking application logs for error messages. Review your Snowpark code for proper error handling and ensure query accuracy. Check network and firewall settings for potential disruptions, and confirm compatibility with your deployment environment.

[euphyfzhang]

My code doesn’t have problem because I tested them line by line.

The connection with snowpark worked because I checked that the query I ran via snowpark showed up in the Query History with Success status.

But the streamlit is not showing anything.

[Navin_Chandra]

Can you share your repo so we can have a look at the code? Also try redeploying the app because it seems like a deploying issue else the home page will render some text first (if you have some st.write statements).

[euphyfzhang]

I just checked again.

The streamlit showed me the following error. How can I resolve that ?

[10:29:01] Processed dependencies!
Collecting usage statistics. To deactivate, set browser.gatherUsageStats to False.
`
/home/adminuser/venv/lib/python3.9/site-packages/snowflake/connector/options.py:103: UserWarning: You have an incompatible version of ‘pyarrow’ installed (13.0.0), please install a version that adheres to: ‘pyarrow<10.1.0,>=10.0.1; extra == “pandas”’

warn_incompatible_dep(

Yea, here is my repo. The code after line 21 is the part that is not working

euphyfzhang/my_streamlit_llm_app/blob/master/streamlit_app.py

Please check! Thanks!

[Navin_Chandra]

Seems like a pip dependency error for pyarrow, can you add this in requirements.txt:
pyarrow==10.0.1

You can install locally using:
pip install pyarrow==10.0.1

[euphyfzhang]

Thanks very much for your help Navin. My app is working now!!!