Create Snowflake Datasource with Username & Password (2FA)

Question & Answer
,
1

As snowflake is promoting two factor authentication, i am wondering if we still can use username and password to create the snowflake datasource in QuickSight

2

Hi @Barbara

Welcome to the QuickSight community!

Yes, despite Snowflake’s promotion of two-factor authentication (2FA), you can still use your username and password to create a Snowflake data source in QuickSight. QuickSight offers two connection methods to Snowflake.

Login Credentials: This method involves using your Snowflake username and password.

OAuth Client Credentials: This method uses OAuth for enhanced security.

3

image
image480×509 19.5 KB

From the UI, I only see this option. Does this mean that if I want to create a data source through the UI, I must use login credentials?

For OAuth client credentials, can it only be done via the API?

4

Hi @Barbara

Yes, creating a Snowflake data source currently requires using your Snowflake login credentials (username and password).

OAuth client credentials is available exclusively through the QuickSight API.