Athena connector produces no output when underlying OS is in FIPS mode #33080

Affected module

Ingestion Framework

Describe the bug

After running the metadata agent for Athena in Airflow I see this warning over and over and no data is ingested:

{source_hash.py:188} WARNING - Failed to generate source hash due to - [digital envelope routines: EVP_DigestInit_ex] disabled for FIPS

To Reproduce

Running the metadata agent for Athena in Airflow with FIPS enabled on the OS. I am using RHEL 8, but I expect the same behavior in RHEL 9 or Rocky Linux 9.

Expected behavior

If I disable FIPS mode on the system this will work as expected. I can also disable FIPS for Airflow as a workaround and not have to disable for the entire system. I would expect the same output either way, but Openmetadata is passing weak algorithms to Airflow currently

OS

RHEL 8

Python version

3.12.13

OpenMetadata version

1.12.8

OpenMetadata Ingestion package version

1.12.8.10

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.