Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
m-wise
New Contributor III

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
m-wise
New Contributor III

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.

2 Replies
m-wise
New Contributor III

Re: Direct discovery Google bigquery Connector error

Is anyone using Direct discovery with Google Big query?

m-wise
New Contributor III

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.

Community Browser