Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
silverthorn
Contributor
Contributor

Google BigQuery Connector "Standard SQL"

Hi All,

Has anyone had any success connecting to a view in a Google BigQuery database using the QlikView BigQuery Connector?

We've had success reading from several flat, dimension tables but as soon as we try and load from a view (which itself is based on tables with nested repeated fields) we get this error.

Error.JPG

All of the Google documentation suggests starting the query with "#StandardSQL" but this doesn't work in the QlikView load script... Any ideas?

1 Reply
petter
Partner
Partner

Actually it does work - but make sure that you put the directive #standardSQL on a separate line immediately after the SQL and

terminate the line with a regular newline.

CUSTOM CONNECT TO "Provider=BigQueryConnector.exe;clientId=......";

SQL

#standardSQL

SELECT (SELECT 1)

;

// A scalar sub select does not work in legacy SQL ...