Commit Graph

1 Commits

Author SHA1 Message Date
dal e60a8420c4
feat: implement schema sync and validation cron job
- Add daily cron job that runs at midnight MST to validate schemas
- Introspect customer data sources and compare with dataset YML configs
- Send Slack notifications when discrepancies are found
- Group datasets by database/schema for efficient introspection
- Add comprehensive logging for debugging schema comparisons
- Fix credential retrieval to use vault pattern from AI package
- Move schema-sync types from server-shared to trigger app

This implementation includes:
- Database queries for fetching organizations and datasets
- YML parser with Zod validation
- Schema comparator with type normalization
- Slack notification formatter using Block Kit
- CloudWatch metrics for monitoring
- Comprehensive unit tests

🤖 Generated with [Claude Code](https://claude.ai/code)

Co-Authored-By: Claude <noreply@anthropic.com>
2025-07-31 09:05:12 -06:00