Preview & Run

running a selection means executing the selection and writing the results to your target data extension how it works run preview docid\ afvlojmpg9lrvabmvjrtl previewing is a safe validation step that allows you to see the results and calculate the record count without writing data to your target data extension it helps you verify data extension joins, column mappings, applied filters, and ensures the underlying sql query executes without errors during a preview, you can view the formatted sql query, inspect the temporary data extension by clicking the "generated x records" link, or halt the process using the "cancel preview" button run the selection running a selection executes the final query and permanently writes the matching results to your target data extension once you click the "run" button, the temporary data extension used for the preview is automatically deleted if you are satisfied with the results of your preview hit the run button on the selection now you will be redirected to the home page, where you can see the status of your selection change it will move from an orange processing icon to a green checkmark when completed if the query fails, a red warning icon appears which you can click to get the details of the error as soon as the selection is queued, you'll see the last run column be updated with the current date time once the selection is completed, you'll see the calculation of the amount record goes through the same stages once completed, in the records column you'll see the number of records in your result all the results of your selections are now written to the target data extension monitoring and execution status after initiating a run, you can track its progress on the home page, where the status will transition from an orange processing icon to a green checkmark upon successful completion because unaric segment manages query activities through the salesforce marketing cloud api, you cannot stop the execution of a selection once the final run is initiated if a run fails, a red warning icon appears, the entire transaction is reverted, and no results are written to the target data extension for more information, see selection status icon guide docid\ lm4lgs0rlcj2e52eafxhg selection fails if a selection fails to run, the whole transaction will be reverted and no results will be written to your target data extension selections fails are notified by a red warning icon on the overview page next to the selection name click on the red warning icon to see the details of the error if you executed a selection it's not possible to stop the execution until the selection provides a result as unaric segment manages query activities through sfmc api, we are limited to its functionality, and currently, stopping the execution of queries is not doable if you are having issues with a selection execution or need further assistance, reach out to support at support\@deselect com mailto\ support\@deselect com preview and run results count differs in some cases, your preview and run results count might differ this can be due to preview data is not updated data may have been updated between generating the preview and running the selection as a result, the preview count may not reflect the latest data, potentially causing a discrepancy between the preview and run data verify the data action of your selection in case your selection's data action is set to 'update' or "append" , unaric segment will keep adding more data in a data extension that already contains data the preview uses a temporary table that is completely empty and only getting new records, which explains why the count is different to solve this, run the preview again this will update the data to the latest version and align it with the run results