Hi,
Thanks for the questions and apologies for the inconveniences. We have made a lot of exciting changes to the platform for 2503, some of which are breaking. Two important changes with regards to bigQuery are a) that we have included some new tables and b) that we have unified the table names with the folder names of the data downloads on our FTP/GCS. Although this causes some disruption initially, it should make navigating the data more logical. Below I have pasted the mappings so that you can lookup the pre-2503 bq table and replace it with the 2503 table name in any scripts.
The public bigquery-public-data.open_targets_platform instance still points to a pre-2503 version of our bigQuery, but it will be updated in a matter of weeks as well.
I hope this helps. Please get in touch if you have any questions.
bq_2503_table,bq_pre_2503_table
association_by_datasource_direct,associationByDatasourceDirect
association_by_datasource_indirect,associationByDatasourceIndirect
association_by_datatype_direct,associationByDatatypeDirect
association_by_datatype_indirect,associationByDatatypeIndirect
association_by_overall_indirect,associationByOverallIndirect
association_overall_direct,associationByOverallDirect
biosample,NA
colocalisation_coloc,NA
colocalisation_ecaviar,NA
credible_set,NA
disease,diseases
disease_hpo,hpo
disease_phenotype,diseaseToPhenotype
drug_indication,indication
drug_mechanism_of_action,mechanismOfAction
drug_molecule,molecule
drug_warning,drugWarnings
evidence,evidence
expression,baselineExpression
go,go
interaction,interaction
interaction_evidence,interactionEvidence
known_drug,knownDrugsAggregated
l2g_prediction,NA
literature,NA
literature_vector,NA
mouse_phenotype,mousePhenotypes
openfda_significant_adverse_drug_reactions,significantAdverseDrugReactions
openfda_significant_adverse_target_reactions,NA
pharmacogenomics,pharmacogenomics
reactome,reactome
so,NA
study,NA
target,targets
target_essentiality,targetEssentiality
target_prioritisation,targetPrioritisation
variant,NA