🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

Unable to store data into BigQuery

nazmimat_19103

Screen Shot 2017-11-22 at 5.40.50 PM.png

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 ?

Find more posts tagged with

AI Studio

BigQuery

Accepted answers

All comments

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