Louis_Frolio
Databricks Employee
Databricks Employee

‎06-03-2025 12:53 PM

Delta Sharing supports view sharing, but certain restrictions need to be considered. Views can be shared via Databricks-to-Databricks Delta Sharing, using Unity Catalog. Shared views must be defined on Delta tables or other shareable views and can only be queried under specific configurations. However, views referencing other shared tables or views are not supported.
The error "DS_MATERIALIZATION_QUERY_FAILED" indicates that the materialization of the shared asset (view) failed due to access or permissions issues in the materialization workspace. Cross-account view sharing requires serverless compute environments as views rely on materialization mechanisms to resolve their definitions.
 
Steps to Resolve the Issue: 1. Confirm Required Configurations: Ensure that the recipient environment is using a trusted compute such as a Serverless SQL warehouse. Views cannot benefit from shared-table materialization due to current technical limitations.
  1. Override Materialization Workspace: Contact Databricks support to override the materialization workspace if the shared asset's materialization persists in failing.
  2. Verify Permissions: Check that the system service principal has the required permissions to access referenced tables or views. If permission issues exist, work with the data provider to resolve them.
  3. Follow Naming Guidelines: Make sure there are no catalog name conflicts between the provider-side and recipient-side namespaces.
  4. Investigate Advanced Options: Consider dynamic fine-grained access controls or adjusting the filtering fleet implementation for shared views as an alternative approach.
Hope this helps, Lou.