Using a BigQuery Array in drill down Look ML

  • 25 August 2021
  • 0 replies



I have a bigquery field with the following schema:


Where as endpoint is a key and it has a array with unique users for each endpoint.


So I am trying to do a LookML drill down with a dashboard for each endpoint I want to display the amount of unique_users and have users as a drill down. However, as I specify users as the drill down, I get no results when clicking into the graph. Do anyone know how to solve this? This is my current LookML:


  dimension: endpoint {
    type: string
    sql: ${TABLE}.endpoint ;;

  dimension: users {
    hidden: yes
    sql: ${TABLE}.users ;;

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

  measure: countUniqueUsers {
    type: sum
    sql: ${TABLE}.unique_users ;;
    drill_fields: [users]

However, when drilling into the graph and expecting to see a list of the contents of user array, Looker provides me with no results. How to fix this in LookML?

This topic has been closed for comments