Searches

view: searches {
  sql_table_name: public.searches ;;

  dimension: search_id {
    primary_key: yes
    sql: ${TABLE}.search_id ;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension: with_clicks {
    type: yesno
    sql: ${TABLE}.with_clicks ;;
  }

  dimension: with_results {
    type: yesno
    sql: ${TABLE}.with_results ;;
  }

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

  measure: average_response_time_ms {
    type: average
    sql: ${response_time_ms} ;;
  }

  measure: count_users {
    type: count_distinct
    sql: ${user_id} ;;
  }

  measure: count {
    type: count
  }
}

- view: searches
  sql_table_name: public.searches
  fields:
  - dimension: search_id
    primary_key: true
    sql: ${TABLE}.search_id
  - dimension: advanced_query_expression
    sql: ${TABLE}.advanced_query_expression
  - dimension: batch_id
    sql: ${TABLE}.batch_id
  - dimension: cause
    sql: ${TABLE}.cause
  - dimension: custom_metadata_1
    sql: ${TABLE}.custom_metadata_1
  - dimension: custom_metadata_2
    sql: ${TABLE}.custom_metadata_2
  - dimension: custom_metadata_3
    sql: ${TABLE}.custom_metadata_3
  - dimension: custom_metadata_4
    sql: ${TABLE}.custom_metadata_4
  - dimension: custom_metadata_5
    sql: ${TABLE}.custom_metadata_5
  - dimension: origin_city
    sql: ${TABLE}.origin_city
  - dimension: origin_country
    sql: ${TABLE}.origin_country
  - dimension: origin_device
    sql: ${TABLE}.origin_device
  - dimension: origin_language
    sql: ${TABLE}.origin_language
  - dimension: origin_region
    sql: ${TABLE}.origin_region
  - dimension: page_number
    type: number
    sql: ${TABLE}.page_number
  - dimension: page_size
    type: number
    sql: ${TABLE}.page_size
  - dimension: query_expression
    sql: ${TABLE}.query_expression
  - dimension: response_time_ms
    type: int
    sql: ${TABLE}.response_time_ms
  - dimension: search_origin_level_1
    sql: ${TABLE}.search_origin_level_1
  - dimension: search_origin_level_2
    sql: ${TABLE}.search_origin_level_2
  - dimension: search_origin_level_3
    sql: ${TABLE}.search_origin_level_3
  - dimension: user_agent
    sql: ${TABLE}.user_agent
  - dimension: user_id
    sql: ${TABLE}.user_id
  - dimension: user_name
    sql: ${TABLE}.user_name
  - dimension: visit_id
    sql: ${TABLE}.visit_id
  - dimension: with_clicks
    type: yesno
    sql: ${TABLE}.with_clicks
  - dimension: with_results
    type: yesno
    sql: ${TABLE}.with_results
  - dimension_group: search
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.datetime
  - measure: average_response_time_ms
    type: average
    sql: ${response_time_ms}
  - measure: count_users
    type: count_distinct
    sql: ${user_id}
  - measure: count
    type: count