connection: "accounting_aggregates"

persist_for: "10 hours"

include: "*.view"
include: "*.set"

label: "Metadata"

explore: bi_release_with_metadata_view {
  label: "Release-Level Metadata"
  hidden: yes
  join: sets {}
  join: dim_imprint {
    sql_on: bi_release_with_metadata_view.imprint_id = dim_imprint.imprintid ;;
    relationship: many_to_one
    fields: [dim_imprint.date_created_date]
  }
  join: bi_track_view {
    sql_on: ${bi_release_with_metadata_view.upc} = ${bi_track_view.upc} ;;
    relationship: many_to_one
    fields: [sets.manual_track_view_fields*]
  }

  join: bi_track_artists_by_track_id {
    sql_on: bi_track_view.track_unique_id = bi_track_artists_by_track_id.track_id ;;
    relationship: one_to_one
    fields: [bi_track_artists_by_track_id.track_artists_and_type, bi_track_artists_by_track_id.track_artist]
  }
  join: production_dim_catalog {
    sql_on: ${bi_release_with_metadata_view.release_catalog_id} = ${production_dim_catalog.catalog_id} ;;
    relationship: many_to_one
    fields: [production_dim_catalog.main_fields*, -production_dim_catalog.catalog_id]
  }
}

explore: bi_track_view {
  label: "Track-Level Metadata"
  hidden: yes
  join: sets {}
  join: bi_release_with_metadata_view {
    sql_on: bi_track_view.upc = bi_release_with_metadata_view.releaseid ;;
    relationship: many_to_one
  }
  join: dim_imprint {
    sql_on: bi_release_with_metadata_view.imprint_id = dim_imprint.imprintid ;;
    relationship: many_to_one
    fields: [dim_imprint.date_created_date, dim_imprint.imprint_id]
  }
  join: production_dim_catalog {
    sql_on: ${bi_release_with_metadata_view.release_catalog_id} = ${production_dim_catalog.catalog_id} ;;
    relationship: many_to_one
    fields: [production_dim_catalog.main_fields*, -production_dim_catalog.catalog_id]
  }
}