Forum Discussion
Nativequery on simba odbc bigquery
Dear colleagues, I am currently using odbc driver for gcp big query. I would like to know if the nativequery is available o' this driver and how to activate it. Thank you all Best
Hi Olenard ,
The following Power Query connectors support native database queries.
| Connector | Type of native database query |
|---|---|
| Azure Analysis Services database | MDX or DAX query |
| Azure Database for PostgreSQL | SQL statement |
| Azure Cosmos DB | SQL statement |
| Azure SQL Data Warehouse | SQL statement |
| Azure SQL database | SQL statement |
| DataWorld.Dataset | dwSQL |
| Essbase | MDX statement |
| FHIR | FHIR Search |
| IBM Db2 database | SQL statement |
| IBM Informix database (Beta) | SQL statement |
| MySQL database | SQL statement |
| ODBC | SQL statement |
| OLE DB | SQL statement |
| Oracle database | SQL statement |
| PostgreSQL | SQL statement |
| SAP HANA database | SQL statement |
| Snowflake | SQL statement |
| SQL Server Analysis Services database | MDX or DAX query |
| SQL Server database | SQL statement |
| TIBCO(R) Data Virtualization (Beta) | SQL statement |
| Vena (Beta) | Model Query (MQL) |
For more details, refer to https://docs.microsoft.com/en-us/power-query/native-database-query#connectors-that-support-native-database-queries
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
thank you for your feedback.
so from my understanding the nativequery should be ok with the odbc. How comes this does not work with simba for gcp