[FEATURE]: Add CTAS table migration function

[qziyuan]

Is there an existing issue for this?

• I have searched the existing issues

Problem statement

Parent issues:

• [FEATURE]: Migrate external tables not supported by the "sync" command #889
• [FEATURE]: Connect _migrate_table_create_ctas to migrate-tables workflow #332

When migrate managed dbfs root non-delta tables, and certain external tables, we need to run CTAS.

Proposed Solution

• Create a function that can create a UC table using CTAS.
• The CTAS should preserve the partition columns if any.
• The function should be able to be used in either managed or external table migration. In case, external table migration, it should be able to create the table in a provided table location. The location will be passed in by the migration function who calls this CTAS function.

Additional Context

No response

[nfx]

@qziyuan isn't it a duplicate of #332?..

[qziyuan]

@qziyuan isn't it a duplicate of #332?..

@nfx I put the #332 as a parent issue. This issue is meant to create a CTAS function that can be reused by both #332 and #889. Once this issue is completed, what left in #332 is to add a workflow task and calls this CTAS function.