How to execute a query in streamlit


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

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” 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