cBioPortal Public Database Dumps

Weekly exports of the cBioPortal public database, available for download and self-hosting.

How to download and restore (ClickHouse)

Pick a dump below and download the Parquet files you need. Each table is a separate file, so you can take only the tables you care about.
Run schema.sql against your ClickHouse instance to create all tables and views:
```
clickhouse-client --queries-file schema.sql
```

Load each Parquet file into the corresponding table:

clickhouse-client --query "
  INSERT INTO <database>.<table>
  SELECT * FROM file('<table>.parquet', 'Parquet')
"

Parameterized views are included in schema.sql and will work automatically once the base tables are populated.
Use manifest.json to verify expected row counts after restore.

ClickHouse (Parquet)

One Parquet file per table. Expand a dump to list its tables. Dumps run weekly, and only the 5 most recent are kept — older ones are removed automatically, so download anything you need to retain.

Legacy MySQL

Archived mysqldump exports, kept for backwards compatibility. No longer updated.

Date	Schema Version	Format	Size	Download