They should never be propagated into Looker and Tableau. This is more indicative of a poorly designed architecture rather than 'nice theory'. Hash keys are tools to join tables ALWAYS done in platform, not in BI tool.