Hi,
We are on 4.2 sp8 and we can only use Legacy SQL in the Sql transform to read from Google Big Query.
We have tried using the hints ‘#standardSQL’ and ‘#legacySQL’ but this prevents the transform from mapping an output schema as the query then fails.
We have also looked in the 4.2 sp10 manuals which does not mention the SQL dialect supported ( and also gives incorrect and inconsistent example statements 
).
Are there any configuration options available to use standard sql as we have an access layer which is built using standard sql views which will need to be duplicated to allow data to be read.
Thanks in advance
pxbaker 
(BOB member since 2007-01-09)