Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

Direct discovery Google bigquery Connector error

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Direct discovery Google bigquery Connector error

Found it.

Use:

SET DirectDistinctSupport=false;

SET DirectIdentifierQuoteChar='[]';

SET DirectIdentifierQuoteStyle='big query';

With the right quotes '

Then it works.

View solution in original post

2 Replies
Partner
Partner

Re: Direct discovery Google bigquery Connector error

Is anyone using Direct discovery with Google Big query?

Highlighted
Partner
Partner

Re: Direct discovery Google bigquery Connector error

Found it.

Use:

SET DirectDistinctSupport=false;

SET DirectIdentifierQuoteChar='[]';

SET DirectIdentifierQuoteStyle='big query';

With the right quotes '

Then it works.

View solution in original post