The below technical note would help the users to know about Google BigQuery with MicroStrategy from the latest release….
Support of Google BigQuery with MicroStrategy 9.3.1
Google BigQuery is supported as a warehouse with MicroStrategy 9.3.1. This support status applies to MicroStrategy Intelligence Server 9.3.1 running on Windows – it does not apply to MicroStrategy Intelligence Server 9.3.1 running on Linux, Solaris or HP-UX.
These are post-support statuses since the testing was performed after the release of MicroStrategy 9.3.1. Therefore, this support information (tabulated below) is not present in the General Information Readme files in MicroStrategy 9.3.1.
The following is the support information Intelligence Server on Windows for MicroStrategy 9.3.1:
| DBMS | Recommended Linux ODBC Driver | Status |
| Google Big Query | Simba BigQuery ODBC Driver 1.0.x | Supported |
Note:
In order to use Google BigQuery as a warehouse with MicroStrategy Intelligence Server 9.3.1, users must use the ‘Google BigQuery’ object in the ‘Database Connection Type’ window (located at Configuration Managers > Database Instance Manager > Database Instance) in MicroStrategy Desktop 9.3.1.
In order to access Google BigQuery as an Object in ‘Database Connection Type’ window, please contact MicroStrategy Technical Support in order to receive this file.
Limitations:
Please be aware that Google BigQuery is currently only supported for Freeform SQL, QueryBuilder, and Data Import.
Hope it helps for the day!!!