When we bring Oracle table to BQ via datastream it converts number column to string?

Below is an example. One column retains as Integer and other converted to String. Can this be fixed?
Number and Number (1,0) makes what difference? 

yoghee_0-1702531055543.png

 

0 1 160
1 REPLY 1

It looks like datastream/BQ cant detect the number data type as INT if it does not have precision and scale parameters. You can report this issue to Google's public tracker here: https://cloud.google.com/support/docs/issue-trackers or file a support case here: https://cloud.google.com/contact

One possible workaround I can see is placing max values to precision and scale instead of leaving it as default.