Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
m-wise
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
m-wise
Partner
Partner
Author

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
m-wise
Partner
Partner
Author

Is anyone using Direct discovery with Google Big query?

m-wise
Partner
Partner
Author

Found it.

Use:

SET DirectDistinctSupport=false;

SET DirectIdentifierQuoteChar='[]';

SET DirectIdentifierQuoteStyle='big query';

With the right quotes '

Then it works.

View solution in original post