topic Re: Google big query connection error in QlikView

Google big query connection error

Mon, 22 Oct 2012 09:41:39 GMT

Hello!

I'm having some issues when using the Google big query connector (http://market.qlik.com/qlikview-connector-for-google-bigquery.html)

Everything works fine with the connection, I put in the client ID and key, get promted to allow the access, and get the generated key. I put this key into the qlikview application and it fetches my project. BUT, when i select the project to fetch the data there is an error (unhandled exception etc.)

I'm not using a billable project, but rather just trying out the connector and trying to connect to the sample data.

I have updated my .NET framwork to 4.5.

Does anyone know what could be the source of this issue?

Thanks

Re: Google big query connection error

Wed, 24 Oct 2012 13:32:45 GMT

I have also tried using the 32bit version of Qlikview (since the connecter seems to be written for this?) but with no luck, same error.

Can anyone confirm this is an issue depending on de lack of billing information in Google Big query, or is there something else I should look into?

Re: Google big query connection error

Thu, 01 Nov 2012 10:07:52 GMT

Hi,

Even without billing enabled you should be able to configure the connection.

Can you confirm that you have at least 1 dataset against the Project you are selecting. This is a known issue with the existing connector, if no dataset exists against the project then you receive that error when selecting the Project.

Thanks

Nick

Re: Google big query connection error

Thu, 01 Nov 2012 10:15:52 GMT

Hi,

Thank you for your response, I'm trying to use the sample data provided by Google, meaning the project hold the dataset:
publicdata:samples

Does it have to be my own dataset perhaps? Does Google interpret the connection as trying to alter a dataset that I do not have access to?

Regrds

Richard

Re: Google big query connection error

Thu, 01 Nov 2012 10:20:47 GMT

Hi Richard,

Unfortunately it's not possible to acces the sample datasets with the Connector. This is a restriction with BigQuery rather than the connector. I think you need to be on a public domain to use them.

However, you can copy the public datasets into your Project if you specifically want to use them or you should be able to upload a csv file.

Thanks

Nick

Re: Google big query connection error

Thu, 01 Nov 2012 10:22:32 GMT

Great, thank you for the clarification!