Technical documentation for the Bollate ELN data load and integration.
Summary
Sum-up
| Data Sources | ELN, Spreadsheets | ||
| Mapping spreadsheet | |||
| Talend job | Query SQL | BigQuery Target Tables | |
|---|---|---|---|
| Data Load | |||
| Integration | |||
| Presentation | |||
Macro Schema
Data Sources
| Source | Description | Data Status | Flow Status |
|---|---|---|---|
ELN new spreadsheet (ELN EWHA BOLLATE) | This is a standard ELN spreadsheet for Ewha and Bollate | HOT | ACTIVE |
ELN historic spreadsheet | This is a ancient format for ELN spreadsheet. The data is still necessary but it's been | COLD | DISABLED |
ELN Battery mapping | This is a spreadsheet has many necessary sheets. It's used mainly for mapping data between the historic spreadsheet and the new one | COLD | ONE SHOT |
| pre-ELN MuSigma | Before the ELN spreadsheets for specific for battery, the enterprise MuSigma created some process to recover some ELN data | COLD | DISABLED |
Data Load and Integration
| N | Description |
|---|---|
| A1 | |
| A2 | |
A3 | |
| A4 | |
| A5 | |
| A6 | |
| B1 | |
| B2 | |
| B3 | |
| B4 | |
| C1 | |
| D1 |