Oxy sample repo: Youtube Analytics

Basic setup

Install oxy with bash <(curl --proto '=https' --tlsv1.2 -LsSf https://get.oxy.tech)
Clone this repository with git clone git@github.com:oxy-hq/oxy-customer-demo.git
Set the OPENAI_API_KEY environment variable within your ~/.zshrc file
Run oxy serve to start the demo server from within the repo root directory
Run oxy build to rebuild the embeddings
Open http://localhost:3000 in your browser
Agent demo:
- Select sql-executor as agent
- Ask a question, e.g. "what is the total number of views for all videos from december 2024?"
Workflow demo:
- Select monthly_report from the right sidebar
- Click "Run"

To routing agent (uses sql-executor):
- how many more views did the Cushat channel get than the Downhill channel in December 2024
- make me a bar chart of the top channels and their views
To routing agent (uses existing workflows):
- get views, minutes, mom data at a channel level for January 2025
- how many views did the Abrico channel have in Jan?
- how many more views did the Abrico channel have in January than the Cushat channel?
  - (note: uses TWO workflows in conjunction to get the answer)

AGENT: There are two agents: sql-executor and sql-generator. sql-generator is only used for workflows that require caching of sql -- sql-executor should be selected and used in oxy serve for demos.
WORKFLOW: The primary workflow to demo is monthly-report/monthly-report.workflow.yml.
DATA + SEMANTIC LAYER: The source data is in db/, and comes with the repo. There is a youtube_filtered.sem.yml semantic layer file that can also be used for demonstrating the semantic layer.