Connecting to Snowflake via Okta SSO

[armaandhull]

Environment

• Version:

2023-07-13 19:21:18.027  INFO  [CLI] cli version: 0.6.0 
2023-07-13 19:21:18.029  INFO  [CLI] core version: 0.6.0 
2023-07-13 19:21:18.029  INFO  [CLI] build version: 0.6.0 
2023-07-13 19:21:18.030  INFO  [CLI] serve version: 0.6.0 

• OS: macOS

What's wrong?

Unable to connect to Snowflake via Okta SSO

What's the correct behavior?

Connection to Snowflake should work

Reproducing steps

Use the following config in profiles.yaml and run vulcan start

- name: snowflake
  type: snowflake
  connection:
    account: '<snowflake account>'
    username: <snowflake login name>
    password: https://vimeo.okta.com/app/snowflake/<unique ID>/sso/saml
    authenticator: OKTA
    warehouse: GENERAL
    min: 0
    max: 3
  allow: '*'

Logs:

2023-07-13 17:41:15.233  DEBUG [BUILD] Initializing data source: snowflake 
2023-07-13 17:41:15.236  DEBUG [CORE] Initializing profile: snowflake using snowflake driver 
⠧ Building project...Unable to connect: Incorrect username or password was specified.
✖ Building project...

 Error  Incorrect username or password was specified.
error stack:
• core.js:239 <anonymous>
    snapshot/shimin/Sites/canner/vulcan-sql-packager/binary/node_modules/snowflake-sdk/lib/core.js:239:22

• connection.js:196 <anonymous>
    snapshot/shimin/Sites/canner/vulcan-sql-packager/binary/node_modules/snowflake-sdk/lib/connection/connection.js:196:9

• sf.js:1193 requestCallback
    snapshot/shimin/Sites/canner/vulcan-sql-packager/binary/node_modules/snowflake-sdk/lib/services/sf.js:1193:23

• sf.js:663 callback
    snapshot/shimin/Sites/canner/vulcan-sql-packager/binary/node_modules/snowflake-sdk/lib/services/sf.js:663:43

• base.js:111 <anonymous>
    snapshot/shimin/Sites/canner/vulcan-sql-packager/binary/node_modules/snowflake-sdk/lib/http/base.js:111:25

• urllib.js:589 done
    snapshot/shimin/Sites/canner/vulcan-sql-packager/binary/node_modules/urllib/lib/urllib.js:589:5

• urllib.js:953 <anonymous>
    snapshot/shimin/Sites/canner/vulcan-sql-packager/binary/node_modules/urllib/lib/urllib.js:953:9

• urllib.js:740 decodeContent
    snapshot/shimin/Sites/canner/vulcan-sql-packager/binary/node_modules/urllib/lib/urllib.js:740:14

• urllib.js:924 handleResponseCloseAndEnd
    snapshot/shimin/Sites/canner/vulcan-sql-packager/binary/node_modules/urllib/lib/urllib.js:924:7

• urllib.js:962 <anonymous>
    snapshot/shimin/Sites/canner/vulcan-sql-packager/binary/node_modules/urllib/lib/urllib.js:962:7

[wwwy3y3]

Thank you for reporting this issue. We'll take a look and come back to you.

[onlyjackfrost]

@armaandhull Thank you for reporting this issue. I will start working on it.