1.0.4 (November 6, 2020)
To see the full changelog please use the following link.
Integration component to interact with Google BigQuery using
@google-cloud/bigquery
client library version 5.2.0
(API).
The component completeness matrix gives the technical details about Salesforce objects this component covers.
Service Account
- Set of credentials (project ID, private key, etc) provided by Google.
More information on how to generate credentials you can find here.
After you perform all authentication steps described above just copy and paste content of an authentication JSON file as-is to the field Service Account credentials.
It should look like this:
{
"type": "service_account",
"project_id": "projectname",
"private_key_id": "ds67f57s6df5sd76f57s6df57sdf67sdf76df",
"private_key": "PRIVATE_KEY",
"client_email": "email",
"client_id": "2348238472834782348723",
"auth_uri": "https://accounts.google.com/o/oauth2/auth",
"token_uri": "https://oauth2.googleapis.com/token",
"auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
"client_x509_cert_url": "cert_url"
}
This component has no trigger functions. This means it will not be accessible to select as a first component during the integration flow design.
Performs a query provided by user.
Input metadata include query options according to documentations.
The query
option is required.
{
"type": "object",
"required": true,
"properties": {
"query": {
"type": "string",
"required": true
}
}
}
{
"type": "object",
"required": true,
"properties": {
"result": {
"required": true,
"type": "array"
}
}
}
The query options are an experimental feature and correct behavior is not guaranteed. Only query
, location
, dryRun
, useQueryCache
, useLegacySql
, parameterMode
,maximumBytesBilled
options were tested.
Get your free 14-day elastic.io trial account to use this component.