Creating a sync table from a workspace catalog to a project

Sega2
New Contributor III

a week ago

We have a table in a workspace we would like to sync to a project. And we can fine choose the database project but we cannot see the database in the first section (Destination), see attached file.

 

 

 

 
 

 

 

 

Labels:
Preview file
64 KB
0 Kudos

sv_databricks
Databricks Employee
Databricks Employee

a week ago

Hi @Sega2,
Thanks for sharing the screenshot — this helps clarify what's happening. There are two likely reasons why you're not seeing your database in the Destination section:
1. The source table must be in Unity Catalog
Synced tables only support Unity Catalog sources (Delta, Iceberg, Views, Materialized Views). If your table lives in the workspace-level hive_metastore catalog, it won't be eligible for sync. You would need to migrate it to Unity Catalog first before creating a synced table.
2. The Destination catalog/schema list is filtered by permissions
Even if your table is in Unity Catalog, the Destination Name dropdown only shows schemas where you have both USE_SCHEMA and CREATE_TABLE privileges.
From the official docs (link)
The catalog and schema lists only include Unity Catalog schemas where the current user has USE_SCHEMA and CREATE_TABLE privileges. If you don't see a schema you expect, confirm your permissions with your catalog admin.

To fix this, ask your catalog admin to run:

View solution in original post

0 Kudos

Sega2
New Contributor III
In response to sv_databricks

Thursday

Did it, thanks apprecitated!

0 Kudos