Can I write back to Snowflake from streamlit app

Streamlit and Snowflake
1

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?

2

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

3

Hi @Narasimhan_Ganesh,

Absolutely, you can. Here’s a code sample illustrating that:

Look for the newEmployeeDf.write.mode("append").saveAsTable("employee") and check how I created the newEmployeeDf dataframe.

4

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