Deployment

Databases

The gpi database must be linked to the project. Please refer to the linking a database section for more information about how to link a database.

Marts

The following marts must be enabled for the dashboard to work. Please refer to the enabling a mart section for more information about how to enable a mart.

• educ_serv

Dbt project specification

Update your cssXX.dashboards_store/dbt_project.yml file with the following snippet.

models:
  core_dashboards_store: # Enable the models from the core repo
    marts:
      educ_serv:
        +enabled: True
    dashboards:
      educ_serv:
        res_scolaires:
          +enabled: True
    interfaces: # The dashboard only needs the GPI database
      gpi:
        +enabled: True

configuration

Customizing the tracked subjects

Update your cssXX.dashboards_store/dbt_project.yml file. This table needs some seeds. Make sure to run dbt seed --full-refresh to populate the seeds.

• To add a list of in-house subjects to be tracked :
  1. Add a .csv file in your cssXX.dashboards_store/seeds/dashboards/educ_serv/res_scolaires folder. The file must be named custom_matiere.csv. The file must be populated with the colums described by core.dashboards_store/seeds/dashboards/educ_serv/res_scolaires/schema.yml (refers to the custom_matiere seed).
  2. Trigger a refresh of your seeds

dbt seed --full-refresh

Setting a custom threshold

The threshold is used to compute the identify the overachieving students. It is set to 70% by default.

You can override the default threshold by adding the following variable in your dbt_project.yml file.

# cssXX.dashboards_store/dbt_project.yml
vars:
  # res_scolaires's dashboard variables:
  res_scolaires:
    threshold: 70