This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Datastream to BigQuery Converts all columns to datatype string

Posted on 11-22-2022 04:06 PM
gthomas-strike
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

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.

0 1 150
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
ErnestoC
Staff
Reply posted on --/--/---- --:-- AM

Can you please include the PostreSQL version of your database; in addition, if possible, examples of the fields that are automatically changed to `String` data type?

0 Likes