define `catalogs` in any schema yml file

[graciegoheen]

Housekeeping

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

Short description

Like groups, catalogs should be able to be defined in any schema yml file, not exclusive to a special catalogs.yml

Acceptance criteria

• i can define my catalogs in any schema yml file, like how groups works

Context

No response