Generate row rank using event timestamp

generate_row_rank_using_event_ts.sql

{%- macro generate_row_rank_using_event_ts(model, keycolumn) -%}
{%- set columns = adapter.get_columns_in_relation(model) -%}
WITH latest_data_changes AS
(
SELECT
    ROW_NUMBER() OVER (
        PARTITION BY {{ keycolumn }}  
        ORDER BY __event_ts DESC
    ) AS row_rank,
    *
  FROM {{ model }}
)
SELECT
{% for column in columns %}
    "{{ column.name }}"{% if not loop.last -%}, 
    {% endif -%}
{%- endfor %}
  FROM latest_data_changes
 WHERE row_rank = 1
{% endmacro %}