# Dowloading 'large' dataset failed

**URL:** <https://community.opentargets.org/t/dowloading-large-dataset-failed/318>\
**Category:** Community Feedback\
**Created:** [19 August 2021 15:23 UTC](https://community.opentargets.org/t/dowloading-large-dataset-failed/318 "2021-08-19T15:23:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nicolas](https://avatars.discourse-cdn.com/v4/letter/n/67e7ee/32.png) [@Nicolas](https://community.opentargets.org/u/Nicolas)\
**Post date:** [19 August 2021 15:23 UTC](https://community.opentargets.org/t/dowloading-large-dataset-failed/318/1 "2021-08-19T15:23:36Z")

</div>

Hello,  
DYK, if searching by diseases (for example) and producing a data table larger than ~6000 entry, it’s not possible to download JSON/CVS or TSV data. Instead, you may look at the spinning disk “preparing data” for quite a while 😉 (FYI: A search of ~5000 target get you a CVS file of about 600ko, not so big in fact)  
Cheers  
Nicolas  
 ![image](https://europe1.discourse-cdn.com/flex017/uploads/opentargets/original/1X/5375ee899179eb93cfffb17cf417c10925ca4e46.png)

---

<div class="post-metadata">

**Author:** ![ahercules](https://avatars.discourse-cdn.com/v4/letter/a/f4b2a3/32.png) [@ahercules](https://community.opentargets.org/u/ahercules)\
**Post date:** [20 August 2021 16:44 UTC](https://community.opentargets.org/t/dowloading-large-dataset-failed/318/2 "2021-08-20T16:44:26Z")

</div>

Hi @Nicolas! 👋

Unfortunately, you have stumbled across a known bug that we are working to resolve — see [ticket #1613 in our issue tracker](https://github.com/opentargets/platform/issues/1613). We hope to include these fixes in our next release.

In the meantime, I would recommend using our BigQuery instance - open-targets-prod - and building queries using relevant datasets (e.g. [associationByOverallDirect](https://console.cloud.google.com/bigquery?p=open-targets-prod&d=platform&t=associationByOverallDirect&page=table), [associationByDatasourceDirect](https://console.cloud.google.com/bigquery?p=open-targets-prod&d=platform&t=associationByDatasourceDirect&page=table), [knownDrugsAggregated](https://console.cloud.google.com/bigquery?p=open-targets-prod&d=platform&t=knownDrugsAggregated&page=table)).

Is there a specific data table that you want to download? If so, respond below and I can build a BigQuery script that you can use to generate a JSON or CSV download.

Cheers,

Andrew 🙂
