view: int_dbt_prod_transaction_type_group {
  sql_table_name: intelligence.dbt_prod_seed_data.transaction_type_group ;;

  dimension: transactiontypeid {
    type: number
    sql: ${TABLE}.transactiontypeid ;;
    primary_key: yes
    hidden: yes
  }

  dimension: transaction_detail {
    type: string
    sql: ${TABLE}.transaction_detail ;;
    label: "Transaction Group (Detail)"
    description: "Organizes Transaction Types into ten categories: Audio Streaming, Non-Interactive Streaming, Video Streaming, Track Downloads, Album Downloads, Physical, Performance Rights, Sync, UGC Matches, and Other"
  }

  dimension: transaction_group {
    type: string
    sql: ${TABLE}.transaction_group ;;
    description: "Organizes Transaction Types into four categories: Streaming, Downloads, Physical, and Other"
  }
}