In this workflow, we combine data from Genome Wide Association studies in Google BigQuery and Amazon Athena. Using an interactive composite view, we select variants of interest and export those to an Excel file. Note: In order to run this workflow, you need a valid authentication mechanism to connect to Google BigQuery and Amazon Athena services. More information on how to get API key/Credentials can be found at: 1. How to create a P12 file for BigQuery (Athena) https://cloud.google.com/docs/authentication/getting-started#creating_a_service_account 2. AWS default credential provider chain https://docs.aws.amazon.com/sdk-for-java/v1/developer-guide/credentials.html
This is a companion discussion topic for the original entry at https://kni.me/w/pVnZ7gFMr-JPVVGa