FWIW, a JSON dump of the BQ mirror is available in the Danbooru2017 torrent I released last month: /forum_posts/142978

I'm trying to make a query to see which character tags are most used for the given copyright tag (i.e., the most popular characters). How would I make this?

Is it still active?

SELECT count(*) FROM [danbooru-data:danbooru.posts]

returns 0.

@Allynay, sorry to bother you again but the BigQuery database is currently empty. The details tab shows Last Modified: today, so I guess the script still runs daily but fails immediately for some reason.

@norainu yep, I’m aware. I’ve lost access to the database the dump is based on and I’m working with Albert to restore access. Unfortunately the script did not fail at all gracefully when it discovered it couldn’t connect so BQ is empty until this is fixed.

Okay, got access again, BQ is up and running once more!

I'm glad to hear that! I was starting to work on a Danbooru2018 dump, and the BQ mirror being broken was the biggest obstacle.

Clicking the bigtable link gives the error "Unable to find table: danbooru-data:danbooru.posts"

Seems to be working now. There's timestamps up to 2020, and exporting & downloading the whole table yields JSONs which look ok.