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.
If the optional Google Service Connection port is used, the node authenticates via a pre-generated access token (OAuthType=2). By default, this method works only with a Google Service Account. To use interactive OAuth, you must setup your own OAuth consent screen and OAuth client ID.
In addition the node supports Application Default Credentials (OAuthType=3) as well as Google Service Account (OAuthType=0) based authentication. These methods can be configured using appropriate JDBC connection parameters. For detailed setup instructions, refer to the Install and configuration guide of the BigQuery JDBC driver.
Note: The node does not allow to pass in any pre-generated access tokens directly via configuration (OAuthType=2), as this is handled exclusively through the credential port. Google user account authentication (OAuthType=1) is not supported for security reasons.
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.