Transform JSON from BigQuery connector

giad · March 31, 2021, 3:57pm

Hi, I have connected Knime to BigQuery but when I select a db table selector I see for each table some fields in a JSON format, as attached.

How can I read these Json into a normal table?
In BigQuery I do not see JSON fields, everything is formatted

Thanks
Giad

Daniel_Weikert · March 31, 2021, 5:22pm

If it’s json format then check out the json nodes e.g. Json to Table,…
br

system · September 30, 2021, 5:23am

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.