Google Cloud BigQuery destination plugin
Google BigQuery is a fully managed, cloud-native data warehouse that allows businesses to store, analyze, and query large datasets in a scalable and cost-effective manner. It is part of the Google Cloud suite of services.
BigQuery provides a serverless architecture, meaning that users do not need to worry about infrastructure provisioning, management, or tuning. It can process terabytes of data in seconds and petabytes of data in minutes, making it suitable for organizations that need to quickly process and analyze large amounts of data.
The Google CloudBigQuery destination plugin in Calyptia Core lets you configure your pipeline to send your log data and metrics to Google Cloud BigQuery.
Configuration parameters
The Google Cloud BigQuery destination plugin provides these configuration parameters.
General
| Key | Description |
|---|---|
| Google Service Credentials Path | The Service Credentials file lets Calyptia Core communicate directly with Google Cloud Services. Read the following on how to set up service credentials: https://cloud.google.com/logging/docs/agent/logging/authorization#create-service-account (opens in a new tab). |
| Google Project Id | The project id containing the BigQuery dataset to stream into. If the service file is provided then the project id is taken from there. |
| Existing Data Set ID | The dataset id of the BigQuery dataset to write into. This dataset must exist in your project. |
| Existing Table ID | The table id of the BigQuery table to write into. This table must exist in the specified dataset and the schema must match the output. |
Advanced
| Key | Description |
|---|---|
| Skip Invalid Rows | If on then insert all valid rows of a request, even if invalid rows exist. The default value is false, which causes the entire request to fail if any invalid rows exist. |
| Ignore Unknown Values | Accept rows that contain values that do not match the schema. The unknown values are ignored. Default is false, which treats unknown values as errors. |
| Enable Workload Identity Federation | Enables workload identity federation as an alternative authentication method. Cannot be used with service account credentials file or environment variable. AWS is the only identity provider currently supported. |
| Google Cloud Region for BigQuery | Google Cloud region for BigQuery. |
| Google Cloud Project Number | Google Cloud project number where the identity provider was created. Used to construct the full resource name of the identity provider. |
| Google Cloud Pool Id | Google Cloud workload identity pool where the identity provider was created. Used to construct the full resource name of the identity provider. |
| Google Cloud Provider Id | Google Cloud workload identity provider. Used to construct the full resource name of the identity provider. Currently only AWS accounts are supported. |
Security and TLS
| Key | Description |
|---|---|
| TLS | Enable or disable TLS/SSL support. |
| TLS Certificate Validation | Turn TLS/SSL certificate validation on or off. TLS must be on for this setting to be enabled. |
| TLS Debug Level | Set TLS debug verbosity level. Accepts these values: 0 (No debug), 1 (Error), 2 (State change), 3 (Informational), 4 (Verbose). |
| CA Certificate File Path | Absolute path to CA certificate file. |
| Certificate File Path | Absolute path to certificate file. |
| Private key File Path | Absolute path to private key file. |
| Private Key Path Password | Optional password for tls.key_file file. |
| TLS SNI Hostname Extension | Hostname to be used for TLS SNI extension. |
Advanced networking
| Key | Description |
|---|---|
| DNS Mode | Select the primary DNS connection type (TCP or UDP). |
| DNS Resolver | Select the primary DNS connection type (TCP or UDP). |
| Prefer IPv4 | Prioritize IPv4 DNS results when trying to establish a connection. |
| Keepalive | Enable or disable Keepalive support. |
| Keepalive Idle Timeout | Set maximum time allowed for an idle Keepalive connection. |
| Max Connect Timeout | Set maximum time allowed to establish a connection, this time includes the TLS handshake. |
| Max Connect Timeout Log Error | On connection timeout, specify if it should log an error. When disabled, the timeout is logged as a debug message. |
| Max Keepalive Recycle | Set maximum number of times a keepalive connection can be used before it is retired. |
| Source Address | Specify network address to bind for data traffic. |