Data Warehouse Overview¶
⚠️ Auto-generated — do not edit this file directly. Re-run
python scripts/generate_docs.pyto refresh it.
Welcome to the Resilians Snowflake Data Warehouse documentation. Each source system is ingested via Fivetran and organized in three layers:
| Layer | Colour | Schema prefix | Description |
|---|---|---|---|
| 🟤 Raw | Bronze | RAW_* |
Untransformed Fivetran ingestion |
| 🪙 Staging | Silver | STG_* |
Cleaned and typed |
| 🥇 Curated | Gold | CURATED_* |
Business-ready for reporting |
Source Systems¶
| Source | Database | Raw tables | Staging tables | Curated objects |
|---|---|---|---|---|
| ANTISS | RESILIANS_ANTISS_DB |
39 | 20 | 4 |
| CEGID | RESILIANS_CEGID_DB |
35 | 34 | 14 |
| DIVALTO | RESILIANS_DIVALTO_DB |
80 | 80 | 31 |
| DOCUWARE | RESILIANS_DOCUWARE_DB |
581 | 147 | 0 |
| JENJI | RESILIANS_JENJI_DB |
6 | 6 | 1 |
| KAZERDF | RESILIANS_KAZERDF_DB |
2 | 0 | 3 |
| MONDAY | RESILIANS_MONDAY_DB |
28 | 28 | 0 |
| SAGECOMPTA | RESILIANS_SAGECOMPTA_DB |
690 | 0 | 15 |
| SIRENE | RESILIANS_SIRENE_DB |
1 | 2 | 3 |
Total: 9 source systems, 1906 tables/views
Sections¶
- Sources — Browse all source systems and their tables
- Business Glossary — Key business terms and KPI definitions