[Backport 1.8.latest] ADAP-1135: Point to the dbt-adapters subdirectory for tests post-monorepo migration

[mikealfare]

Backport 48d9afa from #11244.

[github-actions]

Thank you for your pull request! We could not find a changelog entry for this change. For details on how to document a change, see the contributing guide.

[codecov]

Codecov Report

All modified and coverable lines are covered by tests ✅

Project coverage is 88.32%. Comparing base (1f7b98f) to head (e2ca170).
Report is 1 commits behind head on 1.8.latest.

Additional details and impacted files

@@              Coverage Diff               @@
##           1.8.latest   #11246      +/-   ##
==============================================
- Coverage       88.33%   88.32%   -0.01%     
==============================================
  Files             181      181              
  Lines           22796    22796              
==============================================
- Hits            20136    20134       -2     
- Misses           2660     2662       +2     

Flag	Coverage Δ
integration	85.58% <ø> (-0.01%)	⬇️
unit	62.83% <ø> (ø)

Flags with carried forward coverage won't be shown. Click here to find out more.

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.