Hello,
I connected streamlit app to my database. I used a secrets.toml file to store the information needed.
I created the session and everything works perfectly. But now I am struggling to execute sql commands. For example “show grants to user john.doe@hotmail.com”
How would I go about executing that query and showing the results in my streamlit app?
I did some research and see I’d have to use a cursor object, but if you use the secrets file you can’t create a cursor object.
“show grants to user john.doe@hotmail.com” doesn’t look like SQL.
Have you looked through this tutorial yet? Connect Streamlit to MySQL - Streamlit Docs
If you use st.experimental_connection (with a secrets file) you can either do queries with the .query("show grants...") method, or you can get the sqlalchemy session object with the .session, and use that to get a cursor if you need to python - How to get cursor in SQLAlchemy - Stack Overflow
My database I am using is snowflake , I should have mentioned my apologies
There’s a tutorial about this – take a look and see if it’s helpful Connect Streamlit to Snowflake - Streamlit Docs
Hey @rmc, did you ever figure this one out? I’m running into the same issue, I can’t figure out how to show grants using Streamlit since it’s not regarded as traditional SQL. I haven’t been able to find any straightforward docs on this.
I’m not sure you are allowed to do a SHOW query from snowpark or snowflake-python-connector, so you might need to something like this Snowflake Community and then query the resulting table.
This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.