Release 56

by

Summary

This minor release of some 36 changes to ensure that all view definitions now include an Alias for the table in the FROM clause. These updates are cosmetic in nature and do not impact the performance of the DataViews.

Key Updates

  • Standardised table aliasing in all view definitions.
  • Improved query consistency and readability.
  • Enables seamless integration with the new OnDemand service.

Impact

  • No functional changes: DataViews will continue to perform as expected.
  • No impact on reporting or downstream processes.
  • Improved maintainability: Ensures compatibility with future optimisations.

Next Steps

  • If you are leveraging the OnDemand service, you can now access all updated views without modification.
  • No action is required for existing queries or reports.

For any queries or issues, please reach out to the Data Engineering team.

Notes

1. ⚠️ DIFFERENT: busopp_details_202405.sql
2. ⚠️ DIFFERENT: busopp_details_plus_202407.sql
3. ⚠️ DIFFERENT: busopp_value_202404.sql
4. ⚠️ DIFFERENT: busopp_value_202405.sql
5. ⚠️ DIFFERENT: customer_details_CAD.sql
6. ⚠️ DIFFERENT: customer_orderline_202501.sql
7. ⚠️ DIFFERENT: employee_details.sql
8. ⚠️ DIFFERENT: employee_hours_202406.sql
9. ⚠️ DIFFERENT: employee_hours_202407.sql
10. ⚠️ DIFFERENT: infrastructure_changerequest.sql
11. ⚠️ DIFFERENT: infrastructure_oshrecords.sql
12. ⚠️ DIFFERENT: marketing_Advertising.sql
13. ⚠️ DIFFERENT: marketing_campaign_details_plus.sql
14. ⚠️ DIFFERENT: marketing_campaignTraffic.sql
15. ⚠️ DIFFERENT: marketing_campaignTrafficFormSubmissions.sql
16. ⚠️ DIFFERENT: marketing_HubSpotLandingPages.sql
17. ⚠️ DIFFERENT: marketing_Meltwater.sql
18. ⚠️ DIFFERENT: marketing_SocialMedia.sql
19. ⚠️ DIFFERENT: project_cost.sql
20. ⚠️ DIFFERENT: project_cost_CAD.sql
21. ⚠️ DIFFERENT: project_cost_USD.sql
22. ⚠️ DIFFERENT: project_details_CAD.sql
23. ⚠️ DIFFERENT: project_details_202404.sql
24. ⚠️ DIFFERENT: project_details_202407.sql
25. ⚠️ DIFFERENT: project_details_plus_202406.sql
26. ⚠️ DIFFERENT: project_details_plus_202407.sql
27. ⚠️ DIFFERENT: project_details_plus_CAD.sql
28. ⚠️ DIFFERENT: project_details_plus_USD.sql
29. ⚠️ DIFFERENT: project_roleassignment.sql
30. ⚠️ DIFFERENT: project_roleassignment_202410.sql
31. ⚠️ DIFFERENT: project_roleassignment_CAD.sql
32. ⚠️ DIFFERENT: project_roleassignment_USD.sql
33. ⚠️ DIFFERENT: project_value_202410.sql
34. ⚠️ DIFFERENT: resource_absence_202407.sql
35. ⚠️ DIFFERENT: dates_holidays_uk.sql
36. ⚠️ DIFFERENT: dates_period.sql

Total number of different files: 36
Total number of missing files in DEV CONTAINER: 0
Total number of missing files in PRD CONTAINER: 0

Leave a Comment