Synapse
NewImprove T SQL gold views management ( facilitate underlying data access) for consumers
Vote
(2)
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