Base.metadata.create_all not mapping to correct data type

[Neob91]

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]

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

[mxmzdlv]

#32 adds generic types

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

[tswast]

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