Data marts
Educational service
Mandatory seeds and adapters. Please, refer to the seeds and adapters' documentation to get information about the way a seed or an adapter should be implemented.
Seeds
There are no mandatory seeds for the educational service mart.
Adapters
Mandatory adapters
These
adapters must be populated for the ETL to work.If you have spun up your store using the
cookiecutter template, the cssXX.dashboards_store/models/marts/educ_serv/staging/ folders already contain pre-populated adapters to help you get started. You just have to update the sql files with your own business rules.The next table shows the required adapter definitions and the path where the sql files should be placed.
| Adapter YAML definition path | Where to save it | Name of the adapter to implement |
|---|---|---|
core.dashboards_store/models/marts/educ_serv/adapters.yml | cssXX.dashboards_store/models/marts/educ_serv/staging/populations/*.sql | stg_ele_prescolaire, stg_ele_primaire_reg, stg_ele_primaire_adapt, stg_ele_secondaire_reg, stg_ele_secondaire_adapt |
Please refer to the adapter documentation to get information about the way an adapter should be implemented.
Population adapters
In order to build your populations, you must define the business rules for the previous years, including the current year, and for the forecast year.
Keep in mind that the Groupe-Repere data cannot be used for the forecast year because it is not available until the end of the current year. You need to analyze which data you can use to ensure data quality. We recommend using distribution data, if possible, for the forecast year.
Adding custom populations to the default one
Using custom populations is optional. If you don't provide any custom ones, the ETL will use the default (mandatory) ones.
In your cssXX.dashboards_store:
- Create as many
.sqlfiles as you have custom populations. Those files should have the same columns as thecustom_fgj_populations.sqlfile. - Override
custom_fgj_populations.sqland replace it with a script toUNIONall of your newly created population files.
Please read about overriding if you are new to the concept.