Can I write back to Snowflake from streamlit app

I want to build a simple app for our support team to do some basic operations like creating users and tickets as needed. Does streamlit support write back to snowflake?

Hi @Narasimhan_Ganesh, welcome to the Streamlit community! :wave:

You should think of Streamlit just as a frontend. The connection to, reading from, and writing to Snowflake all happens via the the Snowflake Connector for Python. If the connector supports writing back to Snowflake, you can use that to write back data from your Streamlit app to Snowflake.

In your example, you’d need to consult the Snowflake Connector for Python docs to understand if creating users and tickets is possible:

https://docs.snowflake.com/en/user-guide/python-connector.html

To the more general question:

Can I write back to Snowflake from streamlit app

Yes, the Snowflake Connector for Python supports writing data back to Snowflake.

https://docs.snowflake.com/en/user-guide/python-connector-pandas.html#writing-data-from-a-pandas-dataframe-to-a-snowflake-database

https://docs.snowflake.com/en/user-guide/python-connector-example.html#creating-tables-and-inserting-data