topic Re: Direct discovery Google bigquery Connector error in QlikView

Direct discovery Google bigquery Connector error

m-wise — Thu, 22 Jan 2015 11:04:01 GMT

When trying to use Direct Discovery together with Google's bigquery i'm gettin the followingg error:

Connector is not responding !!!

If I just load the data from Bigquery everything runs fine

LOAD

TransID,

Alpha;

SQL SELECT

TransID,

Alpha

FROM BQtestData;

If I try to use Direct discovery i'm getting a time-out

DIRECT QUERY

DIMENSION

Alpha

MEASURE

TransID

FROM BQtestData;

When I hit ReLoad it displays:

DirectTable << INLBF16 0 lines fetched

"BQtestData".Alpha (fetching)

then after 30 seconds:

Connector is not responding !!!

Can someone please help me with this?

This looks like a great feature. But I can't make it to work.

Roy

Re: Direct discovery Google bigquery Connector error

m-wise — Fri, 20 Feb 2015 13:15:41 GMT

Is anyone using Direct discovery with Google Big query?

Re: Direct discovery Google bigquery Connector error

m-wise — Tue, 24 Feb 2015 16:57:51 GMT

Found it.

Use:

SET DirectDistinctSupport=false;

SET DirectIdentifierQuoteChar='[]';

SET DirectIdentifierQuoteStyle='big query';

With the right quotes '

Then it works.

Re: Direct discovery Google bigquery Connector error

danielmartinroiback — Tue, 28 Mar 2023 10:16:34 GMT

Please, can you send me an example that it run on Qlik Sense on-premise?

I am trying these and not run:

SET DirectDistinctSupport=false;
SET DirectIdentifierQuoteChar='[]';
SET DirectIdentifierQuoteStyle='big query';

LIB CONNECT TO 'Google_BigQuery_conection';

Direct QUERY dimension chain_id, hotel_id, web_account_type measure ga4_id from core.GA4_accounts;

Error:

ERROR [42000] [Qlik][BigQuery] (70) Invalid query: Syntax error: Unexpected "[" at [1:24]. If this is a table identifier, escape the name with `, e.g. `table.name` rather than [table.name].

Thanks a lot.