Data fetching through bigquery using AIMMS

  • 28 October 2022
  • 1 reply

Badge +2


How to fetch data in AIMMS from a google cloud platform (GCP) database.

There is a .JSON file with me along with the queries. 



Best answer by MarcelRoelofs 2 November 2022, 14:18

View original

1 reply

Userlevel 4
Badge +5

Hi @RwitamJ 

The big question is obviously what you mean with a google cloud platform database? 

Are you talking about Cloud SQL, or BigQuery?

For the former I guess you should be able to setup an ODBC connection, for the latter I've succesfully run a slightly annotated BigQuery OpenAPI spec through the OpenAPI client generator of the DEX library, which would provide you with client code to access BigQuery through the BigQuery REST API. I've haven't tested the latter in any way, as we don't have a BigQuery account to test it with.


Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator