tBigQueryOutput to record field

Anonymous — Sat, 16 Nov 2024 08:52:58 GMT

Hello,

I have a bigQuery table with a record field, (field "city" with "city.id" and "city.name"). How can I populate this field with a tBigQueryOutput ?

I tried city_id and city_name in the output scheme but it doesn't work.

Thanks in advance,

Sylvain

Re: tBigQueryOutput to record field

lojdr — Thu, 11 Jan 2018 11:35:08 GMT

Hello,

I would try the Object datatype where you prepare the structure. Have you tried this way?

Regards

lojdr