Re: Creating a sync table from a workspace catalog...

shwetav1407 · ‎03-16-2026

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:

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

View solution in original post