dbt-data-reliability/macros/utils/cross_db_utils/to_char.sql at d0fb760d664977a03a89ec0465d4feae22caf0f5 · elementary-data/dbt-data-reliability · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
{% macro edr_to_char(column, format) -%}
    {{ return(adapter.dispatch("edr_to_char", "elementary")(column, format)) }}
{%- endmacro %}

{# Snowflake and Redshift/Postgres #}
{% macro default__edr_to_char(column, format) %}
    to_char({{ column }}
    {%- if format %}, '{{ format }}')
    {%- else %}, 'YYYY-MM-DD HH:MI:SS')
    {%- endif %}
{% endmacro %}

{% macro bigquery__edr_to_char(column, format) %}
    cast({{ column }} as string
    {%- if format %} format '{{ format }}')
    {%- else %})
    {%- endif %}
{% endmacro %}

{% macro spark__edr_to_char(column, format) %}
    date_format({{ column }}
    {%- if format %}, '{{ format }}')
    {%- else %}, 'YYYY-MM-DD HH:MI:SS')
    {%- endif %}
{% endmacro %}

{% macro fabricspark__edr_to_char(column, format) %}
    {{ return(elementary.spark__edr_to_char(column, format)) }}
{% endmacro %}

{% macro fabric__edr_to_char(column, format) %}
    convert(varchar, {{ column }}
    {%- if format %}, {{ format }})
    {%- else %}, 120)
    {%- endif %}
{% endmacro %}