Skip to content

Table Diff fails for Azure SQL as secondary source with missing connection parameters #31044

Description

@Prajwal214

Affected module

Data Quality / Profiler

Describe the bug

The Table Diff test is expected to support comparing tables across different data sources (e.g., Snowflake ↔ Azure SQL). However, when Azure SQL is configured as one of the sources, the test fails during connection initialization.

To Reproduce

Error

TypeError: MsSQL.__init__() missing 4 required positional arguments:
'host', 'port', 'user', and 'password'

Stack trace:

File ".../tableDiff.py", line 339, in get_incomparable_columns
table2 = data_diff.connect_to_table(...)
File ".../data_diff/databases/_connect.py", line 210, in connect_to_uri
db = cls(thread_count=thread_count, **kw, **kwargs)
TypeError: MsSQL.__init__() missing 4 required positional arguments:
'host', 'port', 'user', and 'password'

Expected behavior

Table Diff should successfully initialize the Azure SQL connection and perform the comparison between the two data sources.

OS

No response

Python version

No response

OpenMetadata version

1.13.3

OpenMetadata Ingestion package version

No response

Additional context

No response

Pre-submission checklist

  • I searched for duplicate issues.
  • I removed credentials, hostnames, emails, and other sensitive data from logs and config.

Metadata

Metadata

Assignees

Labels

bugSomething isn't workingcustomer

Type

Projects

Status
No status
Status
No status

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions