Data Access and User Interaction

November 6, 2024 by Julian.Kellett

Access Points: Describe the tools or applications (e.g., Power BI, Azure Data Explorer) that users access to query data.
Query Optimisation: Outline query optimisation strategies and how users are supported with performant access to the data warehouse.

Recent Comments

Julian.Kellett on Global.Company
{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Regional View"}
Julian.Kellett on Global.Organisation
{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Regional View"}
Julian.Kellett on BusOpp.Dates
{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Stable 09 View"}
Julian.Kellett on Supplier.PurchaseOrderline
{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Stable 09 View"}
Julian.Kellett on Supplier.Invoice
{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Stable 09 View"}
Julian.Kellett on Supplier.Details
{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Stable 09 View"}
Julian.Kellett on BusOpp.Dates
Expected Condition The DataMart View BusOpp.Dates is in the style of 202409 As Found Condition The unversioned (beta) edition of…
Ali Ahmed on How to Find the SQL Definition of a View in Oracle
Double check your WITH READ ONLY — it’s typically only used on views, not raw SELECT queries unless you're defining…
Julian.Kellett on Resource.Details
{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Cross Apply version"}
Julian.Kellett on Employee.Hours
{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"CTE Version"}

Leave a Comment Cancel reply