[Feature] Add GitHub Actions Workflow Support

Aperta
  • Qualcosa non va?
#61 0 commenti 0 reazioni 0 assegnatari Vedi su GitHub

Nessuno ha ancora preso questa issue.

Valutazione

Difficoltà
5/5
Tempo stimato
Più di una settimana
Idoneità per principianti
35/100
Tipo di issue
Funzionalità
Chiarezza
Abbastanza chiara
Stato di attività
Ferma
Stack tecnologico
github-actions
Ambito
analytics, ci-cd, data-engineering

Direzione di ricerca

Inizia individuando i modelli di dati esistenti del connettore GitHub e le tabelle di origine workflow, workflow_run e workflow_pull_request. Esamina la struttura dei modelli di staging e intermedi, quindi definisci il riepilogo del workflow e il report del workflow run richiesti in base ai campi elencati. Il lavoro è completato quando i tre modelli di staging, int_github__workflow_summary e github__workflow_run_report forniscono le metriche CI/CD e il contesto della pull request indicati.

Scritto dal modello di indicizzazione a partire dal testo della issue.

Descrizione

good first issue type:enhancement
Is there an existing feature request for this?
  • I have searched the existing issues
Describe the Feature

Enhance the existing data model by integrating GitHub Actions workflow data available via the Fivetran GitHub connector. Specifically, incorporate the workflow, workflow_run, and workflow_pull_request tables to provide visibility into CI/CD health and performance.

GitHub Actions is a critical part of modern software delivery, powering automated testing, deployments, and other CI/CD workflows. Despite this, the current data model does not expose any workflow-related metrics or insights.

By integrating workflow data into the model, teams can:

  • Monitor workflow success/failure trends
  • Identify performance bottlenecks in builds and deployments
  • Correlate failing workflows with specific PRs, users, and branches
  • Improve developer efficiency and reduce time to resolution for workflow-related issues
How would you implement this feature?

Create staging models:

  • stg_github__workflow
  • stg_github__workflow_run
  • stg_github__workflow_pull_request

Create an intermediate int_github__workflow_summary model. Aggregates and summarizes workflow execution activity at the repository and workflow level. Example Fields:

  • repo_name
  • workflow_name
  • total_runs
  • success_rate
  • avg_duration_seconds
  • failed_runs_last_7_days
  • last_run_status

Finally a new end model github__workflow_run_report for enriched workflow run-level reporting. Joins workflow runs with pull requests and user metadata for context. This model would help support executive reporting on CI/CD health, provide insights into which PRs or branches introduce failing workflows, and drilldowns into long running or frequently failing workflows. Example Fields:

  • repo_name
  • workflow_name
  • workflow_run_id
  • status
  • conclusion
  • run_started_at
  • duration_seconds
  • pr_number
  • pr_title
  • pr_author
Describe alternatives you've considered

No response

Are you interested in contributing this feature?
  • Yes.
  • Yes, but I will need assistance.
  • No.
Anything else?

This feature would bring full visibility into a previously unmodeled but critical piece of the SDLC within GitHub: CI/CD workflows. It closes the loop from PR creation to automated testing and deployment, providing actionable insights for engineering and DevOps teams.

Lingua principale
Nessun dato sulla lingua
Stelle
21
Fork
25
Merge medio
1g 41m
PR unite (30g)
2

Preparare l'ambiente

  • Nessun Dockerfile né file Docker Compose
  • Ha un modello di pull request
  • Nessuna guida per i contributori

Come iniziare

  1. Leggi tutta la issue e poi la guida ai contributi del progetto.
  2. Commenta sulla issue per dire che te ne occupi tu — evita che due persone facciano lo stesso lavoro.
  3. Fai un fork del repository e lavora su un branch.
  4. Apri una pull request che faccia riferimento al numero della issue.

Altre issue di fivetran/dbt_github

Tutte le issue di fivetran/dbt_github

Issue simili

Altre issue su Data Visualization

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.