Table Diffs Fails on SAP Hana Databases

[prakharb10]

Affected module
Ingestion Framework

Describe the bug
The supported dialects for Table Diffs includes SAP Hana as listed here:

OpenMetadata/ingestion/src/metadata/data_quality/validations/table/sqlalchemy/tableDiff.py

Lines 62 to 73 in 24b668a

	SUPPORTED_DIALECTS = [
	Dialects.Snowflake,
	Dialects.BigQuery,
	Dialects.Athena,
	Dialects.Redshift,
	Dialects.Postgres,
	Dialects.MySQL,
	Dialects.MSSQL,
	Dialects.Oracle,
	Dialects.Trino,
	SapHanaScheme.hana.value,
	]

and in the docs. However, I get an error with the message:

ERROR - Unexpected error while running the table diff test: Scheme 'hana' currently not supported

which comes from data-diff. It is clear that data-diff does not support Hana:

https://github.com/datafold/data-diff/blob/1410c6cd0b915ae24a15e03a7de15ff41beebaf0/data_diff/databases/_connect.py#L79-L93

To Reproduce

Setup a Compare 2 Tables for Differences test between a SAP Hana table and a BigQuery table.

Expected behavior

The table difference should run and output the data.

Version:

• OS: Ubuntu 22.04
• Python version: 3.11
• OpenMetadata version: 1.6.1
• OpenMetadata Ingestion package version: docker.getcollate.io/openmetadata/ingestion:1.6.1

Additional context

None