ucx icon indicating copy to clipboard operation
ucx copied to clipboard

[FEATURE] Add option to convert external table to managed table

Open qziyuan opened this issue 10 months ago • 0 comments

Is there an existing issue for this?

  • [x] I have searched the existing issues

Problem statement

This issue is a place holder for now, because the upstream feature is not released yet.

We soon will have a feature to in place convert UC external table to UC managed table with command like

ALTER TABLE main.default.ext_tbl1 SET UC_MANAGED [WITH READ CLONES]

More details of this feature can be found here

UCX should help customers to convert their UC external tables.

Proposed Solution

  1. Add a new workflow to convert migrated UC external tables to UC managed tables. Customers can decide if they want to run this workflow.
  2. Add a step at the end of table migration workflow to further convert the just migrated external table to managed table. Customer can decide if this step will be triggered or not.

Additional Context

No response

qziyuan avatar Mar 17 '25 16:03 qziyuan