Forum Discussion

alexgv12's avatar
alexgv12
Cloud Apps
03-24-2022
Solved

how to configure the connection in databricks by means of api

I want to create dynamic connections for databricks by means of the api, but from sisense it shows me that I don't have access to create connections neither to modify, apparently for being using linu...
  • alexgv12's avatar
    alexgv12
    04-04-2022

    Hi Ramon I have already found the solution , thanks for your help

    when you create a cube and define the source you use a connector and create the connection from the IGU, this is why I thought that from the api I should first create a connection but for linux s.o. there is no endpoint to create connections, reviewing the documentation I found this repository that was very useful and helped me to understand the process (https://github.com/sisense/datamodels-demo)

    when you create a cube and define the source you use a connector and create the connection from the igu, this is why I thought that from the api I should first create a connection but for linux s.o. there is no endpoint to create connections, reviewing the documentation I found this repository that was very useful and helped me to understand the process (https://github.com/sisense/datamodels-demo)

    1. you must create the data model
    2. you must create the dataset associated to that data model (here in this step the connection information is sent) with the following structure
    "provider": "GenericJDBC_databricks",
    "parameters": {
    "ApiVersion": "2",
    "connectionString": "jdbc:databricks:Server="\";HTTPPath="\";Token="\";database="\"",
    "userName": "",
    "password": "",
    "database": "CData"
    },
    3. then tables and relationships

    and should use this endpoint (Image)

    taking into account that the connector is already set up