version: v2
kind: Spicepod
name: nginx

runtime:
  dataset_load_parallelism: 1

datasets:
  - from: github:github.com/nginx/nginx/issues
    name: nginx.issues
    description: Nginx GitHub issues from https://github.com/nginx/nginx
    time_column: created_at
    params:
      github_client_id: ${secrets:GITHUB_CLIENT_ID}
      github_private_key: ${secrets:GITHUB_PRIVATE_KEY}
      github_installation_id: ${secrets:GITHUB_INSTALLATION_ID}
    acceleration:
      enabled: true
      refresh_mode: full
      refresh_check_interval: 4h
      refresh_jitter_enabled: true
      refresh_jitter_max: 15m
    columns:
      - name: title
        embeddings:
          - from: openai_embeddings
            row_id:
              - number

  - from: github:github.com/nginx/nginx/pulls
    name: nginx.pulls
    description: Nginx GitHub pull requests from https://github.com/nginx/nginx
    time_column: created_at
    params:
      github_client_id: ${secrets:GITHUB_CLIENT_ID}
      github_private_key: ${secrets:GITHUB_PRIVATE_KEY}
      github_installation_id: ${secrets:GITHUB_INSTALLATION_ID}
    acceleration:
      enabled: true
      refresh_mode: full
      refresh_check_interval: 4h
      refresh_jitter_enabled: true
      refresh_jitter_max: 15m
    columns:
      - name: title
        embeddings:
          - from: openai_embeddings
            row_id:
              - number

  - from: github:github.com/nginx/nginx/commits
    name: nginx.commits
    description: Nginx GitHub commits from https://github.com/nginx/nginx
    time_column: committed_date
    params:
      github_client_id: ${secrets:GITHUB_CLIENT_ID}
      github_private_key: ${secrets:GITHUB_PRIVATE_KEY}
      github_installation_id: ${secrets:GITHUB_INSTALLATION_ID}
    acceleration:
      enabled: true
      refresh_mode: append
      refresh_check_interval: 4h
      refresh_jitter_enabled: true
      refresh_jitter_max: 15m
    columns:
      - name: message
        embeddings:
          - from: openai_embeddings
            row_id:
              - id

embeddings:
  - from: openai
    name: openai_embeddings
    params:
      openai_api_key: ${ secrets:OPENAI_API_KEY }