Move delta live tables amongst schemas within a catalog

meenali
New Contributor

Can we Move delta live tables amongst schemas within a catalog

Alberto_Umana
Databricks Employee
Databricks Employee

Hello @meenali,

It is currently not possible to move Delta Live Tables (DLT) amongst schemas within a catalog directly.

Databricks recommends configuring Delta Live Tables pipelines with Unity Catalog. Pipelines configured with Unity Catalog publish all defined materialized views and streaming tables to the specified catalog and schema. However, once a pipeline is set to publish to a specific schema, it cannot dynamically move tables to another schema within the same catalog

Mounika_Tarigop
Databricks Employee
Databricks Employee

Moving Delta Live Tables (DLT) among schemas within a catalog is a feature that is currently not directly supported.

View solution in original post

ChrisLawford_n1
Contributor II

Do you have a mechanism to do this ?
Any aspects that are accessible to allow this to be possible?