Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Google BigQuery Connector
NodeNode / Source

Google BigQuery Connector

DB Connection
Drag & drop
Like
Copy short link

This node creates a connection to a Google BigQuery server via its JDBC driver. Due to license restrictions the BigQuery JDBC driver is not part of the KNIME Analytics Platform and needs to be downloaded and registered separately. For more details on where to download and how to register the BigQuery driver see the database documentation .
You need to provide the server's hostname (or IP address), the port, and a database name (project ID). Login credentials are provided via the Google Service Connection input port.

This node uses the selected driver's JDBC URL template to create the concrete database URL. Field validation in the dialog depends on whether the (included) tokens referencing them are mandatory or optional in the template.

Node details

Input ports
  1. Type: Google API
    Google Service Connection
    A connection that can be used to access various Google services.
Output ports
  1. Type: DB Session
    DB Connection
    Google BigQuery DB Connection.

Extension

The Google BigQuery Connector node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Working with Google cloud services
    Google Bigquery Cloud storage
    +2
    This workflow demonstrates how to connect to various Google Cloud Services such as Google…
    knime > Examples > 10_Big_Data > 01_Big_Data_Connectors > 04_GoogleCloudExample
  2. Go to item
    Google BigQuery and Amazon Athena - Will They Blend?
    BigQuery Athena GWAS
    In this workflow, we combine data from Genome Wide Association studies in Google BigQuery…
    knime > Examples > 01_Data_Access > 02_Databases > 12_Google_BigQuery_and_Amazon_Athena_will_they_blend
  3. Go to item
    Google BigQuery and Amazon Athena - Will They Blend?
    BigQuery Athena GWAS
    In this workflow, we combine data from Genome Wide Association studies in Google BigQuery…
    marcelw > Public > Example_workflows_cleaned_up > 01_Data_Access > 02_Databases > 12_Google_BigQuery_and_Amazon_Athena_will_they_blend
  4. Go to item
    Austin Bike-sharing with Google BigQuery
    Google BigQuery DB query Cloud
    This workflow performs a connection to the Austin Bikeshare dataset, hosted among the Goo…
    knime > Examples > 10_Big_Data > 01_Big_Data_Connectors > 05_Austin bike sharing with Google BigQuery
  5. Go to item
    Google BigQuery meets Databricks
    Google BigQuery DB query Cloud
    +7
    This workflow connects to the Austin Bikeshare dataset, hosted among the Google BigQuery …
    knime > Examples > 10_Big_Data > 01_Big_Data_Connectors > 07_Will_They_Blend_BigQuery_Databricks
  6. Go to item
    Google Big Query meets SQLite. The business of baseball games.
    Databases Google Big Query Big Query
    +7
    This workflow graphically explores attendance at baseball games together with weather con…
    knime > Examples > 01_Data_Access > 02_Databases > 10_GoogleBigQuery_meets_SQLite
  7. Go to item
    Explore Scientific Data Stored on BigQuery using KNIME
    BigQuery SciWalker Clinical trial
    +2
    This example shows how KNIME Analytics Platform can be used to explore and analyze data s…
    knime > Examples > 08_Other_Analytics_Types > 02_Chemistry_and_Life_Sciences > 06_BigQuery_SciWalker_Exploration
  8. Go to item
    Gene Expression Analysis
    Life Sciences Bioinformatics R
    +2
    In this workflow, we analyze RNA-Seq data from tumors and matched normal tissue from thre…
    knime > Examples > 08_Other_Analytics_Types > 02_Chemistry_and_Life_Sciences > 07_Gene_Expression_Analysis

No known nodes available

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