Skip to content

[BUG]: View Migrator omits a view's column list argument #1345

@danielm-db

Description

@danielm-db

Is there an existing issue for this?

  • I have searched the existing issues

Current Behavior

Using the view text instead of a show create table statement will create views; however, if the view was created with the argument column_list, it will result in an erroneous view with no errors raised.

Here is an example of a view created using the argument column list, in the image it is represented as (name,user_id), note how leveraging the view text completely resulted in a successful view creation but erroneous column names.
image

Expected Behavior

If a view was created and used the argument column_list, the migratory should recreate the view using the column list argument. (can be extracted using SHOW CREATE TABLE instead of the DESC EXTENDED, View Text logic.

Steps To Reproduce

No response

Cloud

Azure

Operating System

macOS

Version

latest via Databricks CLI

Relevant log output

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    migrate/codeAbstract Syntax Trees and other dark magicmigrate/externalgo/uc/upgrade SYNC EXTERNAL TABLES step

    Type

    No type

    Projects

    Status

    No status

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions