[Bug]: Function 'table_exists()' returning false when the table does exist in database

[BuzzCutNorman]

Singer SDK Version

0.13.1

Python Version

3.9

Bug scope

Targets (data type handling, batching, SQL object generation, etc.)

Operating System

Windows

Description

When an SDK target checks to see if a table exists with table_exists() it always come back as false if the full_table_name is in schema.table format or database.schema.table format. That is happening because the function sqlalchemy.engine.reflection.Inspector.has_table is not able to deal with two part of three part table names.

Code

def table_exists(self, full_table_name: str) -> bool:
        """Determine if the target table already exists.

        Args:
            full_table_name: the target table name.

        Returns:
            True if table exists, False if not, None if unsure or undetectable.
        """
        return cast(
            bool,
            sqlalchemy.inspect(self._engine).has_table(full_table_name),
        )