Skip to content

Support JSON types #546

New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

#

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Jump to bottom
Open
pythonruss opened this issue Jan 18, 2023 · 7 comments
Open

Support JSON types #546

pythonruss opened this issue Jan 18, 2023 · 7 comments
Labels
api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API. type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design.

Comments

@pythonruss
Copy link

Bigquery standard sql supports a json column type link

it is not supported as a dialect type in this package link

I'm sure many users will have a need for a nested column with no predefined schema, struct doesn't cover flexible nested records
@product-auto-label product-auto-label bot added the api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API. label Jan 18, 2023
@sachsbl
Copy link

sachsbl commented Jan 22, 2023

+1

@caffeinatedMike
Copy link

This is a need for me as well. Having to coerce column values after-the-fact (json.loads) is not obvious at first glance and shouldn't be necessary for a DB-API where the proper types are supported in the underlying DB flavor (BigQuery Standard).

@meredithslota meredithslota added the type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design. label Mar 2, 2023
@jlynchMicron
Copy link

Duplicate: #399

@mephmanx
Copy link

I also need JSON column types

@or-asher
Copy link

I also really need this feature, is there any plans to implement this soon?

@veejar
Copy link

veejar commented Apr 24, 2024

Also want to request this feature.

@Ishankoradia
Copy link

any news on this, i also need this.

# for free to join this conversation on GitHub. Already have an account? # to comment
Assignees
No one assigned
Labels
api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API. type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
9 participants
@veejar @meredithslota @pythonruss @sachsbl @caffeinatedMike @Ishankoradia @mephmanx @jlynchMicron @or-asher