Gate running jsonschemas validations/deprecations based on a list of adapters supported by the jsonschemas

[graciegoheen]

Housekeeping

• [x] I am a maintainer of dbt-core

Short description

we’re working on adding adapter-specific configs to the jsonschemas.

we’re should to ship a list in core which gates running jsonschemas validations/deprecations based on a list of adapters supported by the jsonschemas

pros:

• avoid noisy/incorrect deprecations while we’re working through long tail of adapters
• we can then phase them out intentionally based on which adapters are ready

con: users on other adapters will get no jsonschema validations

Acceptance criteria

• new hard coded list like run_jsonschemas_adapater_list = ["snowflake", ...]
• only run jsonschemas validations if the adapter in use on a given run is in that list