Hi , I am trying to connect to salesforce as source and redshift as destination. As part of transformation, is there a way to add a new field into destination table - For example, Accounts table is having Col A, Col B, Col C. I would like to add a Calculated Col D getting added to Accounts [ Col D could be a result of set of computations from external source like a python/java ] . I was exploring with DBT option, but couldn't find any good example with the same. ! Any assistance you can provide would be greatly appreciated!

Hey you can use custom DBT to do this

Could you please point me to some links/docs for the same ?

Here https://docs.airbyte.com/operator-guides/transformation-and-normalization

hi harshith, thanks for sharing. Looks like DBT supports mostly on the SQL front - couldn't find any option to invoke external services from DBT. Not sure whether it is in scope of DBT or not as well ! Any idea on that front ! I understand that it cannot be direct question to you regarding this , but any help on this is much appreciated !

It’s not possible using Airbyte today this @Anand. Maybe one solution is: sync data from salesforce to redshift and trigger a operator dag with airflow to create the column D.

Thanks @Marcos Marx (Airbyte)