LlamaIndex: ObjectNotExecutableError

[Oleksandr_Arsentiev]

Hi All. I’m facing a problem when deploying an app that uses LlamaIndex’s Database Reader. The app fetches data from Snowflake tables and work perfectly on local machine. However. during deployment to the community cloud it throws’ an error:

sqlalchemy.exc.ObjectNotExecutableError: Not an executable object: ‘SHOW /* sqlalchemy:get_table_names */ TABLES’

The app has the following requirements:

pandas
streamlit
openai
llama-index
sqlalchemy
snowflake-sqlalchemy

What I tried already:
Used different versions of Python while deploying
Used different versions of llama-index, sqlalchemy and snowflake-sqlalchemy libraries.

Does anyone here had similar issue?

[Navin_Chandra]

Did you configure the streamlit’s cloud secrets while deploying?

[Oleksandr_Arsentiev]

I did, it seems like the issue is related to specific versions of snowflake-connector-python or snowflake-sqlalchemy. However, I wasn’t able to fix it yet

[mliu]

Hi @Oleksandr_Arsentiev it is probably the dependency issue. Could you refer this conda channel and ping the snowflake-connector-python==3.1.0 and sqlalchemy==1.4.39

[Oleksandr_Arsentiev]

thank you, it seems like the dependency issue is caused by llama-index. Strangely enough, it works on my local machine. Should snowflake-snowpark-python be added to the requirements? This is what I got from the Streamlit console:

llama-index 0.8.29 depends on sqlalchemy>=2.0.15
snowflake-sqlalchemy 1.5.0 depends on sqlalchemy<2.0.0 and >=1.4.0

[mliu]

@Oleksandr_Arsentiev i see it looks like there is known issue in sqlalchemy support for snowflake-sqlalchemy . There is a patch i found in the thread and hope this helps with the issue

SNOW-739749: snowflake-sqlalchemy 1.4.4 requires sqlalchemy<2.0.0,>=1.4.0, but you have sqlalchemy 2.0.1 which is incompatible.

[Oleksandr_Arsentiev]

thanks! In the time being I just forked llama-index repo and changed the requirements to support sqlalchemy <2.0.0,>=1.4.0. Works fine for the hackathon