Welcome to BQdu
If you're using Google BigQuery as part of your daily work, chances you're asking yourself questions like 'How much data do I have in BigQuery?' or 'Which datasets hold the most data in my project' or maybe even 'What tables are largest within my dataset' all the time.
Inspired by Linux's 'du', BQdu was created as small service which does exactly what 'du' does for folders but only for Google BigQuery's projects, datasets and tables.
BQdu will scan (using BigQuery API) your project/s and display a treemap visualization of your project, datasets and tables. You can mouse-over each tile and get a nice tooltip with information about the entity you're pointing to. Tiles are sized according to their relative size compared to the dataset (and datasets to projects).
Want to give it a run? You can access BQdu at bqdu.info
Some Fequently Asked Questions:
- The app will ask you to login. Due to nuances of BigQuery API, it will ask you to give it access to your BigQuery project. More info.
- Running BQdu won't increase your spendings on BigQuery . BQdu just reads your BigQuery metadata and therefore it's 100% free
- BQdu access the following BigQuery API on your behalf:
- GET https://www.googleapis.com/bigquery/v2/projects
- GET https://www.googleapis.com/bigquery/v2/projects/projectId/datasets
- GET https://www.googleapis.com/bigquery/v2/projects/projectId/datasets/datasetId/tables
- GET https://www.googleapis.com/bigquery/v2/projects/projectId/datasets/datasetId/tables/tableId
Authors and Contributors
BQdu was created by Vadim Solovey - Google Developer Expert and CTO of DoIT International.
Privacy Policy
You can see our privacy policy at Privacy Policy