Skip to main content

Data Warehouse

New

Improve T SQL gold views management ( facilitate underlying data access) for consumers

Vote (2) Share
Bamakus Montreuil's profile image

Bamakus Montreuil on 18 Apr 2024 10:38:10

Like on BIGQUERY (Authorized views) , Authorize some T SQL view to access underlying SQL data


Use case :


  • Gold data (tables & views) is on a Gold SQL DWH layer (a particular Fabric DWH DB) <== managed by : Data engineers and DATA Analysts users
  • Raw / staging data is on another dedicated DWH DB <== managed : Data engineers
  • We are on the same Workspace but 2 different DW (one by layer)
  • Not alllow accees to RAW / Staging data (a particular Fabric DWH DB ) to DATA Analysts users
  • Avoid to manage RUN AS pattern inside gold views