Action Alert Contents

view: action_alert_contents {
  sql_table_name: public.action_alert_contents ;;

  dimension: id {
    type: int
    primary_key: yes
    sql: ${TABLE}.id ;;
  }

  dimension: ab_selected {
    type: number
    sql: ${TABLE}.ab_selected ;;
  }

  dimension: ab_selected_percentage {
    type: int
    sql: ${TABLE}.ab_selected_percentage ;;
  }

  dimension: ab_testing {
    type: number
    sql: ${TABLE}.ab_testing ;;
  }

  dimension: action_alert_template_id {
    type: int
    hidden: yes
    sql: ${TABLE}.action_alert_template_id ;;
  }

  dimension: action_alert_user_grouping_id {
    type: int
    hidden: yes
    sql: ${TABLE}.action_alert_user_grouping_id ;;
  }

  dimension: action_url {
    sql: ${TABLE}.action_url ;;
  }

  dimension: alternate_photo_id {
    type: int
    sql: ${TABLE}.alternate_photo_id ;;
  }

  dimension: button_text {
    sql: ${TABLE}.button_text ;;
  }

  dimension: description {
    sql: ${TABLE}.description ;;
  }

  dimension: event_id {
    type: int
    hidden: yes
    sql: ${TABLE}.event_id ;;
  }

  dimension: from_column {
    sql: ${TABLE}.from_column ;;
  }

  dimension: hwm_data {
    sql: ${TABLE}.hwm_data ;;
  }

  dimension: hwm_field {
    sql: ${TABLE}.hwm_field ;;
  }

  dimension: locale {
    sql: ${TABLE}.locale ;;
  }

  dimension: num_ab_test_recipients {
    type: int
    sql: ${TABLE}.num_ab_test_recipients ;;
  }

  dimension: plaintext_description {
    sql: ${TABLE}.plaintext_description ;;
  }

  dimension: scheduled_action_alert_id {
    type: int
    hidden: yes
    sql: ${TABLE}.scheduled_action_alert_id ;;
  }

  dimension: sidebar_callout {
    sql: ${TABLE}.sidebar_callout ;;
  }

  dimension: skip_callout {
    type: number
    sql: ${TABLE}.skip_callout ;;
  }

  dimension: subject {
    sql: ${TABLE}.subject ;;
  }

  dimension: user_generated_content {
    type: number
    sql: ${TABLE}.user_generated_content ;;
  }

  dimension_group: created {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.created_at ;;
  }

  dimension_group: extracted_at_utc {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.extracted_at_utc ;;
  }

  measure: count {
    type: count
  }
}

- view: action_alert_contents
  sql_table_name: public.action_alert_contents
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: ab_selected
    type: number
    sql: ${TABLE}.ab_selected
  - dimension: ab_selected_percentage
    type: int
    sql: ${TABLE}.ab_selected_percentage
  - dimension: ab_testing
    type: number
    sql: ${TABLE}.ab_testing
  - dimension: action_alert_template_id
    type: int
    hidden: true
    sql: ${TABLE}.action_alert_template_id
  - dimension: action_alert_user_grouping_id
    type: int
    hidden: true
    sql: ${TABLE}.action_alert_user_grouping_id
  - dimension: action_url
    sql: ${TABLE}.action_url
  - dimension: alternate_photo_id
    type: int
    sql: ${TABLE}.alternate_photo_id
  - dimension: button_text
    sql: ${TABLE}.button_text
  - dimension: description
    sql: ${TABLE}.description
  - dimension: event_id
    type: int
    hidden: true
    sql: ${TABLE}.event_id
  - dimension: from_column
    sql: ${TABLE}.from_column
  - dimension: hwm_data
    sql: ${TABLE}.hwm_data
  - dimension: hwm_field
    sql: ${TABLE}.hwm_field
  - dimension: locale
    sql: ${TABLE}.locale
  - dimension: num_ab_test_recipients
    type: int
    sql: ${TABLE}.num_ab_test_recipients
  - dimension: plaintext_description
    sql: ${TABLE}.plaintext_description
  - dimension: scheduled_action_alert_id
    type: int
    hidden: true
    sql: ${TABLE}.scheduled_action_alert_id
  - dimension: sidebar_callout
    sql: ${TABLE}.sidebar_callout
  - dimension: skip_callout
    type: number
    sql: ${TABLE}.skip_callout
  - dimension: subject
    sql: ${TABLE}.subject
  - dimension: user_generated_content
    type: number
    sql: ${TABLE}.user_generated_content
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: extracted_at_utc
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.extracted_at_utc
  - measure: count
    type: count