Where does Python fit into the Jetstar Enterprise Data Platform? What does it do that SQL doesn't?

In Jetstar’s platform, Python is used primarily for orchestration, data transformation, and advanced analytics. SQL handles declarative, set‑based operations on structured data, but it lacks procedural control, external library integration, and the ability to perform iterative or stateful computations. Python scripts are scheduled by the orchestrator (e.g., Airflow) to pull data from the lake, apply business logic, run machine‑learning models, or call external APIs. They can also generate dynamic SQL or write results back to the lake. Additionally, Python is used for data quality checks, schema validation, and generating dashboards. In short, Python extends the platform’s capabilities beyond pure SQL by providing a flexible, programmable layer for complex workflows, custom logic, and integration with third‑party services.