Hi, can I user custom python code for transformation in between source and destination?

you can apply transformation when pulling data from your source see here: https://docs.airbyte.com/connector-development/cdk-python/schemas#type-transformation or using dbt with custom normalization