it has been awhile since ive been active on this slack, where would be the best place to look for transforming data from a source connector before it is sent to a destination? can Airbyte do data transformations like this?

There are some small transfomartions you can apply: https://docs.airbyte.com/connector-development/cdk-python/schemas#custom-schema-type-transformation