Feature description

Support for GEOGRAPHY data type at the BigQuery destination

Are you a dlt user?

I'd consider using dlt, but it's lacking a feature I need.

Use case

Typical case is to load PostGIS's geo column into BigQuery to be recognized as a GEOGRAPHY in BigQuery. Nowadays dlt loads such columns as a STRING type. You may enforce GEOGRAPHY type casting with custom scripting around, but it would be cool to have this out-of-the-box.

Proposed solution

Recognize geo-types and load them into BigQuery as a GEOGRAPHY automatically.

Related issues

No response