Hi,
My app is reading data from a BigQuery database. The SQL script is in a separate .sql
file and is being read from the .py
file. It works fine when I run the app locally, but I am getting a file not found error after deploying the app on Streamlit Cloud. Here is the error message -
Traceback (most recent call last):
File "/home/appuser/venv/lib/python3.10/site-packages/streamlit/scriptrunner/script_runner.py", line 557, in _run_script
exec(code, module.__dict__)
File "bq-streamlit-poc/pages/2_Global.py", line 34, in <module>
sql_tw_global = open("pages/tw-global.sql", "r")
FileNotFoundError: [Errno 2] No such file or directory: 'pages/tw-global.sql'
Both the .py
and .sql
files are in the pages
folder.
Any help would be appreciated. Thanks.