Skip to content

DBT: Snapshot Run Results

DBT model name: snapshot_run_results

Explore dependencies/lineage: link

Description

Run results of dbt snapshots, enriched with snapshots metadata. Each row is the result of a single snapshot. This is a view that joins data from dbt_run_results and dbt_snapshots.

Details

Column Type Description

No data tests defined 🧐

Models

Models

No called script or script source not found.

{{ config(materialized="view", bind=False) }}

with
    dbt_run_results as (select * from {{ ref("dbt_run_results") }}),

    dbt_snapshots as (select * from {{ ref("dbt_snapshots") }})

select
    run_results.model_execution_id,
    run_results.unique_id,
    run_results.invocation_id,
    run_results.query_id,
    run_results.name,
    run_results.generated_at,
    run_results.status,
    run_results.full_refresh,
    run_results.message,
    run_results.execution_time,
    run_results.execute_started_at,
    run_results.execute_completed_at,
    run_results.compile_started_at,
    run_results.compile_completed_at,
    run_results.compiled_code,
    run_results.adapter_response,
    run_results.thread_id,
    run_results.group_name,
    model_snapshots.database_name,
    model_snapshots.schema_name,
    coalesce(
        run_results.materialization, model_snapshots.materialization
    ) as materialization,
    model_snapshots.tags,
    model_snapshots.package_name,
    model_snapshots.path,
    model_snapshots.original_path,
    model_snapshots.owner,
    model_snapshots.alias
from dbt_run_results run_results
join dbt_snapshots model_snapshots on run_results.unique_id = model_snapshots.unique_id