Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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 - Champion III
Partner - Champion III

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 ...