Payer

ComponentSchema

-- 🪟💲🌟
-- run_id: {{ run_id }}
-- task_name: {{ task_name }}
-- Table: {{ schema_name }}.prod_rollup_payer

{% set rollup_cols_in_abridged = [
    'payer_id', 
    'payer_name'
] %}

CREATE TABLE IF NOT EXISTS {{ schema_name }}.prod_rollup_payer 
AS
WITH
df AS (
    SELECT 
        p.payer_id,
        p.payer_name,
        {% for col in cld_params.views.PAYER_DETAIL_COLUMNS %}
            {% if col not in rollup_cols_in_abridged and col not in cld_params.views.ROLLUP_COLUMNS %}
                MIN(p.{{ col }}) as {{ col }},
            {% endif %}
        {% endfor %}
        {{ cld_params.views.ROLLUP_STATS }}
    FROM {{ schema_name }}.prod_combined_all p
    WHERE p.payer_name IS NOT NULL
    GROUP BY 1,2
)
SELECT 
    {% for col in cld_params.views.PAYER_DETAIL_COLUMNS %}
    {{ col }}{% if not loop.last %}, {% endif %}
    {% endfor %}
FROM df