vvgsrk

WITH source AS (
    SELECT
        *
    FROM
        {{ source(
            'product_management',
            'product_history'
        ) }}
),
renamed AS (

vvgsrk

{#
- this macro creates incremental tables based
ON history DATA - it uses is_incremental() macro TO wrap valid SQL that filters THE rows - Filter will ONLY be applied
ON an incremental run - it uses unique_key PARAMETER which ensures THE existing ROW IS updated IN target TABLE #}

{%- macro generate_row_rank_using_event_ts_incremental(model, keycolumn) -%}
    
    {%- set columns = adapter.get_columns_in_relation(model) -%}
    {{ config(materialized = var('incremental'), unique_key = '__uuid') }}

vvgsrk

{%- 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,
    *

vvgsrk

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') }}
)

vvgsrk

wsl --install -d Ubuntu-20.04

vvgsrk

sudo rm /etc/resolv.conf
sudo bash -c 'echo "nameserver 8.8.8.8" > /etc/resolv.conf'
sudo bash -c 'echo "[network]" > /etc/wsl.conf'
sudo bash -c 'echo "generateResolvConf = false" >> /etc/wsl.conf'
sudo chattr +i /etc/resolv.conf

vvgsrk

sudo apt-get update
sudo apt-get upgrade

vvgsrk

wsl --set-default-version 2

vvgsrk

dism.exe /online /enable-feature /featurename:VirtualMachinePlatform /all /norestart

vvgsrk

dism.exe /online /enable-feature /featurename:Microsoft-Windows-Subsystem-Linux /all /norestart