view: int_dbt_prod_communion_youtube_socials {
  sql_table_name: "INTELLIGENCE"."DBT_PROD"."COMMUNION_YOUTUBE_SOCIALS" ;;

  dimension: download_activity_date {
    type: date
    sql: ${TABLE}.DOWNLOAD_ACTIVITY_DATE ;;
    label: "Dataset Date"
  }

  dimension: isrc {
    type: string
    label: "ISRC"
    sql: ${TABLE}.ISRC ;;
  }

  dimension: content_type {
    type: string
    sql: ${TABLE}.CONTENT_TYPE ;;
  }

  dimension: country_code {
    type: string
    sql: ${TABLE}.COUNTRY_CODE ;;
  }

  dimension: transaction_country {
    type: string
    sql: ${TABLE}.TRANSACTION_COUNTRY ;;
  }

  measure: views {
    type: sum
    sql: ${TABLE}.VIEWS ;;
  }

  measure: creations {
    type: sum
    sql: ${TABLE}.CREATIONS ;;
  }

  measure: watch_time {
    type: sum
    value_format_name: decimal_2
    sql: ${TABLE}.WATCH_TIME ;;
  }

  dimension: trackname {
    type: string
    label: "Track Name"
    sql: ${TABLE}.TRACKNAME ;;
  }

  dimension: artistname {
    type: string
    label: "Artist Name"
    sql: ${TABLE}.ARTISTNAME ;;
  }

  }