Validate whether a project is compatible with a target type

[clrcrl]

Feature

Feature description

Add an optional key to dbt_project.yml, like:

compatible-target-types:
  - redshift
  - postgres

On compile, validate this list against target.type. If the key isn't provided, no validation should occur.
If the target.type isn't in the list, a compilation error should be raised.

There should also be a flag, like --no-target-type-check to override this check.

Who will this benefit?

Mainly maintainers of packages

[clrcrl]

compatible-with?

[clrcrl]

Blocked by #1255

[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.