Course

view: course {
  sql_table_name: javaprod.course ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
  }
}

- view: course
  sql_table_name: javaprod.course
  fields:
  - dimension: course_id
    type: int
    primary_key: true
    sql: ${TABLE}.course_id
  - dimension: active_test_key
    sql: ${TABLE}.active_test_key
  - dimension: archived_in_s3
    type: yesno
    sql: ${TABLE}.archived_in_s3
  - dimension: attask_id
    sql: ${TABLE}.attask_id
  - dimension: base_promotional_offer_id
    type: int
    sql: ${TABLE}.base_promotional_offer_id
  - dimension: brief_url
    sql: ${TABLE}.brief_url
  - dimension: course_description
    sql: ${TABLE}.course_description
  - dimension: course_description_plain
    sql: ${TABLE}.course_description_plain
  - dimension: course_materials_formatted
    sql: ${TABLE}.course_materials_formatted
  - dimension: course_materials_plain
    sql: ${TABLE}.course_materials_plain
  - dimension: course_name
    sql: ${TABLE}.course_name
  - dimension: course_state
    sql: ${TABLE}.course_state
  - dimension: course_summary
    sql: ${TABLE}.course_summary
  - dimension: course_trailer_video_shahash
    sql: ${TABLE}.course_trailer_video_shahash
  - dimension: default_site_id
    type: int
    sql: ${TABLE}.default_site_id
  - dimension: estimated_enrollment
    type: number
    sql: ${TABLE}.estimated_enrollment
  - dimension: featured
    type: yesno
    sql: ${TABLE}.featured
  - dimension: highlights
    sql: ${TABLE}.highlights
  - dimension: include_in_transcode_check
    type: yesno
    sql: ${TABLE}.include_in_transcode_check
  - dimension: location
    sql: ${TABLE}.location
  - dimension: main_image_alt
    sql: ${TABLE}.main_image_alt
  - dimension: never_released
    type: yesno
    sql: ${TABLE}.never_released
  - dimension: obj_version
    type: int
    sql: ${TABLE}.obj_version
  - dimension: product_id
    type: int
    hidden: true
    sql: ${TABLE}.product_id
  - dimension: related_courses
    sql: ${TABLE}.related_courses
  - dimension: seo_description
    sql: ${TABLE}.seo_description
  - dimension: seo_keywords
    sql: ${TABLE}.seo_keywords
  - dimension: seo_name
    sql: ${TABLE}.seo_name
  - dimension: short_summary
    sql: ${TABLE}.short_summary
  - dimension: size
    sql: ${TABLE}.size
  - dimension: skill_level
    type: int
    sql: ${TABLE}.skill_level
  - dimension: storage_type
    sql: ${TABLE}.storage_type
  - dimension: student_only
    type: yesno
    sql: ${TABLE}.student_only
  - dimension: sub_classification
    sql: ${TABLE}.sub_classification
  - dimension: sub_title
    sql: ${TABLE}.sub_title
  - dimension: title
    sql: ${TABLE}.title
  - dimension: transcript_job_id
    type: int
    sql: ${TABLE}.transcript_job_id
  - dimension: uploaded_in_s3
    type: yesno
    sql: ${TABLE}.uploaded_in_s3
  - dimension: url_name
    sql: ${TABLE}.url_name
  - dimension: video_id
    sql: ${TABLE}.video_id
  - dimension: volume
    sql: ${TABLE}.volume
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created
  - dimension_group: end
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.end_date
  - dimension_group: last_modified
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.last_modified
  - dimension_group: shoot
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.shoot_date
  - dimension_group: start
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.start_date
  - dimension_group: vault_toggle
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.vault_toggle_date
  - measure: count
    type: count