Harshith (Airbyte)
file
connection. There is a number
field in the csv data and when we are pushing to bigquery
this is taken as null. can someone help me with this ?user
04/07/2021, 5:17 PMnumber
field in the configuration for your CSV file source?user
04/07/2021, 5:17 PMuser
04/07/2021, 5:34 PMuser
04/07/2021, 5:42 PMuser
04/07/2021, 5:42 PMuser
04/07/2021, 5:49 PMuser
04/07/2021, 5:49 PMuser
04/07/2021, 5:50 PMuser
04/07/2021, 5:52 PMuser
04/07/2021, 5:56 PMuser
04/07/2021, 5:58 PMuser
04/07/2021, 5:58 PMuser
04/07/2021, 6:03 PMuser
04/07/2021, 6:04 PMuser
04/07/2021, 6:07 PM{'key':100}
because it thinks it’s producing a number. Then at the destination and normalization level it’s getting a catalog with string
and within normalization it isn’t actually receiving the correct value and doesn’t cast automatically.user
04/07/2021, 6:13 PMuser
04/07/2021, 6:14 PMsource-file
look at the catalog it is provided and cast the records it produces for a stream to the type specified.user
04/07/2021, 6:18 PMuser
04/07/2021, 6:20 PMuser
04/07/2021, 6:20 PMuser
04/07/2021, 6:43 PM