← Back to OS

Greenwood Data Core

Enterprise grade Data Lake and Orchestration Hub for automated SKY API synchronization.

📊 Data Lake Health

Total Grades Synced

154,293

Deep Archive (FM)

21,895

Deep Archive (FE)

19,874

Unified Source

● VW_MasterGrades_Unified

Decoupled Architecture

Uses native SKY API endpoints to ingest raw data into landing tables ensuring stability regardless of manual changes to Blackbaud UI lists.

Tiered Grade Management

Segments historical records into archive lists and specialized tables for Final Exams and Marks to prevent API timeouts.

Automated Infrastructure

Powered by Google Cloud Run and Cloud SQL with a smart power management system that sleeps the database at night.

Weekly Development Log

March 15 - March 22, 2026
  • Successfully executed the Deep Grade Batch Pipeline syncing over 150k rows.
  • Deployed the Unified Grade View for Crystal Reports compatibility.
  • Launched Google Classroom RSS feed automation and teacher distribution.
March 08 - March 14, 2026
  • Deployed Sequenced Batch Scheduling for custom multi pipeline execution.
  • Integrated Google Sheets export automation with Drive API folder sharing.