For start great thanks for everyone how are working with Streamlit, It is a great way to make Data app.
I encountered with a problem when I try to make a KPI Dashboard app:
@st.cache() def load_sql(): conn = pymssql.connect(**,**,**,**) sql =''' select * from test_table ''' retrun pd.read_sql(sql, conn) data = load_sql(conn)
But my ‘test_table’ update daily, so is there a way that it can automatically refresh every night?
PS: I tried to add a ’ st.button ’ on the page to rerun this load_sql() function, but it doesn’t seem to work.
Can anyone please HELP?