[CI/CD Improvements] Standardize workflows

mikealfare commented 6 months ago

Short description

Standardize dbt-postgres workflows to reduce the overhead in running workflows across adapters and minimize maintenance efforts.

Objectives

Standardize workflows across all adapters; use dbt-postgres as the pilot
Minimize dependencies between workflows
- Move shared dependencies into actions
Reduce GHA footprint in dbt-postgres
- Move repo-agnostic actions into actions repo
- Move adapter-agnostic actions into dbt-adapters repo
Ensure dispatch workflows are idempotent
Simplify interactions between trigger events and inputs

## Stories
- [ ] https://github.com/dbt-labs/dbt-postgres/issues/137
- [ ] https://github.com/dbt-labs/dbt-postgres/issues/138
- [ ] https://github.com/dbt-labs/dbt-postgres/issues/139

Testing

New workflows are tested against their dev branch prior to merging

Security

This should not increase security risk, and potentially could reduce it. Any security risks should be addressed as part of https://github.com/dbt-labs/actions/issues/173.

leahwicz commented 2 months ago

@mikealfare would you want any help with this? Feel free to tell me to buzz off 😄 but I had the itch to do some DevOps work lol

mikealfare commented 2 months ago

@mikealfare would you want any help with this? Feel free to tell me to buzz off 😄 but I had the itch to do some DevOps work lol

@leahwicz The three stories attached above are ready to go. If you're willing to work them we would definitely appreciate it! Let me know if you have questions, and bare in mind that we're at our team retreat next week so I'll be less responsive during that period.

leahwicz commented 2 months ago

@mikealfare yup I'll take a crack at #137 to start and you can let me know what you think

dbt-labs / dbt-postgres