Options
Unable to store data into BigQuery
nazmimat_19103
Member Posts: 4 
Contributor I
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 ?
Tagged:
0
Answers
@KostasBonikos?
Can anyone in charge from RapidMiner test and solve this problem ?
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