[Bigquery] Use allowQuotedNewlines in tBigQueryOutput

[Jeff4]

Hi,

I'am using tBigQueryOutput component and i have the ffollowing problem.

The temporary csv file used by rge component contains "quoted new lines"

Example:

header:   col1,col2,col3
line1:    "foo","bar","foobar"
line2:    "foo1","bar1","foo1
           bar1"
line3:   "foo2","bar2","etc ..."

This format is supported by google if you use the allowQuotedNewlines (see https://cloud.google.com/bigquery/docs/loading-data-cloud-storage-csv#csv-options)

It's working with cli and custom java code.

However the allowQuotedNewlines is not available in the component.

I look in the talend generated java code and the load is initiated with default csv options.

=> Do you know how to force this option or how to make an evolution in the components to integrate it ?

[Anonymous · Accepted solution]

Hello,

Could you please create a new feature jira issue on talend bug tracker?

https://jira.talendforge.org/secure/Dashboard.jspa

Best regards

Sabrina

[Jeff4]

Done.

See: https://jira.talendforge.org/projects/TDI/issues/TDI-42441.