Connection to BigQuery

0
Hello, I am looking to connect my Mendix application with Google Big Query to display results of query in the web app and additionally insert records to a table. I looked up documentation already and I do not see any clear guide on how to set the connection up with big query. Can somebody please help me with this? What are my options? maybe a python script?   Thanks in advance.  
asked
2 answers
0

Google provide REST services for this: https://cloud.google.com/bigquery/docs/reference/rest

So just integrate using REST calls in Mendix https://docs.mendix.com/howto/integration/consume-a-rest-service 

answered
0

Writing a java action might be useful, using GCP BQ client libraries:

 

https://cloud.google.com/bigquery/docs/quickstarts/quickstart-client-libraries

answered