REST API v2 Dataset Bigquery

[mcfarmer]

Hi!

I have been trying to get familiar with the REST Api and managed to connect & create a datamodel through a Python script. Now for the next step I would like to create a dataset in this datamodel by connecting to BigQuery, I only can not seem to figure out which parameters to pass. As Bigquery is not specified on https://sisense.dev/reference/rest/v2/connectors.html I was hoping somebody here would be able to help me out? 🙂 

[AshtonW]

Hi @mcfarmer ,

The easiest way to figure out the parameters and the formatting of the parameters is to create a new connection through the Sisense GUI,
then use the GET datamodels/schema endpoint to get the payload for the connection.

To do this, first, create a new live model in the Sisense GUI. Then click the "+ Data" button and configure your BigQuery connection.

Finally, send a GET request to /api/v2/datamodels/schema?title=<your_model_name>. You can get the parameters by indexing into the response object (datasets -> 0 -> connection -> parameters).

Note that some of the parameters are optional.

Hope this helps!
- Ashton