I was looking through this community and spotted this post - my Aha! moment might seem simple, but it definitely made me stop and think late last year when working through potential data access patterns.
The revelation: you can have the same recipient as the provider for a Databricks-to-Databricks Delta Share - meaning you can use Delta Shares within the same workspace you're working in. As a 'built-on' partner, we were trying to solve naming and access challenges when bringing together data from different catalogs for different identities.
Having started my career in data as an Oracle developer, my instinct was to reach for views - but views require ongoing management. Delta Shares took so much of that overhead away from our processes, and the option to alias schemas made data access for the consumer a very smooth experience.