[CT-1814] [CT-420] Make a GitHub Action that periodically installs dbt in all the supported ways.

[nathaniel-may]

Describe the Feature

As a followup to dbt-labs/dbt-core#4891, to reduce the amount of time it takes to recognize installation issues with dbt core, twice daily we should attempt to install dbt core in all the supported ways and alert on failures in slack.

All Available install methods:

Use Homebrew to install dbt
Use pip to install dbt
Use a Docker image to install dbt
Install dbt from source

Existing Install Testing

Scheduled testing of Homebrew install here

Expected Schedule (same as Homebrew)

cron: "0 9,13,18 * * *" # 9:00, 13:00, 18:00 UTC

Verify Install with command

dbt --version

Failures to Slack

Match pattern in Homebrew installation-tests.yml

General Design

We should be able to schedule a single workflow to run that calls then a reusable workflow for each test type in a matrix of adapters. All workflows should also be able to be manually triggered.

Priority

1. pip
2. homebrew (done)
3. docker
4. source

Related issue

Docker Build Tests - dbt-labs/dbt-core#5154

[nathaniel-may]

We can also consider making this a step in the release process.

[leahwicz]

I created a PR to test install nightly for Homebrew:
dbt-labs/homebrew-dbt#109

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please remove the stale label or comment on the issue, or it will be closed in 7 days.

[leahwicz]

@emmyoop this is an issue we have already for testing installation in different ways

[emmyoop]

Notes on available install options for dbt: https://docs.getdbt.com/docs/get-started/installation

[emmyoop]

This is the issue specific to Docker: dbt-labs/dbt-core#5154

Not much info in it but linking for complete picture

[emmyoop]

This is done!