Showing results forย 
Search instead forย 
Did you mean:ย 

REST API v2 Dataset Bigquery

7 - Data Storage
7 - Data Storage


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 I was hoping somebody here would be able to help me out? ๐Ÿ™‚ 


Sisense Team Member
Sisense Team Member

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