Why Do Salesforce Formula Models Return Fewer Records Than the Corresponding Source Table?

Question

Why do Salesforce formula models return fewer records than I can see in the corresponding source table?

Environment

Connector: Salesforce

Answer

The formula models we produce in the SALESFORCE_FORMULA_MODEL table filter out deleted records automatically. The SQL in each model includes the following clause: WHERE NOT "mt._FIVETRAN_DELETED";. As a result, the models may return fewer records than you can see in the corresponding source table.