Skip to content
New issue

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

Sign up for GitHub

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

Already on GitHub? Sign in to your account

Jump to bottom

Support for struct types #454

Open
laughingman7743 opened this issue Jun 27, 2023 · 5 comments
Open

Support for struct types #454

laughingman7743 opened this issue Jun 27, 2023 · 5 comments

Comments

@laughingman7743
Copy link
Owner

https://github.com/googleapis/python-bigquery-sqlalchemy/blob/main/sqlalchemy_bigquery/_struct.py
@laughingman7743 laughingman7743 changed the title Support for structure types Support for struct types Jun 29, 2023
@yuvi17
Copy link

yuvi17 commented Oct 8, 2023

Does this mean we can use STRUCT from BigQuery to construct Table() in pyathena and run queries on them?
@laughingman7743 ?

@yuvi17
Copy link

yuvi17 commented Oct 8, 2023

Or is this issue for an implementation similar to this?

@laughingman7743
Copy link
Owner Author

https://docs.aws.amazon.com/athena/latest/ug/data-types.html
Athena has Struct as a data type, and BigQuery's implementation of the Struct type should be helpful in implementing support for it.

@yuvi17
Copy link

yuvi17 commented Oct 8, 2023

Thanks @laughingman7743
I will try it out and post the results here. Might be helpful for others

@thezachdrake
Copy link

Following up on this. Has anyone been able to use structs?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@laughingman7743 @yuvi17 @thezachdrake