How to migrate Delta live table.

[Therdpong]

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

[Hkesharwani]

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.

[Therdpong]

Can i migrate the checkpoint to a new pipeline?

[Hkesharwani · Accepted solution]

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

[Therdpong]

Thank you very much

[Therdpong]

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