SAP HANA Table Functions Are Not Ingested and Break Lineage for Dependent Views

[Prajwal214]

Affected module
Does it impact the UI, backend or Ingestion Framework? - ingestion

Describe the bug
A clear and concise description of what the bug is.

• SAP HANA Table Functions (tables defined by SQL scripts) are currently not ingested because they are not listed as regular tables or views. Instead, they appear as functions in:

SYS.FUNCTIONS

with the filter:

FUNCTION_USAGE_TYPE = 'TABLE'

The SQL script defining the table function is available in the:

DEFINITION

• Since these table functions are missing from metadata ingestion, lineage ingestion fails for any views that reference them.
• Additionally, lineage fails due to a missing TABLE_FUNCTION key in the ViewType Enum, which prevents proper resolution of these objects.

To Reproduce

Screenshots or steps to reproduce

Expected behavior
A clear and concise description of what you expected to happen.

• Table functions should be:
• Detected from SYS.FUNCTIONS where FUNCTION_USAGE_TYPE='TABLE'
• Ingested as a supported entity type
• Their SQL from the DEFINITION column should be parsed for lineage

ViewType Enum should include:

TABLE_FUNCTION

Views referencing table functions should have successful lineage resolution

Version:

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

Additional context
Add any other context about the problem here.