get_positions.sql

-- INCLUDE DESCRIPTION HERE TO DESCRIBE MACRO FILE --

{%- macro get_position(position, by_column_name, from_column_name) -%}

        {{ position }}_VALUE({{ from_column_name }} IGNORE NULLS) OVER (
            PARTITION BY {{ by_column_name }}
            ORDER BY
                event_timestamp ROWS BETWEEN UNBOUNDED PRECEDING
                AND UNBOUNDED FOLLOWING
        )

{%- endmacro -%}


{%- macro get_first(by_column_name, from_column_name) -%}

        FIRST_VALUE({{ from_column_name }} IGNORE NULLS) OVER (
            PARTITION BY {{ by_column_name }}
            ORDER BY
                event_timestamp ROWS BETWEEN UNBOUNDED PRECEDING
                AND UNBOUNDED FOLLOWING
        )

{%- endmacro -%}


{%- macro get_last(by_column_name, from_column_name) -%}

        LAST_VALUE({{ from_column_name }} IGNORE NULLS) OVER (
            PARTITION BY {{ by_column_name }}
            ORDER BY
                event_timestamp ROWS BETWEEN UNBOUNDED PRECEDING
                AND UNBOUNDED FOLLOWING
        )

{%- endmacro -%}