Unable to store data into BigQuery

nazmimat_19103

 

I keep getting this error whenever I want to store data from RapidMiner to BigQuery. The connection are okay, where I already can retrieve data from BigQuery, but the error are quite weird when storing the data. The nominal or text data type in RapidMiner always tried to store into the BQ using SQL type DATETIME, and when it is integer, the error thrown said that I was about to store float64 data. 

 

Any solution to store data from Rapidminer to BQ ?

 

 

sgenzer

@KostasBonikos?

 

 

nazmimat_19103

Can anyone in charge from RapidMiner test and solve this problem ? 

KostasBonikos

Hello,

In the Manage Database Connections dialog, you should have a URL formed at the bottom, can I please have that URL to check what arguments are being passed?

Please ensure no confidential information is contained in the URL before you post it.

 

A possible cause can be the SQL dialect. It may be worth trying with QueryDialect=BIG_QUERY

https://www.simba.com/products/BigQuery/doc/v1/JDBC_InstallGuide/content/jdbc/features/connector.htm?Highlight=dialect

https://www.simba.com/products/BigQuery/doc/v1/JDBC_InstallGuide/content/jdbc/bq/options/querydialect.htm