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

REST API v2 Dataset Bigquery

mcfarmer
7 - Data Storage
7 - Data Storage

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 1

AshtonW
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

Voice of Customer
Impact Business Intelligence (BI) and Analytics Market Research

Click Here & Complete Dresner's Wisdom of Crowdsยฎ Market Study Survey Today!

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request

Don't miss out:

Earn a BETA Launch Challenge Badge!