OpenMetadata icon indicating copy to clipboard operation
OpenMetadata copied to clipboard

Wrong Column Order in Schema page after adding columns to a table

Open datapopcorn opened this issue 1 year ago • 0 comments

Affected module UI

Describe the bug When a new column is added to the table, it appears at the end of the OM Schema rather than in its actual position according to the table's column order.

To Reproduce

  1. Create Table

CREATE TABLE test.table_1 ( id SERIAL PRIMARY KEY, name VARCHAR(100), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, );

  1. enable override metadata and ingest to OM image

  2. Drop Table

DROP TABLE test.table_1;

  1. Create table and add new column

CREATE TABLE test.table_1 ( id SERIAL PRIMARY KEY, name VARCHAR(100), name_2 VARCHAR(10), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, );

  1. ingest to OM image

Expected behavior OM would show the same column order as source table's actual column order

Version:

  • OS: [e.g. iOS]
  • Python version:
  • OpenMetadata version: 1.5.6
  • OpenMetadata Ingestion package version: [e.g. openmetadata-ingestion[docker]==XYZ]

Additional context Add any other context about the problem here.

datapopcorn avatar Oct 14 '24 03:10 datapopcorn