[CT-2156] [Feature] Add dbt-redshift connection methods - Auth Profile and IdP Credentials(Azure and Okta Identity Providers)

[jiezhen-chen]

Is this your first time submitting a feature request?

• [X] I have read the expectations for open source contributors
• [X] I have searched the existing issues, and I could not find an existing issue for this feature
• [X] I am requesting a straightforward extension of existing dbt-redshift functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Provide additional authentication methods to connect to dbt-redshift. The new code changes will allow users to connect to dbt-redshift using authentication profiles and Identity Provider (IdP) Plugins for Azure and Okta. Users will need to provide required parameters specified in this Redshift documentation when configuring profiles.yml in order to authenticate using these new methods.

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

No response

Anything else?

No response

[dbeatty10]

Thanks for opening @jiezhen-chen !

I'm assuming you created this issue to link to https://github.com/dbt-labs/dbt-redshift/pull/323 (per request of @Fleid) ?

[jiezhen-chen]

Thanks for opening @jiezhen-chen !

I'm assuming you created this issue to link to #323 (per request of @Fleid) ?

yes!

[dbeatty10]

Awesome!

I added the issue number here to link it with the pull request:

[jaklan]

@dbeatty10 @jiezhen-chen I don't see it covered in the feature request, but it would be really crucial to also support the generic plugin:

[misteliy]

Any update on this? This is becoming even more relevant with AWS shifting towards identity center…

[github-actions[bot]]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

[jaklan]

bump