Looker Field Spotlight - Deleted Data Overview
The Client Model and Project Descriptor Model are the two models that contain deleted data. However, there are instances where deleted data fields may be included in other models.
To ensure that reports produce the expected results, use the following tips to identify deleted fields and filter appropriately.
Searching for Deleted Fields in Looker
By searching "deleted" in the "Find a Field" search bar in Looker, you can locate fields associated with data that may have been deleted. These deleted data fields can be included in Looks to review if data has been deleted.
Filtering Deleted Fields in Looker
Additionally, once the fields from applicable views are identified, Looker users can utilize filtering (basic filters or custom filters) within a Look using these "Deleted (Yes/No)" fields to include/exclude deleted data based on your analysis needs. This enables more precise control when creating content allowing you to either include or ignore records that are marked as deleted, depending on your business logic or reporting requirements.