Connect to Snowflake Account using SSO in Talend 7.1

[Anonymous]

Hi All,

Currently we are using Talend Enterprise version 7.1. We are looking for ways to connect to Snowflake Account using SSO/oauth not able to know the procedure to implement it. I have searched the Talend help manual. It says talend 7.1 supports oauth/SSO as a new feature. Kindly let me know the procedure to enable the oauth/SSO in accessing Snowflake account.

Thanks in Advance.

Regards,

Saravanan.

[Anonymous · Accepted solution]

Hello,

 Have you try to use this kind of query in snowflake component to see if it works well in V 7.1?

CREATE INTEGRATION oauth_test
TYPE=OAUTH_CUSTOM
OAUTH_CLIENT_TYPE='CONFIDENTIAL'
OAUTH_REDIRECT_URI='https://www.google.com'
OAUTH_REFRESH_TOKEN_VALIDITY = XXXXXX;

Could you please let us know if this documentation helps?

https://docs.snowflake.net/manuals/user-guide/admin-security-fed-auth-use.html 

Best regards

Sabrina

[m_garg]

in the above OAuth security Integration created in snowflake what would be the value for oauth_redirect_uri for talend 7.1?

[Xiaodi_Shi]

Hello @m_garg 

OAUTH_REDIRECT_URI :<our token manager application url>

Hope it helps.

Bes regards

Sabrina