Connecting to snowflake

ColleenSpence Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 2 ✭✭✭


I'm trying to connect my dataiku instance to a snowflake instance. I have admin rights in dataiku, but I don't understand JDBC connection URL v oauth connections.

I can get it to connect using my snowflake username and password, but there is one other user who needs to connect to snowflake and he can't use the same user name and password as me.

I've looked at the dataiku documentation, but it doesn't make any sense!

Thanks in advance

Operating system used: Linux



  • Sarina
    Sarina Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer Posts: 315 Dataiker

    Hi @ColleenSpence

    If you are trying to use a single username/password for multiple users to connect to Snowflake, the username and password simply need to be configured at the "global" level and not at the "per-user" level:

    Screenshot 2023-07-28 at 4.39.14 PM.png

    Then, the username and password simply need to be set up under the connection in Administration > Connections, and any user that has access to the connection should be able to authenticate.  

    If this still doesn't work for you, I would suggest checking the Security settings on the connection to ensure the user has access to the connection.


Setup Info
      Help me…