is this the expected behaviour, and is there any way to get the tableau custom sql to map to the real sql server table, with column level lineage ?

Hey @damp-computer-35583 I would like to help if you are still facing the issue. Why you see two different entities might be due the case-sensitivity of dataset urns. You can use

convert_urns_to_lowercase: True

in sql server ingestion recipe so that the tableau generated urn aligns with sql server generated urn.

Hello, we found a few issues, and put in a PR, https://github.com/datahub-project/datahub/pull/9838