topic Re: BigQuery Native Connector - Unverified app in Connectivity & Data Prep

BigQuery Native Connector - Unverified app

maximeclerix — Tue, 26 Nov 2019 16:15:11 GMT

Hi community,

I am trying to connect BigQuery using Native Connector, but once I click on signin button I am redirected to Google Sign In page and I have the following error message:

This message appears generally for apps that have not been verified by Google and ask for specific Oauth Scope. Any ideas how to solve this ?

Version used: Qlik Sense September 2019 version 13.42.1

Thank you for your help

Re: BigQuery Native Connector - Unverified app

vunguyenq89 — Wed, 27 Nov 2019 08:14:14 GMT

I got the same behavior with QS Desktop Sep 2019. Seems to be a bug.

Re: BigQuery Native Connector - Unverified app

larshilke — Thu, 28 Nov 2019 09:03:10 GMT

I've opened a ticket with Qlik Support regarding this issue. I'll update this thread with any findings.

EDIT: Qlik just reported that R&D are working on a fix for this problem.

Re: BigQuery Native Connector - Unverified app

larshilke — Mon, 02 Dec 2019 07:51:56 GMT

Qlik Bug ID: QVXGBQ-125

Re: BigQuery Native Connector - Unverified app

AlbinS — Wed, 11 Dec 2019 08:30:16 GMT

Hi,

Do you know of any any resolution for this bug yet? Extract of data is still working in Qlikview as the connection was set up a long time ago. Problem is that we are moving to Qlik Sense now and can't set up the connection there.

/Albin

Re: BigQuery Native Connector - Unverified app

larshilke — Wed, 11 Dec 2019 09:10:33 GMT

I've asked Qlik Support for an update. I'll update this thread when I hear from them.

And as you stated @AlbinS , the problem doesn't effect existing connections. Just setting up new ones.

Re: BigQuery Native Connector - Unverified app

Hernan_Russy — Thu, 12 Dec 2019 13:25:23 GMT

Hi. We are experiencing the same with here with QS Jun 2019. Our existing connections started to fail and won't work. Any advice will be much appreciated.

Re: BigQuery Native Connector - Unverified app

larshilke — Mon, 16 Dec 2019 11:39:31 GMT

I've received preliminary confirmation that this is now solved. I haven't tested it myself yet.

Re: BigQuery Native Connector - Unverified app

Hernan_Russy — Mon, 16 Dec 2019 12:58:55 GMT

Hi. Please can you share the solution? I still have an open support case on Qlik's Platform (01880584) and we have had to install SIMBA connector as a workaround. However, that connector is in trial mode and won't last longer than a few days. Thanks

Re: BigQuery Native Connector - Unverified app

larshilke — Tue, 17 Dec 2019 10:45:23 GMT

I can confirm that this is now working again (as of Dec 16th). Both in QS and QV.

The problem appears to have been related to Google's validation of Qlik's application. I don't have the details, but if you need more information, contact Qlik support and refer to bug id QVXODBC-1910.

Re: BigQuery Native Connector - Unverified app

Hernan_Russy — Tue, 17 Dec 2019 19:16:34 GMT

Hi larshilke. Thanks for the update! You have helped us a lot! We are
already setting up the connections to Big Query and all seems to be working
as expected. I will inform if anything comes up.