googleapis / googleapis/google-cloud-python

Support JSON data type

Abierto
#14,477 3 comentarios 3 reacciones 1 asignado Reclamado por @chelsea-lin Ver en GitHub
api: bigquery type: feature request
Lenguaje dominante
Python
Estrellas
5.4k
Forks
1.8k
Merge medio
3 d 4 h
PR fusionados (30 d)
122

Descripción

First of all: Thank you for maintaining this project, it really is a nice addition to pandas!

**Is your feature request related to a problem? Please describe.**
GBQ supports[ the JSON data type](https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types#orderable_data_types), but unfortunately pandas-gbq doesn't allow writing (and I believe reading) from a table that features a JSON data type column.

**Describe the solution you'd like**
1. Add support for both reading and writing dataframes that feature JSON columns.
2. Add support for manually specifying JSON columns in the table schema.

**Describe alternatives you've considered**
Alternatives are:
* writing data as a string and then loading it as a JSON inside a SQL query to access its key-values
* the downside here is that the json object can't be used for early query processing, introducing the conversion overhead
* using the native google.cloud.bigquery module

Guía de contribución

Abrir la guía de contribución

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.