# Google BigQuery

{% hint style="info" %}
The content of this documentation is under revision and may change. We appreciate your understanding as we work to improve it.
{% endhint %}

**Google BigQuery** queries data warehouse from Google BigQuery for analytics.

## **Parameters**

Take a look at the configuration parameters for the connector. Parameters supported by [Double Braces expressions](https://docs.digibee.com/documentation/connectors-and-triggers/double-braces/overview) are marked with `(DB)`.

### **General tab**

<table data-full-width="true"><thead><tr><th>Parameter</th><th>Description</th><th>Default value</th><th>Data type</th></tr></thead><tbody><tr><td><strong>Dynamic Account</strong></td><td>When active, the connector will use the account dynamically. Otherwise, it will use the account statically.</td><td>False</td><td>Boolean</td></tr><tr><td><strong>Account Name</strong> <code>(DB)</code></td><td>The name of the dynamic account used by the connector. This account must have been previously configured in a <a href="../tools/store-account"><strong>Store Account</strong></a> connector in the pipeline for this process to take effect. It is only available if the <strong>Dynamic Account</strong> parameter is active.</td><td>N/A</td><td>String</td></tr><tr><td><strong>Account</strong></td><td>The account used by the connector. It is only available if the <strong>Dynamic Account</strong> parameter is inactive.</td><td>N/A</td><td>Account</td></tr><tr><td><strong>Project Id</strong> <code>(DB)</code></td><td>Google Cloud Project ID.</td><td>N/A</td><td>String</td></tr><tr><td><strong>Dataset Id</strong> <code>(DB)</code></td><td>BigQuery Dataset ID.</td><td>N/A</td><td>String</td></tr><tr><td><strong>Fail On Error</strong></td><td>If the option is activated, the pipeline's execution with an error will be interrupted. Otherwise, the pipeline execution proceeds, but the result will show a false value for the <code>"success"</code> property.</td><td>False</td><td>Boolean</td></tr></tbody></table>

### **Optional tab**

<table data-full-width="true"><thead><tr><th>Parameter</th><th>Description</th><th>Default value</th><th>Data type</th></tr></thead><tbody><tr><td><strong>Table Id</strong> <code>(DB)</code></td><td>BigQuery table ID.</td><td>N/A</td><td>String</td></tr><tr><td><strong>Use As Insert Id</strong> <code>(DB)</code></td><td>Field name to use as insert ID.</td><td>N/A</td><td>String</td></tr><tr><td><strong>Body</strong> <code>(DB)</code></td><td>The body, if applicable.</td><td><code>{}</code></td><td>JSON</td></tr></tbody></table>

### **Headers tab**

<table data-full-width="true"><thead><tr><th>Parameter</th><th>Description</th><th>Default value</th><th>Data type</th></tr></thead><tbody><tr><td><strong>Table Suffix</strong> <code>(DB)</code></td><td>Table suffix to use when inserting data.</td><td>N/A</td><td>String</td></tr><tr><td><strong>Table Id</strong> <code>(DB)</code></td><td>Table ID where data will be submitted. If specified will override endpoint configuration.</td><td>N/A</td><td>String</td></tr><tr><td><strong>Insert Id</strong> <code>(DB)</code></td><td>Insert ID to use when inserting data.</td><td>N/A</td><td>String</td></tr><tr><td><strong>Partition Decorator</strong> <code>(DB)</code></td><td>Partition decorator to indicate partition to use when inserting data.</td><td>N/A</td><td>String</td></tr></tbody></table>

### **Documentation tab**

<table data-full-width="true"><thead><tr><th>Parameter</th><th>Description</th><th>Default value</th><th>Data type</th></tr></thead><tbody><tr><td><strong>Documentation</strong></td><td>Section for documenting any necessary information about the connector configuration and business rules.</td><td>N/A</td><td>String</td></tr></tbody></table>