Skip to content

[BUG]: Migrate tables errors out when migrating managed table with external storage #2838

@HariGS-DB

Description

@HariGS-DB

Is there an existing issue for this?

  • I have searched the existing issues

Current Behavior

When running a migrate table job for a table which is managed with an external location, the code fails with the error Description: [UPGRADE_NOT_SUPPORTED.NOT_EXTERNAL] Table is not eligible for an upgrade from Hive Metastore to Unity Catalog. Reason: Not an external table. SQLSTATE: 0AKUC

Expected Behavior

For managed table with external storage location the sync command should run with additional clause as "AS EXTERNAL"

Steps To Reproduce

No response

Cloud

AWS

Operating System

macOS

Version

latest via Databricks CLI

Relevant log output

No response

Metadata

Metadata

Assignees

Type

No type

Projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions