I figured the issue.

Its because of location mismatch. data residing projects are in the US location but computing project datasets are in other location. So the temp table which is trying to create is having issue because of the location mismatch. its resolved when materialization dataset has provided with the same location as data residing dataset.