Data Blaze - Duplicate (Dupe) check on primary key

I import a lot of data into Datablaze that sometimes contains duplicate records. I would love to have ability to run a dupe check on primary key so I can easily find my dupes. <3

You can use a Text Blaze snippet and BSQL to help identify duplicates.

Here is an example. Click on the command to see the BSQL that does the duplicate check:

Names that are duplicated: {dbselect: SELECT
Name,
countagg() as entry_count
FROM Table1
GROUP BY Name
HAVING countagg() > 1; space=id; name=duplicates; multiple=yes}
{=duplicates}