To support more complex queries and advanced informatics workflows that use Google Cloud services, the Open Targets Platform data is also available via our Google BigQuery instance - open-targets-prod.
What is Google BigQuery?
Google BigQuery is a data warehouse that enables researchers to run super-fast, asynchronous SQL queries using Google's cloud infrastructure. After running your query, you can either export into various formats or copy into a Google Cloud bucket for further downstream analyses.
BigQuery access points
Open Targets has uploaded all of our data to Google BigQuery. You can run queries via:
Below is a sample query that uses our associationByOverallDirect dataset to return a list of targets associated with psoriasis (EFO_0000676) and the overall association score.
For more information on how to use BigQuery to access Platform data and example queries based on actual use cases and research questions, check out the Open Targets Community.