Creating a sync table from a workspace catalog to a project

Sega2 — Mon, 16 Mar 2026 10:42:23 GMT

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.

Re: Creating a sync table from a workspace catalog to a project

shwetav1407 — Mon, 16 Mar 2026 12:32:51 GMT

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:

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

Re: Creating a sync table from a workspace catalog to a project

Sega2 — Thu, 19 Mar 2026 07:56:12 GMT

Did it, thanks apprecitated!

topic Re: Creating a sync table from a workspace catalog to a project in Data Engineering

Creating a sync table from a workspace catalog to a project

Re: Creating a sync table from a workspace catalog to a project

Re: Creating a sync table from a workspace catalog to a project