I think you can use this query directly to get the desired results:
select *, timestamp 'epoch' + unixdate::INT * INTERVAL '1 second' as test from {{ source("yourmodel","table_name")}}