Title
#advice-data-transformation
Kabilan Ravi

Kabilan Ravi

06/08/2022, 1:39 PM
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?
Augustin Lafanechere (Airbyte)

Augustin Lafanechere (Airbyte)

06/14/2022, 5:44 PM
Hey @Kabilan Ravi do you mind posting this question on our troubleshooting forum if you need help from our community support team?