[Core] Add docs for Snowflake Workload Identity Federation Auth #7866
Description
Link to the page(s) on docs.getdbt.com requiring updates
https://docs.getdbt.com/docs/core/connect-data-platform/snowflake-setup
Tell us more about this update
As part of dbt-labs/dbt-adapters#1234, need to update docs to reflect the new connection options.
Reviewers/Stakeholders/SMEs
TBC
Related GitHub issues
Additional information
No response