Hi @Prajakta
Are you getting server timeout issue , when running QuickSight SPICE refresh when joining messages & leads table and whats the underlying datasource ?
one alternative approach is to create multiple datasets and then do the join in QuickSight SPICE
- create one dataset for (leads, customers, accounts) tables joined and enable SPICE refresh
- create second dataset with message table and add the first created dataset and establish the join .
In addition please look into the below post for sample approach to implement the dynamic lookup in QuickSight.