Viewing deleted records

By default, deleted records are not displayed in Compass.
  1. In Data Fabric, select Data Lake > Compass.
  2. Click the three-dot icon next to the table name and select SQL > SELECT (Include Deleted Rows).
  3. Specify the query, including the WHERE ToDelete condition in the query. For example, if you defined value 1 to indicate that a record is deleted, then include this condition: 
    WHERE ToDelete = 1
  4. Click Run Query.
    The Results table shows all records that have been deleted.