How to query deleted records on Salesforce

[#1]

Hi,

I'm trying to use "ALL ROWS" keyword in the Sql code, but it gives me the following error "ALL ROWS not allowed in this context", while using the Salesforce connector.

[srchilukoori · Accepted solution]

you should use Select_ALL and IsDeleted=True as a condition.

[neha_potdar]

Hi,

What about deletes in incremental loads? This solution of IsDeleted = true holds good for full load.

[14864011]

Hi is it possible that you be more specific about how to use Select_ALL?  Thank you so much for your help!