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 ??
Fix your code
There must be an issue in your lookml.
If you could share some screenshots we may be able to help
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 {}
An what are you exploring? Which query takes so long?
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
An what are you exploring? Which query takes so long?
it is possible to modify my model (joins) to make it more efficient ??