In the environment section, you have a sub-section called optimisations.

Backtrack time

The dashboards are located in the dashboard section on the webapp.


You can use this optimisation when:

For heavy queries, if you need an extra optimisation to reduce the execution time, instead of implementing an optimization in the optimizations section, you can directly write the backtrack time in the query : $backtrack_filter:<time_dimension>$

For example, if you have a transformation table transfo_example with the following query:
SELECT COUNT(_id) FROM example1

You can:

  • put a backtrack time optimisation on example1

  • rewrite the transfo_example with the $backtrack_filter:<time_dimension>$

    SELECT COUNT(_id) FROM (SELECT * FROM example1 WHERE $backtrack_filter:started_at$) example1

Index

The dashboards are located in the dashboard section on the webapp.


There are folders in the Dashboard section. Each folder contains dashboards. A dashboard is a set of charts.

You can use this optimisation when:

Partitions

The dashboards are located in the dashboard section on the webapp.


There are folders in the Dashboard section. Each folder contains dashboards. A dashboard is a set of charts.

You can use this optimisation when:
1. You have implemented an index on the fiel

Double partitions

$optimization_filter_dimension1:<column_name>$ et $optimization_filter_dimension2:<column_name>$