A complete solution for open data platforms, enterprise data catalogs, data lakes and data management. Open source, mature, fully-featured and production ready.

DataHub

image.png

:wave: Hi Team! I'm trying to delete some dataset from my datahub instance...  I ran `datahub delete -query AuM` there's one match for the query but it's not deleted... I was able to delete everything else but for some reason there are two dataset that refuse to be deleted  :shrug: ... do you want me to provide you more debug information before I nuke the DB?

Hey. Do you see any matching aspects for this entity in the mysql db?

Thanks Dexter! I will take a look... tomorrow. I need to ask IT to expose the db service...

<@U02HEFC1WAK>: what does `datahub get --urn &lt;urn&gt;` return?

```{
  "value": {
    "com.linkedin.metadata.snapshot.DatasetSnapshot": {
      "aspects": [
        {
          "com.linkedin.metadata.key.DatasetKey": {
            "name": "AuM",
            "origin": "PROD",
            "platform": "urn:li:dataPlatform:quicksight"
          }
        }
      ],
      "urn": "urn:li:dataset:(urn:li:dataPlatform:quicksight,AuM,PROD)"
    }
  }
}```

I even tried to delete it using the urn but it says `Took 11 seconds to delete 0 rows for 1 entities`

let’s try a soft delete followed by a hard delete

so `datahub delete --urn &lt;urn&gt; --soft`

then `datahub get --urn &lt;urn&gt;` to see what you get back

and then `datahub delete --urn &lt;urn&gt; --hard`

after the regular delete, now I got `Took 2.47 seconds to delete 4 rows for 1 entities`

and it's not accepting the `hard` parameter... I'm using version `version 0.8.17.0`

0.8.17.1 has the —hard param and defaults to —soft deletes. 

It seems like there are some corner cases with deletes that still need more hardening. 