Nativequery on simba odbc bigquery

[Olenard]

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

[Anonymous]

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-da...

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.

[Olenard]

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