test a connection using dataiku's API ?

Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron, Dataiku DSS Adv Designer, Registered, Dataiku DSS Developer, Neuron 2023 Posts: 134 Neuron

Hello

We automated the process of setting up many connections in DSS using dataiku's API. However, when upgrading to the latest dss version we noticed that somes connections do not work anymore because their configuration have changed.

So as we are adapting our configuration as code, I am looking for a way to test a connection using dataiku's API (I am thinking of this button which I would like to trigguer directly, not by refreshing datasets in a scenario because I need to test hundreds of connections).


Is there a way to do that?

Operating system used: RHEL 8.10

Operating system used: RHEL 8.10

Operating system used: RHEL 8.10

Answers

  • Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,319 Neuron
    edited March 14

    We have asked Dataiku for an official API to do this so please do raise the support case to add your company to the internal enhancement request to give it more priority. In the meantime we developed this way which uses REST to hit the internal API the connections screen uses to test. It's obviously unsupported and subject to break if Dataiku makes changes to their internal APIs but we have been using it since v10 and have not had any issues. Enjoy!

    Testing SQL Connections

  • Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron, Dataiku DSS Adv Designer, Registered, Dataiku DSS Developer, Neuron 2023 Posts: 134 Neuron
    edited March 14

    Thanks @Turribeach (I have just gained admin access to DSS so this is all new to me)

    What is the internal enhancement request you are referring to (i have +1 your product idea)?

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.