[Bug] sc-31865 Handle edge case if no manifest.json found when compare

[kentwelcome]

PR checklist

• [x] Ensure you have added or ran the appropriate tests for your PR.
• [x] DCO signed

What type of PR is this? Cherry-pick

What this PR does / why we need it:

• Execute dbt compile at current working directory if there is no target/manifest.json file found before listing dbt resources

Which issue(s) this PR fixes: sc-31865

Special notes for your reviewer:

Does this PR introduce a user-facing change?: