Direct changes to DB & Loading packages in SiS

Using Streamlit
,
1

Hello everyone! I’m new to using Streamlit with Snowflake and have a couple of questions:

First Question: Is there a package that allows writing data directly to a database in real time? Currently, I load a database table into a dataframe and use the data_editor so users can update or insert records. After the session, these changes are pushed to Snowflake. Is there a way to directly update Snowflake whenever a user modifies a row, without intermediate steps involving dataframes?

Second Question: How can I import functions from one Python Streamlit application to another within Snowflake? Additionally, how can I load a YAML file and read from it in a Snowflake environment?

Thank you for your help!

2

Running into the same issue as @Maksim_Romanchuk where I would like to update database entries in ~real-time. @Maksim_Romanchuk did you find a workaround?

3

I am currently truncating table and after write it from pandas, using: “df.write.mode(“overwrite”).saveAsTable(table_name)”
But I do not think it is the most efficient way, especially for the large tables.

4

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