How to understand which materialization needs to be used.

Help
,
1

at most 55 slices are allowed in a query, current number: 85
HINT: rewrite your query
Getting this error