Who is this article for?

Users who want to find out more about the Galileo 1.4.7 release.

No elevated permissions are required.

This release improves data reliability, streamlines data loading, and enhanced enterprise data integration based on your feedback.

1. System Robustness

1.1  Data accuracy & reliability

• Improved modified_date accuracy - Enhanced tracking for views spanning multiple tables; now captures the latest change across all tables and standardized column naming from *_modified_date to modified_date
• New view - Introduced dwreporting.lastmodified_summary view to track modification dates across dwanalytics and dwreporting views, enabling efficient incremental data loading
• Enhanced unique constraints - Improved unique key definitions across Galileo views for better data integrity and pagination
• Fixed table ID stability - Resolved dwanalytics.lists ID reassignment issue; list identifiers now remain consistent across API refreshes
• Accurate change tracking - modified_date now updates correctly when valid_to changes for audit, document, risk, workflow, reports and tasks

2. Infrastructure improvements

2.1 Enhanced refresh mechanism

• Implemented A/B stack approach for materialized view refresh, improving reliability and reducing downtime during updates
• Benefits: 
  • Data can be accessed without worrying about hitting refresh windows or getting incomplete data.
  • No refresh windows or maintenance notifications needed
  • Queries always return results
  • More frequent data refreshes possible 

3. API enhancement

3.1 Increased OData clause limit

Expanded ordering clause limit from 5 to 10 parameters, enabling more complex queries and improved data retrieval flexibility

4. Fixed Issues