[
https://issues.apache.org/jira/browse/BEAM-4634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17142579#comment-17142579
]
Brian M commented on BEAM-4634:
-------------------------------
It looks like both the Python and Java SDKs allow developers to enable Standard
SQL by setting {code:python}use_standard_sql=True{code} and
{code:java}.usingStandardSql(){code} respectively. It seems like the Go SDK
should have a similar option allowing users to opt-in to Standard SQL queries
and turn off Legacy SQL.
FWIW Java and Python BigQuery readers also support flags controlling result
flattening and validation.
----
In terms of API design, the other Go SDK IO packages don't have much precedent
in terms of passing options. The closest seems to be pubsubio, which uses a
`ReadOptions` struct. Alternative approaches could include something like
`opts ...ClientOptions` or accepting an entire BigQuery `QueryConfig`.
> Use Standard SQL in biqueryio transform
> ---------------------------------------
>
> Key: BEAM-4634
> URL: https://issues.apache.org/jira/browse/BEAM-4634
> Project: Beam
> Issue Type: Improvement
> Components: sdk-go
> Reporter: Eduardo Morales
> Priority: P3
>
> The bigqueryio transform is currently hard coded to use Legacy SQL. Using the
> newer Standard SQL would allow us to write richer queries.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
