[CI/CD Improvements] Standardize workflows

[mikealfare]

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

Preview Give feedback

1. [CI/CD Improvements] Update and simplify CI workflows #138
   0 of 10
   cost_reduction +1
2. [CI/CD Improvements] Update and simplify CD workflows #139
   0 of 8
   cost_reduction +1

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 dbt-labs/actions#173.

[leahwicz]

@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]

@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]

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

[mikealfare]

This is rolling up into the monorepo work. I removed the one story that has incremental work on the monorepo so that I can close this one as a duplicate.