BigQuery上のテーブルで日本語カラムが使われていた際にLookMLの定義ができるか確認してみた

CREATE OR REPLACE VIEW `sagara-satoshi.citibike.trips_jp_view` AS
SELECT
  tripduration AS `利用時間_秒`,
  starttime AS `開始時刻`,
  stoptime AS `終了時刻`,
  start_station_id AS `開始ステーションID`,
  start_station_name AS `開始ステーション名`,
  start_station_latitude AS `開始ステーション緯度`,
  start_station_longitude AS `開始ステーション経度`,
  end_station_id AS `終了ステーションID`,
  end_station_name AS `終了ステーション名`,
  end_station_latitude AS `終了ステーション緯度`,
  end_station_longitude AS `終了ステーション経度`,
  bikeid AS `自転車ID`,
  usertype AS `ユーザータイプ`,
  birth_year AS `誕生年`,
  gender AS `性別`,
  customer_plan AS `顧客プラン`
FROM
  `sagara-satoshi.citibike.trips`;

view: trips_jp_view {
  sql_table_name: `sagara-satoshi.citibike.trips_jp_view` ;;

  dimension: start_station_id {
    label: "開始ステーションID"
    primary_key: yes
    type: number
    sql: ${TABLE}.`開始ステーションID` ;;
  }

  dimension_group: starttime {
    label: "開始時刻"
    type: time
    timeframes: [raw, time, date, week, month, quarter, year]
    datatype: datetime
    sql: ${TABLE}.`開始時刻` ;;
  }

  dimension: customer_plan {
    label: "顧客プラン"
    type: string
    sql: ${TABLE}.`顧客プラン` ;;
  }

  dimension: start_station_name {
    label: "開始ステーション名"
    type: string
    sql: ${TABLE}.`開始ステーション名` ;;
  }

  dimension: start_station_longitude {
    label: "開始ステーション経度"
    type: number
    sql: ${TABLE}.`開始ステーション経度` ;;
  }

  dimension: start_station_latitude {
    label: "開始ステーション緯度"
    type: number
    sql: ${TABLE}.`開始ステーション緯度` ;;
  }

  dimension: usertype {
    label: "ユーザータイプ"
    type: string
    sql: ${TABLE}.`ユーザータイプ` ;;
  }

  dimension: end_station_name {
    label: "終了ステーション名"
    type: string
    sql: ${TABLE}.`終了ステーション名` ;;
  }

  dimension: end_station_longitude {
    label: "終了ステーション経度"
    type: number
    sql: ${TABLE}.`終了ステーション経度` ;;
  }

  dimension: end_station_latitude {
    label: "終了ステーション緯度"
    type: number
    sql: ${TABLE}.`終了ステーション緯度` ;;
  }

  dimension: gender {
    label: "性別"
    type: string
    sql: ${TABLE}.`性別` ;;
  }

  dimension: birth_year {
    label: "誕生年"
    type: number
    sql: ${TABLE}.`誕生年` ;;
  }

  dimension_group: stoptime {
    label: "終了時刻"
    type: time
    timeframes: [raw, time, date, week, month, quarter, year]
    datatype: datetime
    sql: ${TABLE}.`終了時刻` ;;
  }

  dimension: tripduration {
    label: "利用時間_秒"
    type: number
    sql: ${TABLE}.`利用時間_秒` ;;
  }

  dimension: end_station_id {
    label: "終了ステーションID"
    type: number
    sql: ${TABLE}.`終了ステーションID` ;;
  }

  dimension: bikeid {
    label: "自転車ID"
    type: number
    sql: ${TABLE}.`自転車ID` ;;
  }

  measure: count {
    type: count
  }
}