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 linux with windows if it exposes these methods, making tests I created a connection but it didn't store the oid and in the provider I only put GenericJDBC but it no longer allows me to create another connection.
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 relationshipsand should use this endpoint (Image)
taking into account that the connector is already set up
