Question:
Is it possible to use array and JSON data types with BigQuery connected as an external database?
Product:
WixEditor, CMS
What are you trying to achieve:
I need additional storage beyond Wix’s 10K lines (horrible btw), so I’m turning to BigQuery. It was easy enough to set up, but I’m encountering an issue where Wix and BigQuery are not properly communicating field types. For example, an array set up in BigQuery is being read as a text field by Wix. Saving items with array values to BigQuery does work despite the mismatch; however, JSON fields are another story entirely. They just won’t work at all. Wix reads them and treats them as text and will not send the data in a JSON encoded format. It’s unbelievably frustrating. Any workarounds?
What have you already tried:
I’ve gone through BigQuery docs, Wix docs, etc. Seems like a solution is to ditch using CMS and go direct through google, but that’s not a nice solution.