I am trying to test out DataHub and connect to a SQL Server Database. My connection information is as follows: source: type: mssql config: host_port: '***********************:1433' database: Prod username: **************************** include_views: true include_tables: true profiling: enabled: true profile_table_level_only: false stateful_ingestion: enabled: true password: ******************* How do enable encryption in this setup? I have looked at documentation but it appears that maybe the only way to do it is via ODBC. Any help someone could provide would be appreciated. I have been using the documentation from at https://datahubproject.io/docs/generated/ingestion/sources/mssql Here is the error:

Command failed: Failed to configure the source (mssql): (pytds.tds_base.Error) Client does not have encryption enabled but it is required by server, enable encryption and try connecting again

@gray-shoe-75895 might be able to speak to this!

Yes mssql encryption currently requires using ODBC. The latest versions have experimental support for CA files using pytds (see the sample recipe here https://datahubproject.io/docs/next/generated/ingestion/sources/mssql#starter-recipe), but it's something the community added and I haven't tested myself yet