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

DataHub

Hi I am curious where are `datasetProfile` aspect physically in?
I am seeing the dataset stats in the UI. I don't see them in db
```mysql&gt; select * from metadata_aspect_v2 where aspect='datasetProfile'\G
Empty set (0.00 sec)```

weird.. so you see stats on datasets in the UI but nothing shows up from that query above?

I'm curious why you have a `\G` at the end there instead of just finishing with a `;`?

Thanks <@U03BEML16LB> Yes. I see the stats but nothing showed in the mysql query

For \G
<https://pento.net/2009/02/27/the-g-modifier-in-the-mysql-command-line-client/#:~:text=A%20little%20publicized%2C%20but%20exceedingly,query%20with%20'%5CG'>.

gotcha - and thanks for that! learn something new every day.

could you post a screenshot of your stats tab on the entity you're looking for? and maybe we can try a query to get all aspects for that entity?

`select * from metadata_aspect_v2 where urn=&lt;entity_urn&gt;;`

In a meeting, will reply you in 30 min. Sorry

Screen Shot 2022-06-15 at 2.53.06 PM.png

<https://gist.github.com/wizardxz/19c94b13cea03e421b5a28ec29787611>

after looking at your gist it appears like we're getting `numRows` from the `schemaMetadata` aspect...

dataset Profiles is stored in ES only, not mysql