Standardisation of DataMart View Queries for SQL OnDemand
To enhance query consistency and readiness for SQL OnDemand, we have implemented a major standardisation across all DataMart view queries.
Key Enhancements:
✅ Uniform Aliases for Data Sources – All table references now include consistent and meaningful aliases, improving readability and maintainability.
✅ Standard Positioning of -- Pipeline Dates (locator flag) – This comment is now consistently placed to facilitate automated query transformations.
✅ Seamless Migration to SQL OnDemand – With these refinements, existing queries can now be auto-converted into OnDemand views using OPENROWSET within the FROM statement.
These changes pave the way for scalable, efficient, and OnDemand-ready queries, ensuring a smoother transition to serverless SQL processing.
Notes
1. ⚠️ DIFFERENT: busopp_dates.sql
2. ⚠️ DIFFERENT: busopp_details.sql
3. ⚠️ DIFFERENT: busopp_details_202404.sql
4. ⚠️ DIFFERENT: busopp_details_202405.sql
5. ⚠️ DIFFERENT: busopp_details_202407.sql
6. ⚠️ DIFFERENT: busopp_details_202409.sql
7. ⚠️ DIFFERENT: busopp_details_APC.sql
8. ⚠️ DIFFERENT: busopp_details_plus.sql
9. ⚠️ DIFFERENT: busopp_details_plus_202407.sql
10. ⚠️ DIFFERENT: busopp_details_plus_202409.sql
11. ⚠️ DIFFERENT: busopp_details_plus_APC.sql
12. ⚠️ DIFFERENT: busopp_value.sql
13. ⚠️ DIFFERENT: busopp_value_202404.sql
14. ⚠️ DIFFERENT: busopp_value_202405.sql
15. ⚠️ DIFFERENT: busopp_value_202409.sql
16. ⚠️ DIFFERENT: busopp_value_APC.sql
17. ⚠️ DIFFERENT: customer_details.sql
18. ⚠️ DIFFERENT: customer_details_202404.sql
19. ⚠️ DIFFERENT: customer_details_202407.sql
20. ⚠️ DIFFERENT: customer_details_202411.sql
21. ⚠️ DIFFERENT: customer_details_CAD.sql
22. ⚠️ DIFFERENT: customer_invoice.sql
23. ⚠️ DIFFERENT: customer_invoiceitem.sql
24. ⚠️ DIFFERENT: customer_invoicestatus.sql
25. ⚠️ DIFFERENT: customer_invoicestatus_202409.sql
26. ⚠️ DIFFERENT: customer_invoicestatus_202411.sql
27. ⚠️ DIFFERENT: customer_invoicevalue.sql
28. ⚠️ DIFFERENT: customer_invoicevalue_202409.sql
29. ⚠️ DIFFERENT: customer_invoicevalue_202411.sql
30. ⚠️ DIFFERENT: customer_invoice_202404.sql
31. ⚠️ DIFFERENT: customer_invoice_202405.sql
32. ⚠️ DIFFERENT: customer_invoice_202409.sql
33. ⚠️ DIFFERENT: customer_invoice_202411.sql
34. ⚠️ DIFFERENT: customer_order.sql
35. ⚠️ DIFFERENT: customer_orderline.sql
36. ⚠️ DIFFERENT: customer_orderlinestatus.sql
37. ⚠️ DIFFERENT: customer_orderlinestatus_202409.sql
38. ⚠️ DIFFERENT: customer_orderlinestatus_202411.sql
39. ⚠️ DIFFERENT: customer_orderlinevalue.sql
40. ⚠️ DIFFERENT: customer_orderlinevalue_202409.sql
41. ⚠️ DIFFERENT: customer_orderlinevalue_202411.sql
42. ⚠️ DIFFERENT: customer_orderline_202404.sql
43. ⚠️ DIFFERENT: customer_orderline_202405.sql
44. ⚠️ DIFFERENT: customer_orderline_202406.sql
45. ⚠️ DIFFERENT: customer_orderline_202409.sql
46. ⚠️ DIFFERENT: customer_orderline_202411.sql
47. ⚠️ DIFFERENT: customer_orderstatus.sql
48. ⚠️ DIFFERENT: customer_orderstatus_202411.sql
49. ⚠️ DIFFERENT: customer_order_202411.sql
50. ⚠️ DIFFERENT: customer_thermometer.sql
51. ⚠️ DIFFERENT: employee_absence.sql
52. ⚠️ DIFFERENT: employee_absencelimit.sql
53. ⚠️ DIFFERENT: employee_details.sql
54. ⚠️ DIFFERENT: employee_details_202404.sql
55. ⚠️ DIFFERENT: employee_details_202406.sql
56. ⚠️ DIFFERENT: employee_details_202407.sql
57. ⚠️ DIFFERENT: employee_details_202410.sql
58. ⚠️ DIFFERENT: employee_details_plus.sql
59. ⚠️ DIFFERENT: employee_details_plus_202404.sql
60. ⚠️ DIFFERENT: employee_details_plus_202406.sql
61. ⚠️ DIFFERENT: employee_details_plus_202407.sql
62. ⚠️ DIFFERENT: employee_details_plus_202409.sql
63. ⚠️ DIFFERENT: employee_details_plus_202410.sql
64. ⚠️ DIFFERENT: employee_employment.sql
65. ⚠️ DIFFERENT: employee_headcount.sql
66. ⚠️ DIFFERENT: employee_headcount_202404.sql
67. ⚠️ DIFFERENT: employee_headcount_202407.sql
68. ⚠️ DIFFERENT: employee_hours.sql
69. ⚠️ DIFFERENT: employee_hours_202404.sql
70. ⚠️ DIFFERENT: employee_hours_202406.sql
71. ⚠️ DIFFERENT: employee_hours_202407.sql
72. ⚠️ DIFFERENT: employee_leaveentitlement.sql
73. ⚠️ DIFFERENT: employee_leaveentitlement_202407.sql
74. ⚠️ DIFFERENT: employee_status.sql
75. ⚠️ DIFFERENT: employee_status_202404.sql
76. ⚠️ DIFFERENT: global_forex.sql
77. ⚠️ DIFFERENT: global_organisation.sql
78. ⚠️ DIFFERENT: marketing_campaign_details_plus.sql
79. ⚠️ DIFFERENT: marketing_SocialMedia.sql
80. ⚠️ DIFFERENT: project_activitydetails.sql
81. ⚠️ DIFFERENT: project_activitydetails_202407.sql
82. ⚠️ DIFFERENT: project_activitydetails_202410.sql
83. ⚠️ DIFFERENT: project_cost.sql
84. ⚠️ DIFFERENT: project_cost_202404.sql
85. ⚠️ DIFFERENT: project_cost_202406.sql
86. ⚠️ DIFFERENT: project_cost_202410.sql
87. ⚠️ DIFFERENT: project_cost_CAD.sql
88. ⚠️ DIFFERENT: project_cost_history_202404.sql
89. ⚠️ DIFFERENT: project_cost_USD.sql
90. ⚠️ DIFFERENT: project_customerinvoice.sql
91. ⚠️ DIFFERENT: project_customerinvoice_202406.sql
92. ⚠️ DIFFERENT: project_customerorderline.sql
93. ⚠️ DIFFERENT: project_customerorderline_202406.sql
94. ⚠️ DIFFERENT: project_customerorderline_202407.sql
95. ⚠️ DIFFERENT: project_customerorderline_202409.sql
96. ⚠️ DIFFERENT: project_dates.sql
97. ⚠️ DIFFERENT: project_dates_202410.sql
98. ⚠️ DIFFERENT: project_details.sql
99. ⚠️ DIFFERENT: project_details_202404.sql
100. ⚠️ DIFFERENT: project_details_202407.sql
101. ⚠️ DIFFERENT: project_details_202410.sql
102. ⚠️ DIFFERENT: project_details_CAD.sql
103. ⚠️ DIFFERENT: project_details_plus.sql
104. ⚠️ DIFFERENT: project_details_plus_202404.sql
105. ⚠️ DIFFERENT: project_details_plus_202406.sql
106. ⚠️ DIFFERENT: project_details_plus_202407.sql
107. ⚠️ DIFFERENT: project_details_plus_202410.sql
108. ⚠️ DIFFERENT: project_details_plus_CAD.sql
109. ⚠️ DIFFERENT: project_details_plus_USD.sql
110. ⚠️ DIFFERENT: project_details_USD.sql
111. ⚠️ DIFFERENT: project_expenses.sql
112. ⚠️ DIFFERENT: project_expenses_202404.sql
113. ⚠️ DIFFERENT: project_expenses_202407.sql
114. ⚠️ DIFFERENT: project_expenses_202408.sql
115. ⚠️ DIFFERENT: project_forecast.sql
116. ⚠️ DIFFERENT: project_forecast_202404.sql
117. ⚠️ DIFFERENT: project_purchaseorderline.sql
118. ⚠️ DIFFERENT: project_purchaseorderline_202407.sql
119. ⚠️ DIFFERENT: project_revenue.sql
120. ⚠️ DIFFERENT: project_revenue_202404.sql
121. ⚠️ DIFFERENT: project_revenue_202406.sql
122. ⚠️ DIFFERENT: project_revenue_202410.sql
123. ⚠️ DIFFERENT: project_revenue_CAD.sql
124. ⚠️ DIFFERENT: project_revenue_USD.sql
125. ⚠️ DIFFERENT: project_roleassignment.sql
126. ⚠️ DIFFERENT: project_roleassignment_202407.sql
127. ⚠️ DIFFERENT: project_roleassignment_202410.sql
128. ⚠️ DIFFERENT: project_roleassignment_CAD.sql
129. ⚠️ DIFFERENT: project_roleassignment_USD.sql
130. ⚠️ DIFFERENT: project_supplierinvoice.sql
131. ⚠️ DIFFERENT: project_supplierinvoice_202406.sql
132. ⚠️ DIFFERENT: project_supplierinvoice_202408.sql
133. ⚠️ DIFFERENT: project_time.sql
134. ⚠️ DIFFERENT: project_time_202404.sql
135. ⚠️ DIFFERENT: project_time_202407.sql
136. ⚠️ DIFFERENT: project_value.sql
137. ⚠️ DIFFERENT: project_value_202410.sql
138. ⚠️ DIFFERENT: project_value_CAD.sql
139. ⚠️ DIFFERENT: project_value_USD.sql
140. ⚠️ DIFFERENT: resource_absence.sql
141. ⚠️ DIFFERENT: resource_absence_202404.sql
142. ⚠️ DIFFERENT: resource_absence_202407.sql
143. ⚠️ DIFFERENT: resource_activity.sql
144. ⚠️ DIFFERENT: resource_activity_202404.sql
145. ⚠️ DIFFERENT: resource_activity_202407.sql
146. ⚠️ DIFFERENT: resource_capacity.sql
147. ⚠️ DIFFERENT: resource_capacity_202404.sql
148. ⚠️ DIFFERENT: resource_capacity_202407.sql
149. ⚠️ DIFFERENT: resource_details.sql
150. ⚠️ DIFFERENT: resource_details_202404.sql
151. ⚠️ DIFFERENT: resource_details_202406.sql
152. ⚠️ DIFFERENT: supplier_details.sql
153. ⚠️ DIFFERENT: supplier_details_202407.sql
154. ⚠️ DIFFERENT: supplier_invoice.sql
155. ⚠️ DIFFERENT: supplier_invoice_202404.sql
156. ⚠️ DIFFERENT: supplier_purchaseorderline.sql
Total number of different files: 156
Total number of missing files in DEV CONTAINER: 0
Total number of missing files in PRD CONTAINER: 0