Oracle profiler ingestion returns invalid identifier error

open-metadata / OpenMetadata

OpenMetadata is a unified metadata platform for data discovery, data observability, and data governance powered by a central metadata repository, in-depth column level lineage, and seamless team collaboration.

https://open-metadata.org

Apache License 2.0

5.28k stars 997 forks source link

Oracle profiler ingestion returns invalid identifier error #16497

Closed vithushanms closed 1 month ago

vithushanms commented 4 months ago

Affected module When I do the profiler ingestion with Oracle DB, I am getting the following error

Describe the bug The issue is with the query being generated. The following column name has to be wrapped within quotes, but here the quotes are missing in the OM query.

You can see the same query working after I added the double qoutes.

Version:

OS: ubuntu
Python version: 3.8
OpenMetadata version: tested in both 1.2.5 and 1.3.1
OpenMetadata Ingestion package version: 1.2.5

vithushanms commented 3 months ago

Are there any updates on this team?

harshach commented 3 months ago

@TeddyCr can you review this

sushi30 commented 2 months ago

@vithushanms can you provide a DDL for the failing table?

ayush-shah commented 1 month ago

We are not able to reproduce this error, if @vithushanms can provide the DDL, that would be great, we will validate the same and open the issue if reproduced, till then, closing this issue.

EDIT: Also, @vithushanms can you try the same if it can be reproduced in the latest version of OM.