I’m trying to write a JSON column to BigQuery using the DB Writer node, and can’t get the workflow to execute. I have a single JSON column that I want to write to a BQ table, but it appears there is a mapping issue. When I run the node, I get the following error:
ERROR DB Writer 3:278 Execute failed: Output type mapping is missing for column:
I’m assuming that there is some sort of missing mapping in the Output Type Mapping, so I came to the tab and tried to add one. However, when I try to add a mapping I only get string-type mappings, which doesn’t make sense. It seems like there should be a JSON mapping, or something similar? What am I missing?
Thanks in advance for the help!