This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
All of the Google documentation suggests starting the query with "#StandardSQL" but this doesn't work in the QlikView load script... Any ideas?
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=......";
SELECT (SELECT 1)
// A scalar sub select does not work in legacy SQL ...