Visnu Pitiyanuvath

Visualization

Small Questions

Hi @visnup! Can you please explain how this part work? I'm trying to query data from BQ public. Thanks!

Fidocia Wima Adityawarman

Ah, I have a CORS-friendly BigQuery-to-HTTP API thing (https://github.com/visnup/names/blob/master/index.js) that I run on Vercel using credentials tied directly to the BigQuery dataset. Do you have a similar connection?

Thank you for answering me. I have tried to build your code on my own vercel using my BQ service account (https://vercel-bigquery.vercel.app/). But it won't give me result. I have checked the BQ project logs, and queries are executed. Not sure what causing the error.

Hi @visnup, after struggling for some hours, now I managed to get it works!  Thanks!

Oh nice!!! Was it the credentials? I need to refresh the code (it’s 3 years old) and add some instructions for people who want to run it themselves.

I don't think it's the credentials because it was logged on BQ project history. I think it's something about the Vercel's Node.js [helpers](https://vercel.com/docs/runtimes#official-runtimes/node-js/node-js-request-and-response-objects). 

Here is the code that I'm using [bq-cors](https://github.com/adityawarmanfw/bq-cors). Thank you again, @visnup!