page235
322
Embedded entitlement models are sometimes encountered in legacy systems ported
to Snowflake. You should also be aware ported code may not be optimized for Snowflake.
Embedded entitlement models can be difficult to understand and may contain
bespoke rules within query predicates. Sometimes, in an attempt to abstract entitlement,
several layers of object may contain partial rule sets; beware of views calling views!
Prefiltered Entitlement
An alternative approach is to prefilter data to present entitled data only. Figure 9-3
illustrates a typical overview of a prefiltered entitlement model.
Figure 9-3.
Prefiltered entitlement model
Prefiltered entitlement models have some advantages.
•
The smaller data sets are curated for each client.
•
Performance issues are more easily resolved.
•
SQL queries do not navigate an entitlement model.
•
The changes to the entitlement model are localized to the
filter engine.
•
Only the client-consumed data is replicated.
Chapter 9
Client expeCtations