LoadJob in BigQuery gives 400 Unsupported field type: JSON
I have a table in BigQuery with multiple columns, one of them being JSON. Say for example, col1 is STRING, col2 is INT and col3 is JSON. I have the data in a Polars Dataframe which I am trying to write into BigQuery. Inside the Dataframe, the col3 is stored as STRING.
How to write a dataframe to BigQuery and overwrite partition instead of the table?
I need to write a polars dataframe into a BigQuery table, that is partioned by date.