Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • knime
  • Spaces
  • Examples
  • 01_Data_Access
  • 02_Databases
  • 12_Google_BigQuery_and_Amazon_Athena_will_they_blend
WorkflowWorkflow

Google BigQuery and Amazon Athena - Will They Blend?

BigQuery Athena GWAS

Last edited: 

Drag & drop
Like
Download workflow
Copy short link
Workflow preview
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

External resources

  • AWS default credential provider chain
  • Creating a P12 file for BigQuery (Athena)
  • KNIME Database Documentation

Used extensions & nodes

Created with KNIME Analytics Platform version 4.1.0
  • Go to item
    KNIME Amazon Athena Connector Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  • Go to item
    KNIME Amazon Cloud Connectors Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  • Go to item
    KNIME BigQuery Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  • Go to item
    KNIME Core Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  • Go to item
    KNIME Database Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  • Go to item
    KNIME Excel Support Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  • Go to item
    KNIME JavaScript Views Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  • Go to item
    KNIME Math Expression (JEP) Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  • Go to item
    KNIME Quick Forms Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  • Go to item
    KNIME Twitter & Google Connectors Unknown extension

    This is an unpublished or unknown extension.

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

Legal

By using or downloading the workflow, you agree to our terms and conditions.

Discussion
Discussions are currently not available, please try again later.

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits