How to connect snowflake with private key to quick sight?

Q&A
,
1

Since snowflake going to restrict direct log via user name and password. How can we connect snowflake using private key and public key?

2

Hello Suyash,

Welcome to the QuickSuite Community !

you may refer here

Hope this helps.

Cheers,

Deep

3

Hi Deepak,

We don’t want to use Oauth. any other way to connect.

Regards,

Suyash

4

Hello Suyash,

As far as i know Nope, Amazon Quick Sight offers two ways to connect to Snowflake: with your Snowflake login credentials or with OAuth client credentials.

Thank you.

Cheers,

Deep

5

Thanks for raising this question, @Suyash_Joshi. From what I found in the thread, unfortunately it appears that Amazon QuickSight currently only supports connecting to Snowflake via:

The private key / public key (key-pair) authentication method you mentioned isn’t listed in the official connection options yet—so it may not be supported at this time.

If you like, I can check the most recent AWS docs to see if a key-pair method has been introduced recently and share any workaround.

6

Hi @suyash_joshi,

Following up here as it’s been awhile since last communication took place on this thread; did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

7

Hi @suyash_joshi,

Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you