high latency

[tatuspark]

Hi, please how to optimize my sql queries to get results faster. I have a model with only 2 joins but when I run sum measure it takes 20 min to displayMy database is bigquery

explore: store {
  join: dv_purchase {
    type: left_outer
    relationship: one_to_many
    sql_on: ${store.id_store}=${dv_purchase.id_store} ;;
  }

  join: dig_orders {
    type: left_outer
    relationship: one_to_many
    sql_on: ${store.cd_store}=${dig_orders.code_store} ;;
  }
}

[IanT · Accepted solution]

I would take a guess that you are missing a join key, maybe orderid on the orders join.

[tatuspark]

I would take a guess that you are missing a join key, maybe orderid on the orders join.

@IanT  join keys are correct