Hi everyone~
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?