https://linen.dev logo
#ask-community-for-troubleshooting
Title
# ask-community-for-troubleshooting
a

Anand

03/17/2022, 5:05 AM
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!
👀 1
h

Harshith (Airbyte)

03/17/2022, 5:36 AM
Hey you can use custom DBT to do this
a

Anand

03/17/2022, 6:21 AM
Could you please point me to some links/docs for the same ?
a

Anand

03/17/2022, 9:08 AM
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 !
m

Marcos Marx (Airbyte)

03/18/2022, 2:09 AM
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.
a

Anand

03/18/2022, 9:16 AM
Thanks @Marcos Marx (Airbyte)