Druid dataset URN is not generated correctly

[MrdjanPoletanovic]

Describe the bug
When I sync Druid metadata, the URNs are generated using only the dataset name. For example, if the Druid dataset is named 'test-dataset', the URN is created as urn:li:dataset:(urn:li:dataPlatform:druid,test-dataset,PROD) without including a schema name before the dataset name. However, if I add the platform_instance property (e.g., marketing) in the Druid metadata spec configuration, the URN is created as urn:li:dataset:(urn:li:dataPlatform:druid,marketing.marketing.adevents,PROD), repeating the platform_instance twice.

Why is this an issue? When I try to sync Superset dashboards, Datahub cannot establish lineages between them due to the inconsistency in how the URNs are generated.

To Reproduce
Steps to reproduce the behavior:

1. Go to 'Ingestion' tab and specify Druid configuration
2. Go to imported datasets and select one of them
3. Look at the generated URN in browser url

Expected behavior
I believe the expected behavior is for the dataset name to be concatenated with the schema name. For example: urn:li:dataset:(urn:li:dataPlatform:druid,druid.test-dataset,PROD) if the schema name is druid, or urn:li:dataset:(urn:li:dataPlatform:druid,segments.test-dataset,PROD) if the schema name is segments.

Desktop (please complete the following information):

• Browser : Firefox
• Chart version: 0.14.0.2

** Additional Context **

• Check the file and method get_identifier in Druid config: https://github.com/datahub-project/datahub/blob/master/metadata-ingestion/src/datahub/ingestion/source/sql/druid.py#L52
• Check the generating datasets URN in SqlAlchemySource class method _process_table: https://github.com/datahub-project/datahub/blob/master/metadata-ingestion/src/datahub/ingestion/source/sql/sql_common.py#L767