Creating a sync table from a workspace catalog to a project

[Sega2]

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.

[sv_databricks · Accepted solution]

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:

GRANT USE_SCHEMA ON SCHEMA your_catalog.your_schema TO `your-email@domain.com`;

GRANT CREATE_TABLE ON SCHEMA your_catalog.your_schema TO `your-email@domain.com`;

Once those grants are in place, the db should appear in the Destination dropdown.

[Sega2]

Did it, thanks apprecitated!