Problem using Qlik Web Connectors - Big Query.

[Aurélie83]

Hello everyone !

I'm facing a strange problem..

(Using QlikSense Enterprise - QvOdbcConnectorPackage)

We are already using the connector enabling us access through GCP (Google Cloud Platform)

Here we can already preview 'Owner' and all linked tables (and of course preview what contains each of those tables).

But a newly connector was made up using the exact parameters (account service is different though) and it's possible to connect to it, however we can't preview any Owner nor data.

The Catalog is automatically setup with the use of a JSON key File, and it seems correct because we can use any test Query and fetch data from the source ! (So we are pointing in the right direction..).

So the main difficulty remains; can't preview any data/metadata from the connector. This connector will be available to end-users so we can't operate it in this state...

More information :

- New GCP service account is setup accordingly to the second one (same)

- Here's our parameters, maybe something is wrong there (already tried to 'tweek' some values from true to false) ! :

CUSTOM CONNECT TO "provider=QvOdbcConnectorPackage.exe;

driver=gbq;OAuthMechanism=0;

Email=XXX@XXX.iam.gserviceaccount.com;

Catalog=XXX;

Min_TLS=1.2;

UseProxy=false;

SQLDialect=1;

EnableSQLPrepareMetadataWithLegacySQL=true;

UseLegacySQLMetadata=1;

AllowLargeResultSets=true;

AllowLargeResults=1;

LargeResultDataSetId=_odbc_temp_tables;

LargeResultsTempTableExpirationTime=3600000;

RowsFetchedPerBlock=16384;

DefaultStringColumnLength=65535;

EnableHTAPI=false;

HTAPI_MinResultsSize=1000;

HTAPI_MinActivationRatio=3;

UseSystemTrustStore=true;

allowNonSelectQueries=true;

QueryTimeout=30;"

Thanks a lot community for your help ! 🙂

[Alan_Slaughter · Accepted solution]

Please review the following:

https://community.qlik.com/t5/Support-Updates/Qlik-s-Google-BigQuery-Connector-and-the-deprecation-o...

[Albert_Candelario]

Hello @Aurélie83 ,

Thanks for posting as @Alan_Slaughter  has pointed, this might be related to the deprecation done by Google, kindly follow the steps provided on the article shared by Alan and the issue should be resolved.

Cheers,

Albert

[AbhiUKVM]

hi , we have updated the latest patch (for GCP connectivity change) as well and are running QlikView 12 April 2019. but getting the below error. Above is the screenshot from the ODBC config file.

the Query we ran is a simple select query with coalesce.

==============

Unable to get column information for the fields that are used in the query. Please make sure that  SQL statement used produces a result set or use !EXECUTE_NON_SELECT_QUERY keyword.
Icoms_Email:

Load
*

==========

[Albert_Candelario]

Hello @AbhiUKVM ,

I would strongly suggest to create a new post on your particular challenge as it might not be related to the topic discussed on this post.

Cheers,

Albert