view: int_dbt_prod_communion_tiktok_socials {
  sql_table_name: "INTELLIGENCE"."DBT_PROD"."COMMUNION_TIKTOK_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: artist_name {
    type: string
    sql: ${TABLE}.ARTIST_NAME ;;
  }

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

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

  dimension: platform {
    type: string
    sql: ${TABLE}.PLATFORM ;;
  }

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

  measure: comments {
    type: sum
    sql: ${TABLE}.COMMENTS ;;
  }

  measure: likes {
    type: sum
    sql: ${TABLE}.LIKES ;;
  }

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

  measure: favorites {
    type: sum
    sql: ${TABLE}.FAVORITES ;;
  }

  measure: shares {
    type: sum
    sql: ${TABLE}.SHARES ;;
  }

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

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

}