How to execute a query in streamlit

Using Streamlit
1

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.

2

“show grants to user john.doe@hotmail.com” doesn’t look like SQL.

3

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

4

My database I am using is snowflake , I should have mentioned my apologies

5

There’s a tutorial about this – take a look and see if it’s helpful Connect Streamlit to Snowflake - Streamlit Docs

6

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.

7

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.

8

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.