Hi Team, I am trying to sync CSV file form S3 sour...
# advice-data-transformation
k
Hi Team, I am trying to sync CSV file form S3 source to bigquery destination. I want to change a column type from int to string. Here is the option i added to the additional reader options
{"column_types": {"otherrefnum", "pa.string()"}}
note: otherrefnum is the column name which is in int. I want to know whether the syntax is right to do the transformation. Can someone help pls?
a
Hey @Kabilan Ravi do you mind posting this question on our troubleshooting forum if you need help from our community support team?
1