How can I check how many instances of each snapshot a given datahub deployment has directly from the database?

There is 1 metadata aspects table that stores all metadata... you can connect via a tool like MySQLWorkbench and inspect the table directly (this is what i've been doing)