Snowflake auth issues with okta sso

[OlvG]

Describe the problem/error/question

Auth problem with snowflake node due to SSO (okta)

What is the error message (if any)?

Error message is: username/password incorrect - which is only natural as i don’t have an actual password on the platform, but the authentication happens via SAML / Okta.

Please share your workflow

Only using the snowflake now to execute a simple ‘select count(*) from table’ query.

Information on your n8n setup

• n8n version: 1.80.3
• Database (default: SQLite): postgres
• Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
• Operating system: ClientOS: MacOS

[hrishikesh]

You’d likely have to:

• grab a token using Snowflake OAuth: Snowflake OAuth overview | Snowflake Documentation
• then execute the query using the token: Authenticating to the server | Snowflake Documentation

It’s highly likely that you’d have to use HTTP Request node to achieve this as opposed to Snowflake node.

Note that, as per the documentation, the token returned by OAuth is valid for just 10 mins, so you’d likely have to continue using the refresh token every time you wish to run the query.