Connecting to snowflake

Options
ColleenSpence
ColleenSpence Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 2 ✭✭✭
in Setup & Configuration

Hi

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

Tagged:
· Share on FacebookShare on Twitter

Answers

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

    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.

    Thanks,
    Sarina 

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…