Data marts

Educational service

Mandatory seeds and adapters. Please refer to the seeds and adapters' documentation to learn how to implement a seed or an adapter.

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/ folder already contains 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 learn how to implement an adapter.

Population adapters

In order to build your populations, you must define the business rules for previous years, the current year, and 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 ones

Using custom populations is optional. If you don't provide any custom ones, the ETL will use the default (mandatory) populations.

In your cssXX.dashboards_store:

Create as many .sql files as you have custom populations. Those files should have the same columns as the custom_fgj_populations.sql file.
Override custom_fgj_populations.sql and replace it with a script to UNION all of your newly created population files.

Please read about overriding if you are new to the concept.

Edit this pageorReport an issue

Introduction

Human resources