data.ml
LookML Social network sport

Link

Link model for social network sport.

source-preserved

Blocks

link.view.lkml · 185 lines
inferred 
view: link {
  sql_table_name: Link ;;

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

  dimension: assessment {
    sql: ${TABLE}.Assessment ;;
  }

  dimension: athlete_name {
    sql: ${TABLE}.AthleteName ;;
  }

  dimension: athletic_association {
    type: int
    sql: ${TABLE}.AthleticAssociation ;;
  }

  dimension: bench_press_reps_high_school {
    type: int
    sql: ${TABLE}.BenchPressRepsHighSchool ;;
  }

  dimension: broad_jump {
    type: int
    sql: ${TABLE}.BroadJump ;;
  }

  dimension: coached_by_shared_user_id {
    type: int
    sql: ${TABLE}.CoachedBySharedUserId ;;
  }

  dimension: forty_yard_dash {
    type: number
    sql: ${TABLE}.FortyYardDash ;;
  }

  dimension: is_hidden_from_search {
    sql: ${TABLE}.IsHiddenFromSearch ;;
  }

  dimension: lane_agility_drill {
    type: number
    sql: ${TABLE}.LaneAgilityDrill ;;
  }

  dimension: link_athlete_type {
    type: yesno
    sql: ${TABLE}.LinkAthleteType ;;
  }

  dimension: link_code {
    sql: ${TABLE}.LinkCode ;;
  }

  dimension: link_code_last_sent_to_email {
    sql: ${TABLE}.LinkCodeLastSentToEmail ;;
  }

  dimension: link_code_last_sent_to_phone_number {
    sql: ${TABLE}.LinkCodeLastSentToPhoneNumber ;;
  }

  dimension: link_for_organization_id {
    type: int
    sql: ${TABLE}.LinkForOrganizationId ;;
  }

  dimension: link_for_profile_id {
    type: int
    sql: ${TABLE}.LinkForProfileId ;;
  }

  dimension: link_status {
    type: yesno
    sql: ${TABLE}.LinkStatus ;;
  }

  dimension: max_velocity {
    type: int
    sql: ${TABLE}.MaxVelocity ;;
  }

  dimension: mile_time {
    type: int
    sql: ${TABLE}.MileTime ;;
  }

  dimension: pop_time {
    type: number
    sql: ${TABLE}.PopTime ;;
  }

  dimension: projected_competition_level {
    type: int
    sql: ${TABLE}.ProjectedCompetitionLevel ;;
  }

  dimension: promotional_cover_letter {
    sql: ${TABLE}.PromotionalCoverLetter ;;
  }

  dimension: shuttle20_yard {
    type: number
    sql: ${TABLE}.Shuttle20Yard ;;
  }

  dimension: shuttle60_yard {
    type: number
    sql: ${TABLE}.Shuttle60Yard ;;
  }

  dimension: shuttle_run {
    type: number
    sql: ${TABLE}.ShuttleRun ;;
  }

  dimension: sixty_yard_dash {
    type: number
    sql: ${TABLE}.SixtyYardDash ;;
  }

  dimension: sport_enum {
    type: int
    sql: ${TABLE}.SportEnum ;;
  }

  dimension: standing_vertical {
    type: number
    sql: ${TABLE}.StandingVertical ;;
  }

  dimension: team_state {
    sql: ${TABLE}.TeamState ;;
  }

  dimension: three_cone_drill {
    type: number
    sql: ${TABLE}.ThreeConeDrill ;;
  }

  dimension: three_quarter_sprint {
    type: number
    sql: ${TABLE}.ThreeQuarterSprint ;;
  }

  dimension: vertical_jump {
    type: int
    sql: ${TABLE}.VerticalJump ;;
  }

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

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

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

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

  measure: count {
    type: count
    drill_fields: [link_id, athlete_name, linkbackup.count]
  }
}
link.view.lookml · 130 lines
source-preserved 
- view: link
  sql_table_name: Link
  fields:
  - dimension: link_id
    type: int
    primary_key: true
    sql: ${TABLE}.LinkId
  - dimension: assessment
    sql: ${TABLE}.Assessment
  - dimension: athlete_name
    sql: ${TABLE}.AthleteName
  - dimension: athletic_association
    type: int
    sql: ${TABLE}.AthleticAssociation
  - dimension: bench_press_reps_high_school
    type: int
    sql: ${TABLE}.BenchPressRepsHighSchool
  - dimension: broad_jump
    type: int
    sql: ${TABLE}.BroadJump
  - dimension: coached_by_shared_user_id
    type: int
    sql: ${TABLE}.CoachedBySharedUserId
  - dimension: forty_yard_dash
    type: number
    sql: ${TABLE}.FortyYardDash
  - dimension: is_hidden_from_search
    sql: ${TABLE}.IsHiddenFromSearch
  - dimension: lane_agility_drill
    type: number
    sql: ${TABLE}.LaneAgilityDrill
  - dimension: link_athlete_type
    type: yesno
    sql: ${TABLE}.LinkAthleteType
  - dimension: link_code
    sql: ${TABLE}.LinkCode
  - dimension: link_code_last_sent_to_email
    sql: ${TABLE}.LinkCodeLastSentToEmail
  - dimension: link_code_last_sent_to_phone_number
    sql: ${TABLE}.LinkCodeLastSentToPhoneNumber
  - dimension: link_for_organization_id
    type: int
    sql: ${TABLE}.LinkForOrganizationId
  - dimension: link_for_profile_id
    type: int
    sql: ${TABLE}.LinkForProfileId
  - dimension: link_status
    type: yesno
    sql: ${TABLE}.LinkStatus
  - dimension: max_velocity
    type: int
    sql: ${TABLE}.MaxVelocity
  - dimension: mile_time
    type: int
    sql: ${TABLE}.MileTime
  - dimension: pop_time
    type: number
    sql: ${TABLE}.PopTime
  - dimension: projected_competition_level
    type: int
    sql: ${TABLE}.ProjectedCompetitionLevel
  - dimension: promotional_cover_letter
    sql: ${TABLE}.PromotionalCoverLetter
  - dimension: shuttle20_yard
    type: number
    sql: ${TABLE}.Shuttle20Yard
  - dimension: shuttle60_yard
    type: number
    sql: ${TABLE}.Shuttle60Yard
  - dimension: shuttle_run
    type: number
    sql: ${TABLE}.ShuttleRun
  - dimension: sixty_yard_dash
    type: number
    sql: ${TABLE}.SixtyYardDash
  - dimension: sport_enum
    type: int
    sql: ${TABLE}.SportEnum
  - dimension: standing_vertical
    type: number
    sql: ${TABLE}.StandingVertical
  - dimension: team_state
    sql: ${TABLE}.TeamState
  - dimension: three_cone_drill
    type: number
    sql: ${TABLE}.ThreeConeDrill
  - dimension: three_quarter_sprint
    type: number
    sql: ${TABLE}.ThreeQuarterSprint
  - dimension: vertical_jump
    type: int
    sql: ${TABLE}.VerticalJump
  - dimension_group: assessment_date_modified_utc
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.AssessmentDateModifiedUtc
  - dimension_group: connected_date_utc
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.ConnectedDateUtc
  - dimension_group: date_created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DateCreated
  - dimension_group: date_last_accessed
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DateLastAccessed
  - measure: count
    type: count
    drill_fields:
    - link_id
    - athlete_name
    - linkbackup.count

Contents

  • link.view.lkml
  • link.view.lookml