Hi,

At this point in time BigQuery is not officially supported, as the sql it uses is not the same as the sql query that is generated in Yellowfin.
The following post contains a support task that is in reference to this.

However we did actually manage to get a JDBC driver and connect to a BigQuery DB, and created a view using 1 table (no joins).

Your issue seems to be in the connection itself, so we are thinking that either the driver, or the modifications you made to the web.xml are causing issues.

Are you able to send the driver, web.xml, yellowfin.log, source..log files to support@yellowfin.bi (as attachments bigger than 2mb will not be attached to forum posts).

However in saying this, even getting the connection up and running does not mean you will be able to generate the required reports due to comparabilities with the sql generated.

Apologies for the inconvenience.

Regards,
David

Hi David,

I managed to connect to a BigQuery, but there is another problem.
I give FreehandSQL (builder doesn't work because of LIMIT required) :
SELECT city, def_pub_payout FROM imp_w01.i0 LIMIT 100000

YF generate error

SQL statement is invalid.
The error message returned from the database was:
Something went wrong with the query: SELECT city", def_pub_payout" FROM ( SELECT city, def_pub_payout
FROM imp_w01.i0
LIMIT 100000 ) T


regards
a.chernyshev@tinkoffdigital.ru

Try to turn of the QueryParser as described here:
https://code.google.com/p/starschema-bigquery-jdbc/wiki/JDBCURL
Just add ?transformQuery=false into your jdbc url if you use queries that are compatible with bigquery.

@David
FYI: Our JDBC Driver includes a Query Transformation Engine which transforms SQL92-like queries into bigquery compatible ones.

I'll try to test the driver with your program, to see if it's compatible or not.
Link for the driver: https://code.google.com/p/starschema-bigquery-jdbc/

If you have any questions, feel free to contact me.

Regards,
Bal�zs Gunics
gunicsb{a}starschema.net

Hi,

Can you share the ODBC driver link that you used to connect.
I am not able to connect with http://code.google.com/p/starschema-bigquery-jdbc/

Thanks

Hi,
Is the jdbc driver https://code.google.com/p/starschema-bigquery-jdbc/ supports update data in bigquery. I see the description "Starschema's high performance Google BigQuery JDBC Driver provides methods for querying and updating data in a Google BigQuery database.", but when I try "insert" and "update" it fails. Why?

Looking forward to your reply. Thank you very much!

louise

Hi Louise,

I can say that Yellowfin will not allow you to insert data into any database, so even if the driver supports it, you cannot run such queries within Yellowfin.

The only exception to the above rule, is when importing a CSV file, or caching a view into another DB.

Hope this explains what you're seeing.

Regards,
David