Forum Discussion

haku99's avatar
haku99
Frequent Visitor
11 months ago
Solved

Restricted View Policy Bug

I am doing a direct ingestion from event hub to event house. When I apply restricted view policy on the table that is used for ingestion, the ingestion stops. That completely makes sense. But even th...
Eventhouse
KQL Database
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    10 months ago

    Hi haku99,
    Thank you for the follow-up question.

    That sounds like a practical approach given your organization’s preference for SAS authentication. I’m glad the explanation helped you make an informed decision. 

    If you ever decide to explore Managed Identity in the future, it can offer smoother integration with Fabric’s security layers, but your current setup should work just fine without the restricted view policy. Really appreciate you taking the time to share your outcome it’ll surely help others facing a similar situation.

    Wishing you all the best with your Event house setup, and don’t hesitate to reach out again if any new questions come up.

    Thank you for being part of the Microsoft Fabric Community Forum.

datacoffee's avatar
datacoffee
Most Valuable Professional
11 months ago

A materialized view is doable across databases.

 

Even though you have the requirement to add a SUMMARIZE function to the view, you can always do that across all columns and do the agreegation on a dummy column.

 

It sounds "hacky" but it works like a charm

haku99's avatar
haku99
Frequent Visitor
10 months ago

Thats an interesting option datacoffee . I will try that out. Appreciate your insights!