feat(app): rewrite demo application with connection config tweaks and use generic PythonTool

[sfc-gh-twhite]

The Streamlit application needs a few adjustments before it can be better dockerized".

The application currently assumes a .env file exists in the parent directory.

orchestration-framework/demo_app/demo_app.py

Line 35 in 90b6f14

load_dotenv("../.env")

A few environment variables need to be provided to establish a connection to Snowflake and the News API that is currently being used.

orchestration-framework/demo_app/demo_app.py

Lines 38 to 48 in 90b6f14

	connection_parameters = {
	"account": os.getenv("SNOWFLAKE_ACCOUNT"),
	"user": os.getenv("SNOWFLAKE_USER"),
	"password": os.getenv("SNOWFLAKE_PASSWORD"),
	"role": os.getenv("SNOWFLAKE_ROLE"),
	"warehouse": os.getenv("SNOWFLAKE_WAREHOUSE"),
	"database": os.getenv("SNOWFLAKE_DATABASE"),
	"schema": os.getenv("SNOWFLAKE_SCHEMA"),
	}
	os.environ["NEWS_API_TOKEN"] = os.getenv("NEWS_API_TOKEN")

Lastly, I think we've got some legacy naming stuff going on that we will need to adjust:

orchestration-framework/demo_app/demo_app.py

Line 36 in 90b6f14

st.set_page_config(page_title="Snowflake Cortex Cube")

orchestration-framework/demo_app/demo_app.py

Lines 250 to 253 in 90b6f14

	st.markdown(
	"<h1>🧠 Snowflake Cortex<sup style='font-size:.8em;'>3</sup></h1>",
	unsafe_allow_html=True,
	)

[sfc-gh-alherrera]

Good call outs. I think we can probably just kill the news search tool from this app and make it a generic web page crawler like in the README to simplify this