File not found error for SQL script file on Streamlit Cloud - Working fine in my local environment

☁️ Streamlit Community Cloud
1

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.

2

I found the solution. We need to set the path using __file__. It should be like this -

os.path.join(os.path.dirname(__file__), "file_name")