Question

Can I use 3rd-side API as a datasource?

  • 29 August 2021
  • 1 reply
  • 69 views

Hi, how can bring my own data to Looker with RESTful API I already have? Or should the datasource always be a database only?


This topic has been closed for comments

1 reply

Userlevel 4
Badge

Hi @ua.ulin-1630270949,

 

Generally speaking you would want to write the data to a database,  you could even write it to a google sheet, then connect to the Google Sheet with a BigQuery connection. The connection process is detailed in this article.

 

Alternatively, if this would not work for your team, you could create a process that dynamically writes a derived table and unions the data together. There is this tool https://csv-sql.web.app/. In theory, you could use the Github API to update the derived table and use a similar syntax generated by the csv-sql app. You would still need a database connection to write the temp tables in. 

 

The Google Sheets method and the database would be far more robust options.

 

Please let us know how it goes!

 

Thanks,

Eric