Merge Queries

[roryor11]

Hey,

We are trying to do a merge query but it isn't producing any results. We are joining the explores on an ID which is present in both models. The number of rows it's producing is less than 5,000.

One of the models is restricted because of PII data being present in it. Would this cause issues with the merge query?

There user has full access to both explores.

Thanks,
Rory

[GavinW]

It would be difficult to diagnose this without access to your instance for testing. When you say the model is 'restricted', what do you mean exactly? You might be right that this is an avenue to consider as the root of the problem.