Cannot ingest Trino tables residing inside a schema which contains dots

[vverguilov-sym]

Affected module
Python SDK, Ingestion

Describe the bug
Ingesting Trino data fails with the following error:

WARNING  {metadata.Ingestion:sql_column_handler:277} - Unexpected exception getting columns for table [group_access_loaded_files] (schema: 'level1.level2.level3', db: 'trino_db'): (trino.exceptions.TrinoUserError) TrinoUserError(type=USER_ERROR, name=SYNTAX_ERROR, message="Too many dots in table name: level1.level2.level3.table" )

To Reproduce

Try to ingest a Trino table into a schema with multiple dots in its name.

Expected behavior

Ingest Trino tables within a schema containing multiple dots into OpenMetadata.

Version:

• OS: Windows, Linux
• Python version: Python 3.11.14
• OpenMetadata version: 1.11.5, 1.11.6.1
• OpenMetadata Ingestion package version: openmetadata-ingestion[trino]==1.11.6

Additional context