Skip to content

Base.metadata.create_all not mapping to correct data type #31

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
Closed
Neob91 opened this issue Dec 13, 2018 · 3 comments
Closed

Base.metadata.create_all not mapping to correct data type #31

Neob91 opened this issue Dec 13, 2018 · 3 comments
Labels
type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design.

Comments

@Neob91
Copy link

Neob91 commented Dec 13, 2018

Hello,

I'm trying to create tables in bigquery using Base.metadata.create_all(engine), however what I'm getting is:

google.cloud.bigquery.dbapi.exceptions.DatabaseError: 400 GET https://www.googleapis.com/bigquery/v2/projects/REDACTED/queries/REDACTED?maxResults=0&location=US: Type not found: INTEGER at [3:15]

Looks like sqlalchemy columns aren't correctly mapped to the BigQuery SQL data type names.
Any suggestions?
@mxmzdlv
Copy link
Contributor

mxmzdlv commented Dec 13, 2018

Currently we only support select statements. Basic DML (insert, update) should work too, although it is not tested thoroughly.

@mxmzdlv
Copy link
Contributor

mxmzdlv commented Dec 21, 2018

#32 adds generic types

We are still missing ARRAY and STRUCT, but tables with generic types can be created now.

@tswast tswast mentioned this issue Jun 28, 2019
Closed
@tswast tswast added the type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design. label Jun 28, 2019
@tswast
Copy link
Collaborator

tswast commented Jun 28, 2019

Closing in favor of #37 to track STRUCT and ARRAY support.

@tswast tswast closed this as completed Jun 28, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
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
3 participants
@tswast @Neob91 @mxmzdlv