Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

okta auth #37

Closed
ryanking opened this issue Jun 12, 2019 · 3 comments
Closed

okta auth #37

ryanking opened this issue Jun 12, 2019 · 3 comments
Labels
feature-request Used to mark issues with provider's missing functionalities

Comments

@ryanking
Copy link
Contributor

No description provided.

@ryanking ryanking self-assigned this Jun 12, 2019
@mhaley-miovision
Copy link

In general snowflake provides the ability to use oauth tokens to authenticate when using command line tools or even connectors within programs. We should support the ability to provide an oauth token as a form of authentication.

@ryanking ryanking added the feature-request Used to mark issues with provider's missing functionalities label May 12, 2020
@ryanking ryanking removed their assignment May 12, 2020
@ataki ataki mentioned this issue Jun 7, 2020
Merged
3 tasks
@ataki
Copy link
Contributor

ataki commented Jun 7, 2020 •
edited
Loading

@mhaley-miovision at my company, we have a potential use case for oauth access tokens as well. I just put out a PR for this. It's limited in scope since it requires you to have a valid, non-expired access token, but might satisfy your command line tool use case

ataki added a commit to ataki/terraform-provider-snowflake that referenced this issue Jun 10, 2020
@ataki
Merge branch 'master' into ataki/Snowflake-Labsgh-37-okta-auth
5a1403b
ryanking pushed a commit that referenced this issue Jun 10, 2020
@ataki
adds oauth access token to provider schema (#207)
b61248d 
<!-- Feel free to delete comments as you fill this in -->
Adds OAuth access token support as requested [in this ticket](#37).

Note this does not add logic around renewing the access token. If the access token is not valid, the user is presented with the Snowflake error.

We at Flexport have a potential use case where we would like to generate short-lived OAuth tokens and distribute to an application or user for a brief period of time.

<!-- summary of changes -->

## Test Plan
<!-- detail ways in which this PR has been tested or needs to be tested -->
* [x] Manual acceptance test: Generated valid oauth access token from Snowflake account with the correct roles, and verified that the roles are correct
* [x] Manual acceptance test: Verified that when an empty access token is used, Snowflake reports "missing password"
* [x] Unit test: DSN unit test corresponding to tests above

## References
<!-- issues documentation links, etc  -->
* [Snowflake OAuth Flow for Custom Clients](https://docs.snowflake.com/en/user-guide/oauth-custom.html#configure-snowflake-oauth-for-custom-clients)
@gjv9491 gjv9491 mentioned this issue Mar 16, 2021
Merged
2 tasks
@sfc-gh-asawicki
Copy link
Collaborator

We are closing this issue as part of a cleanup described in announcement. If you believe that the issue is still valid in v0.89.0, please open a new ticket.

@sfc-gh-asawicki sfc-gh-asawicki closed this as not planned Won't fix, can't repro, duplicate, stale Apr 30, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
feature-request Used to mark issues with provider's missing functionalities
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@ryanking @ataki @mhaley-miovision @sfc-gh-asawicki