Product Info Latest

product_info_latest.sql

WITH product_info AS (
    SELECT
        ROW_NUMBER() over (
            PARTITION BY product_id
            ORDER BY
                __event_ts DESC
        ) AS row_rank,*
    FROM
        {{ ref('src_product_management_product_history') }}
)
SELECT
    *
FROM
    product_info
WHERE
    row_rank = 1
ORDER BY
    product_id