Yes, deduplication at the table level permanently removes duplicate records. There are two main ways to dedupe:
1. Auto-dedupe: This continuously monitors a specified column, keeping the oldest row and deleting duplicates. It's enabled in table settings.
2. Manual column dedupe: You can dedupe a specific column by selecting "Dedupe" from the column header menu. This permanently deletes duplicate rows based on exact string matches.
In both cases, deleted rows cannot be recovered, so it's important to proceed with caution. If you need to undo a deduplication, you'd need to restore from a backup if available.