Clickhouse HTTPS protocol not supported

[ulixius9]

Affected module
Ingestion Framework

Describe the bug
When Ingesting Clickhouse with connection options as protocol:https which is supported by the clickhouse-sqlalchemy package in the connection url, getting the following error

Issue was reported here.

Traceback (most recent call last):
  File "/Users/mayursingal/Desktop/ulixius1/OpenMetadata/ingestion/tests/unit/test_source_connection.py", line 339, in test_clickhouse_url
    e = get_connection(clickhouse_conn_obj)
  File "/Library/Developer/CommandLineTools/Library/Frameworks/Python3.framework/Versions/3.8/lib/python3.8/functools.py", line 875, in wrapper
    return dispatch(args[0].__class__)(*args, **kw)
  File "/Users/mayursingal/Desktop/ulixius1/OpenMetadata/venv/lib/python3.8/site-packages/metadata/utils/connections.py", line 124, in get_connection
    return create_generic_connection(connection, verbose)
  File "/Users/mayursingal/Desktop/ulixius1/OpenMetadata/venv/lib/python3.8/site-packages/metadata/utils/connections.py", line 106, in create_generic_connection
    engine = create_engine(
  File "<string>", line 2, in create_engine
  File "/Users/mayursingal/Desktop/ulixius1/OpenMetadata/venv/lib/python3.8/site-packages/sqlalchemy/util/deprecations.py", line 309, in warned
    return fn(*args, **kwargs)
  File "/Users/mayursingal/Desktop/ulixius1/OpenMetadata/venv/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 648, in create_engine
    raise TypeError(
TypeError: Invalid argument(s) 'protocol' sent to create_engine(), using configuration ClickHouseDialect_http/QueuePool/Engine.  Please check that the keyword arguments are appropriate for this combination of components.

[pmbrull]

fixed by #5264