Hubert-Dudek
Databricks MVP

‎02-02-2022 06:19 AM

  • Just copy all data and than alter table location:
ALTER TABLE table_name [PARTITION partition_spec] SET LOCATION 'new_location';

  • Alternatively create new table in new location and than use INSERT INTO SELECT to move data

My blog: https://databrickster.medium.com/