Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. 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