data migration

Jump to bottom

windula_k edited this page Nov 3, 2023 · 6 revisions

Database design and implementation

Database design

ER Diagram

Seperate python Job was written to conduct Data Migration

Initial preparation
- Column Data
  - Temperature (C), Apparent Temperature (C) columns round-off to 1 decimal place
  - Visibility (km) round-off to 1 decimal place
  - Formatted Date modified to this format '2008-07-12 17:00:00'