Configuration
Configurable variables
Variables adapt core.dashboards_store models without replacing their SQL.
Define them in the vars section of
cssXX.dashboards_store/dbt_project.yml.
Configuring dbt variables
Variables adapt core.dashboards_store models without replacing their SQL.
Define them in the vars section of
cssXX.dashboards_store/dbt_project.yml.
is_context_core is an internal variable generated by the template. Do not
change it.Available variables
| Variable | Default | Usage |
|---|---|---|
school_year_start_month | 9 | First month used by get_school_year for HR activity, as an integer from 1 to 12. |
current_year | Automatically inferred | Overrides the current year calculated by get_current_year. |
database_paie | Must be configured | Fully qualified name of the PAIE database. |
database_gpi | Must be configured | Fully qualified name of the GPI database. |
database_jade | Must be configured | Fully qualified name of the JADE database. |
database_prodrome | Must be configured | Fully qualified name of the PRODROME database. |
interfaces.gpi.max_etapes | 30 | Maximum number of steps generated from GPI. |
interfaces.gpi.max_periodes | 20 | Maximum number of periods generated from GPI. |
marts.educ_serv.recency.years_of_data_absences | 10 | Number of years of absence data to retain. |
marts.educ_serv.recency.years_of_data_grades | 10 | Number of years of grade data to retain. |
dashboards.res_epreuves.cod_css | Required for res_epreuves | Expression used to restrict results to the school service centre. |
emp_actif.nbrs_sem_dern_paie | 1 | Accepted number of weeks since the last pay. |
res_scolaires.threshold | 70 | High achievement threshold, as a percentage. |
The database_* variables are detailed on the
Linking the databases page. Variables
specific to a dashboard are also explained on that dashboard's page.
Overriding a Core default
Place package-specific variables under the core_dashboards_store key. For
example, for a school year that starts in July:
# cssXX.dashboards_store/dbt_project.yml
vars:
core_dashboards_store:
school_year_start_month: 7
Without this override, Core uses September. A value below 1, above 12, or
that is not an integer raises an explicit compilation error.