### Introduction Repository streamlit-fansifter-fileupload-app(stored locally) contains Streamlit in Snowflake app. That app allows users to select label/artist values from drop down filters and then upload CSV file ### Objective We need to create new page for current project's Streamlit app called app_fileupload.py that needs refactoring from the perspective of data used in the filters. ### Detailed information about changes 1. Territory, label, artist, mailing list drop down filters should be replaced with values from this query: with fansifter_artist as ( select vendor_id, global_participant_id from fansifter_app_reporting.prod.artist_roster_main_rep -- status=INACTIVE union select vendor_id, global_participant_id from fansifter_app_reporting.prod.artist_roster_local_rep ) select fa.vendor_id, v.name as label_name, fa.global_participant_id, gp.name as artist_name, ml.id as mailing_list_id, ml.name as mailing_list_name from fansifter_artist fa inner join facts.prod.vendor v on fa.vendor_id = v.vendor_id inner join facts.prod.global_participant gp on gp.id = fa.global_participant_id inner join PREFERENCE_CENTER.PROD.FAN_MAILING_LIST ML ON gp.id=ml.global_participant_id where not v.is_deleted; 2. General layout changes- streamlit-fansifter-fileupload-app has different pages(delete, file upload, status). For this implementation we want to use tabs. 3. For rest of the changes follow current repository(streamlit-fansifter-backoffice-app) code writing patterns/approaches