Batch cycle: ETL and ops improvements for cycle 2024.2

[larsyencken]

Last update Thu 2nd May.

Must do

• ✨ migrate gdrive images from Spaces to R2 owid-grapher#3128
• Apply a strict schema to YAML metadata files #2238
• Propagate data types to MySQL from ETL for Sophia feature(baking): add variables.type column that explicitly specifies type information owid-grapher#2039
• https://github.com/owid/ops/issues/10
• Upgrade pandas to 2.2.x #1094

Could do

• Tracking issue: metadata editing improvements owid-grapher#3303
• Data diff: single line diff against previous dataset version #2393
• https://github.com/owid/ops/issues/97
• owid/ops#153

Not this cycle

• Skip chart revision for charts with identical data #2394
• https://github.com/owid/ops/issues/155
• One line command for detecting and enqueuing chart revisions #2411
• Data diff: compare against correct base version in CI #2392
• Data diff: strict checks when no changes expected #2391
• Admin metadata editing of types #2495