Looker Google Sheet View

google-sheet-view.txt

view: monthly_unique_visitors_test {
  sql_table_name: google_sheets.monthly_unique_visitors_test ;;

  dimension_group: visit {
    type: time
    timeframes: [
      month
    ]
    sql: CAST(PARSE_DATE("%e-%b-%y", ${TABLE}.month) AS TIMESTAMP) ;;
  }

  measure: unique_visitors {
    type: max
    sql: CAST(REPLACE(${TABLE}.users, ",", "") AS INT64) ;;
    value_format_name: decimal_0
  }
}