how to configure the connection in databricks by means of api
- 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 relationshipsand should use this endpoint (Image)
taking into account that the connector is already set up