I’m trying to develop a connector for Unleashed. The latest hurdle I am trying to overcome is that the dates are given as timestamps in the following format “/Date(1600300800000)/”. What is the best way of going about this? The idea of a custom transformation is scary, and I’m not even sure how I would go about extracting the timestamp from this string and converting it in SQL. Any help would be greatly appreciated! Thank you!

My two cents is that it might be better to just output the string as-is and do a transformation when you have put it over to the destination.

I agree with Hans. Airbyte is for transporting data (as much as possible), or general transforms like un-nesting, otherwise you end up with business logic where it doesn’t necessarily belong. However, if you have a specific reason it could be as easy as

re.findall('\d+', a)[0]

after

import re.