topic Move managed DLT table from one schema to another schema in Databricks in Data Engineering

Move managed DLT table from one schema to another schema in Databricks

a_t_h_i — Wed, 09 Aug 2023 16:28:09 GMT

I have a DLT table in schema A which is being loaded by DLT pipeline.

I want to move the table from schema A to schema B, and repoint my existing DLT pipeline to table in schema B. also I need to avoid full reload in DLT pipeline on table in Schema B.

Anybody had similar situation?

Re: Move managed DLT table from one schema to another schema in Databricks

Tharun-Kumar — Fri, 11 Aug 2023 05:05:30 GMT

@a_t_h_i

This feature is being actively worked upon by our Engineers. The plan is to change the schema name in the DLT pipeline settings and DLT will move the managed DLT table to the other schema.

Re: Move managed DLT table from one schema to another schema in Databricks

ThuanVanNguyen — Mon, 21 Oct 2024 08:12:59 GMT

Any updates on this since we are having this requirement

Re: Move managed DLT table from one schema to another schema in Databricks

ChrisLawford_n1 — Wed, 20 Aug 2025 09:35:05 GMT

Any progress on this ?
Did you find a solution ?

Re: Move managed DLT table from one schema to another schema in Databricks

ManojkMohan — Wed, 20 Aug 2025 12:38:51 GMT

Have you tried the below

Pause or Stop the DLT Pipeline

Prevent new writes while moving the table.

2.Move the Table in Metastore

DLT uses Delta tables under the hood, so you can move the table in the metastore without copying data:

ALTER TABLE schemaA.tableX
SET LOCATION 'abfss://container@storage/path/...tableX';
ALTER TABLE schemaA.tableX
RENAME TO schemaB.tableX;

SET LOCATION points to the existing Delta storage location for the new schema.

3. Update the DLT Pipeline

Edit the DLT pipeline code (or the pipeline notebook) to point to the new fully qualified table name @Dlt.table(
name="schemaB.tableX", # updated schema
comment="Moved from schemaA"
)
def tableX():
return dlt.read("schemaB.tableX")

4. Resume the DLT Pipeline

Start the pipeline

5. Verify

SELECT COUNT(*) FROM schemaB.tableX;

Let me know here if the above is effective