Assets Metadata

Purpose

Provides a simplified view of asset metadata.

This model exists to translate internal currency identifiers into standardized ISO currency codes, so downstream models can work with currencies without re-implementing joins or lookup logic.

It is intentionally minimal and acts as a currency resolution layer for asset providers.

Business Logic

• Start from the Asset Providers source table
• Join each asset provider to its configured currency
• Translate internal currency IDs into ISO currency codes using the Currencies semantic contract.
• Expose a stable, reusable contract for downstream facts

Output Contract

Definitions

Sample & Implementation

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

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

currencies as (
    select * from {{ ref('currencies') }}
)

select
    asp.name as asset_provider,
    asp.id as asset_id,
    c.currency_code as currency
from assets_providers asp
left join currencies c on asp.currency_id = c.id

Dependencies

• Semantic Layers: Assets Providers and Currencies