Forum Discussion

mcfarmer's avatar
mcfarmer
Data Storage
03-26-2022

REST API v2 Dataset Bigquery

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? 🙂 

 

1 Reply

Replies have been turned off for this discussion
  • AshtonW's avatar
    AshtonW
    Sisense Employee

    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