Streamlit hackathon app

To run

Setup virtualenv:

python3 -m venv venv
source ./venv/bin/activate
pip install --requirement requirements.txt

Create secrets.toml (change account and user):

mkdir .streamlit
cat > .streamlit/secrets.toml <<'EOT'
[connections.snowflake]
account = "vd12345-example"
user = "john.smith@example.com"
authenticator = "EXTERNALBROWSER"
EOT

Start app:

./start-app.sh

To deploy

SNOWSQL_PWD='0*******o' snowsql --accountname 'vd12345-hackathon' --username 'jsmith' --dbname 'hackathon' --schemaname 'group_1' --warehouse 'compute_wh' --rolename 'ACCOUNTADMIN'
drop stage hackathon.group_1.streamlit_stage;
create or replace stage hackathon.group_1.streamlit_stage;
REMOVE @hackathon.group_1.streamlit_stage/;
PUT 'file:///home/klo/Projects/mq/hack-g1/1_Commence_Estimates.py' @hackathon.group_1.streamlit_stage overwrite=true auto_compress=false;
PUT 'file:///home/klo/Projects/mq/hack-g1/environment.yml' @hackathon.group_1.streamlit_stage overwrite=true auto_compress=false;
PUT 'file:///home/klo/Projects/mq/hack-g1/pages/2_Rule_Settings.py' @hackathon.group_1.streamlit_stage/pages overwrite=true auto_compress=false;
PUT 'file:///home/klo/Projects/mq/hack-g1/pages/3_Scenario_Management.py' @hackathon.group_1.streamlit_stage/pages overwrite=true auto_compress=false;
PUT 'file:///home/klo/Projects/mq/hack-g1/pages/4_Dashboard.py' @hackathon.group_1.streamlit_stage/pages overwrite=true auto_compress=false;
PUT 'file:///home/klo/Projects/mq/hack-g1/pages/5_Reference_Data.py' @hackathon.group_1.streamlit_stage/pages overwrite=true auto_compress=false;
-- Libraries
PUT 'file:///home/klo/Projects/mq/hack-g1/helpers/__init__.py' @hackathon.group_1.streamlit_stage/helpers overwrite=true auto_compress=false;
PUT 'file:///home/klo/Projects/mq/hack-g1/helpers/utils.py' @hackathon.group_1.streamlit_stage/helpers overwrite=true auto_compress=false;
PUT 'file:///home/klo/Projects/mq/hack-g1/models/__init__.py' @hackathon.group_1.streamlit_stage/models overwrite=true auto_compress=false;
PUT 'file:///home/klo/Projects/mq/hack-g1/models/Scenario.py' @hackathon.group_1.streamlit_stage/models overwrite=true auto_compress=false;

create or replace streamlit group_1
root_location = '@hackathon.group_1.streamlit_stage'
main_file = '/1_Commence_Estimates.py'
query_warehouse = 'compute_wh';

-- Rename to final name "EstiUniEnrol"
ALTER STREAMLIT group_1 RENAME TO EstiUniEnrol;

-- create or replace streamlit kokyantest
-- root_location = '@hackathon.group_1.streamlit_stage'
-- main_file = '/1_📓_Commence_Estimates.py'
-- query_warehouse = 'compute_wh';

-- SHOW STREAMLITS;
-- DESC STREAMLIT kokyantest;
-- ALTER STREAMLIT kokyantest RENAME TO group_1;
-- DROP STREAMLIT group_1;