Direct discovery Google bigquery Connector error

[m-wise]

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

[m-wise]

Is anyone using Direct discovery with Google Big query?

[m-wise · Accepted solution]

Found it.

Use:

SET DirectDistinctSupport=false;

SET DirectIdentifierQuoteChar='[]';

SET DirectIdentifierQuoteStyle='big query';

With the right quotes '

Then it works.

[danielmartinroiback]

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.