Hello Can anyone suggest me that is it possible to integrate BigQuery with Netsuite using suitscript.

i can confirm it is 100% possible. I will not expand on the things I had to do on a tight deadline to make that happen, I won't run the risk of being charged with crimes against humanity

Thank you and if you have time can you look at the code and suggest if any errors are there.

i can't it was years ago and 3 jobs ago 🙂

Appreciate and Thank you for your support.

in broad strokes, the auth to connect directly to BQ was painful, required JWT, and I wasn't having any luck with that so in the interests of time I used cloud functions, which are the google equivalent of AWS lambdas the cloud function was effectively just a webhook for NS to talk to, and the permissions could be set to access BQ from there because I was already in the google cloud infrastructure.... I guess in NS terms what i did was the equivalent of a suitelet available without login... i just added an API key header auth of my own to make it secure. i don't recommend doing ANYTHING like this, take the time to figure out the JWT auth and connect to BQ directly and securely.

Could you please navigate how to do JWT auth

i never did figure it out 🙂

Hello @Harika, we have a development platform that already support integration between BigQuery and NetSuite, so you can avoid the painful experience of JWT and NetSuite. Let me know if you are interested.