How to migrate Delta live table.

Therdpong
New Contributor III

I need guidance on migrating the Delta live table to another pipeline without a full refresh

Hkesharwani
Contributor II

Hi delta live tables are not stored in the metastore they are stored in specified storage location,  Changing the "Target" parameter in the  new pipeline settings will allow you to re-register the tables in a new schema without reprocessing the data. The data will remain in the same location specified in the "Storage location" parameter, and only the table registration in the Hive Metastore will be updated to point to the new schema.

Harshit Kesharwani
Data engineer at Rsystema

Therdpong
New Contributor III

Can i migrate the checkpoint to a new pipeline?

Hkesharwani
Contributor II

Hi, Yes you can use the same checkpoint location in the new pipeline.

Harshit Kesharwani
Data engineer at Rsystema

View solution in original post

Thank you very much

Again please, I remove the table from the old pipeline. but the new pipeline was showing an error already from the old pipeline.


Therdpong_0-1717772462140.png