Meltano

is there an established way to handle PostGIS data in a PostgreSQL database? I'd like to convert a column of type Point to a pair of Lat and Lon

to clarify: postgres is my tap, and I'd like the Lat Lon to show up in my bigquery target

A fascinating problem. Can you say a bit more on how the data is arriving today?

I have manually set the schema. all columns which have types not supported by bigquery are forced to be of type `null, boolean`. and then I ensure data in those columns are not included in the data transfer (so it's always null)

I CAN of course add columns in my source database - but I'd prefer not to change the production database just to get some nicer fields in elt