[Backport 1.8.latest] Add most recent dbt-docs changes

[github-actions[bot]]

Backport 8ee8b2560a1ff05f2451855cc6c9c93aa6388309 from #10307.

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 88.30%. Comparing base (10fed9f) to head (4be3f9c).

Additional details and impacted files

```diff @@ Coverage Diff @@ ## 1.8.latest #10318 +/- ## ============================================== + Coverage 88.28% 88.30% +0.01% ============================================== Files 181 181 Lines 22758 22758 ============================================== + Hits 20093 20097 +4 + Misses 2665 2661 -4 ``` | [Flag](https://app.codecov.io/gh/dbt-labs/dbt-core/pull/10318/flags?src=pr&el=flags&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=dbt-labs) | Coverage Δ | | |---|---|---| | [integration](https://app.codecov.io/gh/dbt-labs/dbt-core/pull/10318/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=dbt-labs) | `85.55% <ø> (ø)` | | | [unit](https://app.codecov.io/gh/dbt-labs/dbt-core/pull/10318/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=dbt-labs) | `62.80% <ø> (ø)` | | Flags with carried forward coverage won't be shown. [Click here](https://docs.codecov.io/docs/carryforward-flags?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=dbt-labs#carryforward-flags-in-the-pull-request-comment) to find out more.

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[MichelleArk]

Did some 🎩 of this branch:

❯ git checkout backport-10307-to-1.8.latest
Switched to branch 'backport-10307-to-1.8.latest'
Your branch is up to date with 'origin/backport-10307-to-1.8.latest'.
❯ cd ../jaffle-shop
❯ pyenv activate core-venv
❯ dbt docs generate
15:21:24  Running with dbt=1.8.2
15:21:25  Registered adapter: bigquery=1.9.0-a1
15:21:25  Found 18 models, 6 seeds, 20 data tests, 6 sources, 13 metrics, 770 macros, 6 semantic models, 4 unit tests
15:21:25
15:21:27  Concurrency: 1 threads (target='dev')
15:21:27
15:21:28  Building catalog
15:21:36  Catalog written to /Users/michelleark/src/jaffle-shop/target/catalog.json
❯ dbt docs serve
15:21:41  Running with dbt=1.8.2
Serving docs at 8080
To access from your browser, navigate to: http://localhost:8080

poked around, didn't see any warnings / errors + screenshot of graph visualization: