[Backport 1.8.latest] Update dbt-adapters ref to point to the subdirectory

[Backport 1.8.latest] Update dbt-adapters ref to point to the subdirectory #1405