Variables

variables:
  brand: Underbelly
  date: 2024-01-15

tasks:
  - name: analyze_brand
    type: agent
    agent_ref: default
    prompt: |
      Analyze performance for {{ brand }} on {{ date }}

variables:
  target_database:
    type: string
    description: Database to analyze
    default: "analytics_db"

  analysis_period:
    type: string
    description: Time period for analysis
    default: "last_30_days"
    enum:
      - last_7_days
      - last_30_days
      - last_quarter
      - custom

  max_results:
    type: integer
    description: Maximum number of results
    default: 100
    minimum: 1
    maximum: 1000

  include_archived:
    type: boolean
    description: Include archived records
    default: false

tasks:
  - name: analyze_sales
    type: agent
    agent_ref: analytics.agentic.yml
    prompt: |
      Analyze sales data for {{ analysis_period }}
    variables:
      database: "{{ target_database }}"
      period: "{{ analysis_period }}"
      limit: "{{ max_results }}"

tasks:
  - name: query_data
    type: execute_sql
    sql_file: sales_query.sql
    database: local
    variables:
      table_name: "{{ target_table }}"
      date_column: "{{ date_field }}"

tasks:
  - name: semantic_query
    type: semantic_query
    topic: sales
    dimensions:
      - orders.order_id
    variables:
      orders_table: "{{ orders_table }}"

variables:
  orders_table:
    type: string
    default: "orders"

tasks:
  - name: query_orders
    type: semantic_query
    topic: sales
    variables:
      table: "{{ orders_table }}"