Streamlit in snowflake
I have dataframes where each row has associated with an file in the s3 bucket. I used to allow them to download files one by one with get_presigned url ( GET_PRESIGNED_URL | Snowflake Documentation ).
This is not enough, I need ability to select multiple rows ( files ) and to allow users to download those files zipped.
The idea?
external access integration ( Creating and using an external access integration | Snowflake Documentation )
custom python udf ( Creating Python UDFs | Snowflake Documentation )
And since I cannot access the data file from the streamlit I’d need to create a custom python udf function which would fetch the file data.
I’d prefer to keep these files in memory, or if this cannot be done, maybe I should store them somewhere temporary ?
PS. I have noticed there is some sort of limitations when I am displaying large dataframes, this limitations would most likely affect the
Could this work or am I wasting my time, sorry I am new to the streamlit.