Fetch more node types from the dbt Manifest

[tatiana]

Sometimes, depending on the node type, the dbt manifest declares them in the root key nodes. However, in some cases (such as sources and exposures, dbt lists them using dedicated keys at the same level as nodes.

The goal for this ticket is to check all DbtResourceType items defined in cosmos.constants and try to find them in the root of the manifest file. This is particularly relevant since users can extend the definition of DbtResourceType by using DbtResourceType("newtype"), as part of #503.

This is a follow up to:
#503 (comment)

[dosubot]

Hi, @tatiana,

I'm helping the Cosmos team manage their backlog and am marking this issue as stale. The issue you raised involves broadening the types of nodes retrieved from the dbt Manifest, specifically identifying all DbtResourceType items defined in cosmos.constants and locating them in the root of the manifest file. It seems to be a continuation of a prior GitHub discussion, and there have been no further updates or activity reported on this issue.

Could you please confirm if this issue is still relevant to the latest version of the Cosmos repository? If it is, please let the Cosmos team know by commenting on the issue. Otherwise, feel free to close the issue yourself, or it will be automatically closed in 7 days.

Thank you for your understanding and cooperation.

I (Dosu)