view: anr_instagram_engagement {
  derived_table: {
    sql: select artist, ROUND(100 * ENGAGEMENT, 2) as "Engagement"
      from TABLE({% parameter stats_table_name %}) ;;
  }

  dimension: artist {
    type: string
    sql: ${TABLE}.ARTIST;;
  }

  dimension: instagram_engagement {
    type: number
    sql: ${TABLE}."Engagement";;
  }

  parameter: stats_table_name {
    type: string
    view_label: "Table Name"
    default_value: "FACTS.PROD.INSTAGRAM_STATISTICS"
  }
}