Problem in ingest from MSSQL database with schemas with dots in schema names

[HodaGolgir]

Affected module
Ingestion Framework

Describe the bug
Problem in ingest from MSSSQL database with schemas with dots in schema names

To Reproduce

I’ve tried to ingest from MSSSQL database and I have error when it is ingested tables from schema with name like [bof.ams] .
it can not be recognized as schema, I have this error message :

[2023-10-22, 10:56:58 UTC] {common_db_source.py:297} WARNING - Fetching tables names failed for schema bof.ams due to - (pytds.tds_base.OperationalError) Database 'bof' does not exist. Make sure that the name is entered correctly.
[SQL: use bof]
(Background on this error at: https://sqlalche.me/e/14/e3q8)

Expected behavior
Identify schemas with dots in schema names in ingest from MSSSQL database

Version:

• OS:
• Python version: 3.8
• OpenMetadata version:1.1.7
• OpenMetadata Ingestion package version:openmetadata-ingestion[docker]==1.1.7

Additional context
Reflecting the discussion on Slack:
https://app.slack.com/client/T02BVTLN3G8/later

[pmbrull]

The main problem comes from the internal logic in decorated functions within the MSSQL SQA dialect.

The function @_db_plus_owner_listing picks up the schema that we send, e.g., inspector.get_table_names(schema) and tries to identify if we are passing a database.schema to "prepare" the inspector to run the queries on the required db.

For the case where our schemas are named as hello.world, then this process wrongly assumes that hello a database, which kills the processing.

We need to find a generic way to handle this behavior