convert unix timestamp

[jthandy]

this works for redshift:

{% macro convert_unix_timesetamp(field_name) -%}
timestamp 'epoch' + {{field_name}} * interval '1 second'
{%- endmacro %}

would be great to have a cross-database compatible version.

[devrang]

Above micro will not work in redshift. this worked for me:
{% macro convert_unix_timestamp(field_name) -%}
timestamp 'epoch' + {{field_name}}/1000 * interval '1 second'
{%- endmacro %}

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

[github-actions]

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment to notify the maintainers.

[Kalidaas23]

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")}}