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 [email protected]: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"

Demo questions

• 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)

Core context

• 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.