[Feature Request] Views features wishlist

[peternied]

• This issue is not used, see [RFC] View feature wishlist #12424

Is your feature request related to a problem? Please describe

OpenSearch has a feature Views that introduce a powerful way to simplify data access and manipulation by providing a virtual layer over one or more indices. As is currently implemented there is lots of potential scenarios. This issue will serve as a way to capture all of these requests into a single spot so folks that wish to contribute have context on the kinds of scenarios and where overlap may occur.

Feature list (unordered)

• Use views as part of Index Pattern in OpenSearch Dashboards
  • In OpenSearch Dashboards an component called index pattern is required to associate visualizations with data. This creates a gap in the backend data model vs the visualization front end. Making a single backend supported object would simplify the user model and
• Document Security
  • While the security plugin supports document level security and field level security, Views could serve as a focal point for this configuration rather than roles.
  • Related Issues
    • [FEATURE] Extend field level security security#2834
    • [BUG] Role with Document-level security (DLS) masks more generic permissions security#3773
    • [BUG] dfm_empty_overrides_all removes DLS also if other role has no explicit data/read permission security#3963
    • [BUG] "Field level security" and "Field masking definitions" don't work together with "Document level security" security#3274
• Support view resource permission
  • Expand OpenSearch to allow for granting permission to individual views as is done with indices. This would enable permission grants for other non-index objects such as resources in plugins.
  • Related Issues
    • Resource permission management security#3890
• Pipelines integration
  • A suite of composable processers that transform search request and search responses is expanded to support views.
  • Related Issues
    • [Search Pipelines] Modify search pipeline behavior based on authenticated user/role #11053
    • [Search Pipelines] Add a processor that provides fine-grained control over what queries are allowed #10938
    • Configurable query logging using search pipelines #11188
    • [Search Pipelines] How should we handle default pipelines for multiple indices? Aliases? Wildcards? #7512
• Constraint cluster resources
  • OpenSearch systems have limited CPU/Memory and cluster operators could use views as a single place to declare cluster resource limits between different query workloads
  • Related Issues
    • [PROPOSAL][Query Sandboxing] Query Sandboxing high level approach. #11173

Additional context

• Views RFC Data projection with views #6181

[peternied]

[Triage - attendees 1 2 3 4 5 6]
@peternied Please convert this into an RFC format or a meta issue.

[peternied]

• Please see [RFC] View feature wishlist #12424 instead of this issue.