I’m following the “Implement Datastream and Dataflow for analytics” guide to set up data replication from a Postgres database into Bigquery.
https://cloud.google.com/datastream/docs/implementing-datastream-dataflow-analytics
This is mostly working well, but one issue we have come across is that all columns on the bigquery side appear to be converted to a String datatype, ignoring the original postgres datatype in the source.
Has anyone else come across this, or can suggest a possible solution? Thanksyou.