[CT-2138] Support to OAUTH snowflake connection for dbt-core

[gsugumar]

Is this your first time submitting a feature request?

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

Describe the feature

support OAUTH snowflake connection for dbt-core

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 reaching out @gsugumar !

You're in luck -- we already have support for OAuth connections in dbt-snowflake (implemented in dbt-labs/dbt-core#2069)!

However, you might find that one of the methods listed here is easier to set up and use.

It's a bit complex to set up all the pieces, but here's the relevant portion of your profiles.yml to use OAuth:

my-snowflake-db:
  target: dev
  outputs:
    dev:
      type: snowflake
      account: <ACCOUNT_ID>

      # Here's the specific pieces to configure OAuth 
      authenticator: oauth
      oauth_client_id: <OAUTH_CLIENT_ID>
      oauth_client_secret: <OAUTH_CLIENT_ID>
      token: <OAUTH_REFRESH_TOKEN>

Note: token is a refresh token rather than an access token.

This method assumes you have followed a guide like this to generate a refresh token. I also found this to be useful, especially the troubleshooting section.

Closing as a duplicate of dbt-labs/dbt-core#2050.