cancel
Showing results for 
Search instead for 
Did you mean: 
Data Governance
Join discussions on data governance practices, compliance, and security within the Databricks Community. Exchange strategies and insights to ensure data integrity and regulatory compliance.
cancel
Showing results for 
Search instead for 
Did you mean: 

Delta Sharing - 'No data' in schema

Anske
New Contributor III

When creating a data share in my Databricks workspace, in the step Add data assets, one of my schemas in Unity Catalog shows 'No data' when expanding. If I expand the same schema in Unity Catalog explorer, it shows lots of tables and all tables contain data (which is shown in the preview if I attach a compute). The tables were created with in a Databricks notebook run, and are not internal tables (not shortcuts or federated queries or anything), and they were created in exactly the same way as the tables in my other schema, which shows the tables just fine when expanding in the add data assets step. See attached screenshots.

I own all catalogs, schemas and tables in the schema. Anyone seen this before, or any suggestions to fix it?

2 REPLIES 2

Anske
New Contributor III

Hi,

sorry for the late reply, I went on holiday :-). 

The reason no tables are expanding is because the schema only contains materialized views and streaming tables, both of which are not supported in Delta Sharing (yet). Hopefully this answer can help someone else running into the same thing.

 

MathieuDB
Databricks Employee
Databricks Employee

Hello @Anske ,

This feature is currently in private preview. You should contact your account team to have it enabled in your workspace(s).

Requirements

  • Databricks Runtime (DBR) 13.3 or above
  • Recipients must use Serverless SQL warehouse to query a shared streaming table if the sharing is across accounts
  • Recipients can only use a UC-trusted compute (SQL warehouses + Shared Cluster) to query a shared streaming table if the sharing is within the same account.

 

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local community—sign up today to get started!

Sign Up Now