sfc-gh-pschmoekel/ai-bootcamp ? reverse-engineered prompt

Build me a Snowflake demo notebook for a Saturday Ops use case that shows how to deliver a governed semantic layer and AI to the business.

I want one notebook I can upload into Snowsight and run all at once, with everything created from synthetic data so there’s no setup or external files needed. It should generate the tables for teams, games, stats, fans, tickets, concessions, merch, donations, game recaps, coach press conferences, fan surveys, and service tickets, then build a few useful analytics views on top of that. Please include a semantic view with a handful of verified example queries, plus a Cortex Search setup for coach press conferences and AI functions that turn raw stats and text into business friendly insights.

If it makes sense, also include a second day that extends the same database into agents, Agent Studio, a REST API, managed MCP, CoWork, and AI BI dashboards. Keep it simple enough for a bootcamp, and use current Snowflake docs online if you need to.