data loading takes a long time

[tatuspark]

I have over 20,000 rows in my BigQuery database and when I do my looker queries it takes over 20 minutes to display the result. What solutions would you suggest to me ??

[moebe]

Fix your code

There must be an issue in your lookml.

If you could share some screenshots we may be able to help

[tatuspark]

Fix your code

There must be an issue in your lookml.

If you could share some screenshots we may be able to help

I sent you my lookMl as a text file that I attached. Thank you to helping me

explore: ventes {

  join: marchandise {
    type: left_outer
    relationship: many_to_one
    sql_on: ${ventes.id_marchandise}=${marchandise.id_marchandise} ;;
  }

  join: livreur {
    type: left_outer
    relationship: many_to_one
    sql_on: ${marchandise.id_fourn}=${livreur.id_fourn} ;;
  }

  join: groupe {
    type: left_outer
    relationship: many_to_one
    sql_on: ${marchandise.id_groupe}=${groupe.id_groupe} ;;
  }

  join: marchandise_cat {
    type: left_outer
    relationship: one_to_many
    sql_on: ${marchandise.id_marchandise}=${marchandise_cat.id_marchandise} ;;
  }

  join: cat {
    type: left_outer
    relationship: many_to_one
    sql_on: ${marchandise_cat.id_cat}=${cat.id_cat} ;;
  }

  join: case {
    type: left_outer
    relationship: many_to_one
    sql_on: ${marchandise_cat.id_case_case}=${case.id_case_case};;
  }

  join: n3_ss_section {
    type: left_outer
    relationship: many_to_one
    sql_on: ${case.id_sssection}=${ss_section.id_sssection};;
  }

  join: section {
    type: left_outer
    relationship: many_to_one
    sql_on: ${ss_section.id_section}=${section.id_section};;
  }

  join: secteur {
    type: left_outer
    relationship: many_to_one
    sql_on: ${section.id_secteur}=${secteur.id_secteur};;
  }

  join: boutique {
    type: left_outer
    relationship: many_to_one
    sql_on: ${ventes.id_boutique}=${boutique.id_boutique} ;;
  }

}

explore: commandes {

  join: clients {
    type: inner
    relationship: one_to_many
    sql_on: ${commandes.code_client} = cast(${clients.code_client} as string);;
  }

  join: nos_boutiques {
    type: inner
    relationship: one_to_many
    sql_on: ${commandes.code_boutique} = ${nos_boutiques.code_boutique};;
  }

 join: produits_commandes {
    type: inner
    relationship: one_to_many
    sql_on: ${commandes.code_commande} = ${produits_commandes.code_commande};;
  }

  join: ventes {
    type: inner
    relationship: many_to_one
    sql_on: ${ventes.id_boutique}=${boutique.id_boutique} ;;
  }

  join: boutique {
    type: inner
    relationship: many_to_one
    sql_on: ${commandes.code_boutique} = ${boutique.cd_boutique}  ;;
  }

}

explore: cat {}

explore: marchandise {}

explore: marchandise_cat {}

explore: livreur {}

explore: boutique {}

explore: groupe {}

explore: secteur {}

explore: section {}

explore: ss_section {}

explore: case {}

[moebe]

An what are you exploring? Which query takes so long?

[tatuspark]

An what are you exploring? Which query takes so long?

I would like to create a dashboard between the tables nos_boutiques and ventes  and when I select the dimensions and measures I need which are 12 in number I have to wait 20 minutes for the result to be displayed

[tatuspark]

An what are you exploring? Which query takes so long?

it is possible to modify my model (joins) to make it more efficient ??