python-bigquery-dataframes icon indicating copy to clipboard operation
python-bigquery-dataframes copied to clipboard

Support JSON data type

Open jlynchMicron opened this issue 1 year ago • 2 comments

Thanks for stopping by to let us know something could be better!

PLEASE READ: If you have a support contract with Google, please create an issue in the support console instead of filing on GitHub. This will ensure a timely response.

Is your feature request related to a problem? Please describe. Described in the current source code: https://github.com/googleapis/python-bigquery-dataframes/blob/main/bigframes/dtypes.py#L83

jlynchMicron avatar Jul 02 '24 21:07 jlynchMicron

Hello @jlynchMicron , thanks for the feedback. We are actively working on JSON support, for example by adding some JSON functions to the bigframes.bigquery package (see: https://cloud.google.com/python/docs/reference/bigframes/latest/bigframes.bigquery#bigframes_bigquery_json_set).

Based on the linked issue (https://github.com/googleapis/python-bigquery/issues/1966), are you also looking for better I/O support for JSON, so that to_gbq can produce tables with JSON columns?

tswast avatar Jul 08 '24 15:07 tswast

Hello @jlynchMicron, we are getting more JSON dtype support. More details can be checked in this notebook. Please let us know if you have any further suggestions.

chelsea-lin avatar Apr 24 '25 20:04 chelsea-lin