Assets Values

Purpose

Provide a fully enriched, time-aware view of assets, combining asset metadata with their corresponding dated values.

This model joins asset-level amounts to their provider and currency context, producing a ready-to-use dataset for reporting, aggregation, and downstream financial analysis.

It serves as the asset fact view, avoiding repeated joins between asset values and metadata across the stack.

Business Logic

• Start from the Assets Metadata transformations
• Join asset metadata to Assets value facts by asset_id
• Derive ISO week number from the asset date
• Normalize missing asset values to zero

Output Contract

Definitions

Sample & Implementation

{{config(materialized='view')}}

with assets_metadata as (
    select * from {{ ref ('assets_metadata') }}
),

asset_values as (
    select * from {{ref ('assets')}}
)

select
    av.date,
    EXTRACT(ISOYEAR from av.date) * 100 + EXTRACT(WEEK from av.date) as weeknum,
    am.asset_provider,
    am.asset_id,
    am.currency,
    COALESCE(av.amount,0) as amount,
from assets_metadata am
left join asset_values av on av.asset_id = am.asset_id
order by av.date, am.asset_id

Dependencies

• Transformations: Assets Metadata
• Facts: Assets