Google BigQuery Connector 1.1 Reference | MuleSoft Documentation
# Google BigQuery Connector 1.1 Reference
## Configurations
### Configuration
#### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
Name for this configuration. Connectors reference the configuration with this name.  
**Connection** | 
  * JWT Connection
  * Oauth2 Connection

|  Connection types for this configuration.  
**Response Timeout** |  How long Mule waits for a response to complete before the request times out.  
**Response Timeout Unit** |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

|  Time unit for the **Response Timeout** field.  
**Streaming Type** |  Enumeration, one of:
  * ALWAYS
  * NEVER

|  How the connector streams request content to the remote service:
  * `AUTO` (default) Connector automatically uses the best streaming strategy based on the request content.
  * `ALWAYS` Connector always streams the request content.
  * `NEVER` Connector does not stream the request content.

  
ID used to reference this configuration.  
**Expiration Policy** |  Expiration Policy |  Configures the minimum amount of time that a dynamic configuration instance can remain idle before Mule considers it eligible for expiration.  
#### Connection Types
##### JWT Connection
###### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
**Project Id** |  Project ID.  
Parameter base URI. Each instance or tenant gets its own base URI. |  https://bigquery.googleapis.com/bigquery/v2  
**Default Headers** |  Default headers to include in the request.  
**Query Parameters** |  Query parameters to include in the request.  
**Connection Timeout** |  How long the connector waits before timing out when establishing a connection to the remote service.  
**Connection Timeout Unit** |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

|  Time unit for the **Connection Timeout** field.  
**Use Persistent Connections** |  Indicates whether to use persistent connections:
  * `true` Mule uses persistent connections.
  * `false` Mule closes the connection after the first request completes.

  
**Max Connections** |  Maximum number of connections to open to the backend. HTTP requests are sent in parallel over multiple connections. Setting this value too high can impact latency and consume additional resources without increasing throughput.  
**Connection Idle Timeout** |  When persistent connections are enabled, how long a connection can remain idle before Mule closes it.  
**Connection Idle Timeout Unit** |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

|  Time unit for the **Connection Idle Timeout** field.  
**Proxy Config** |  Configures a proxy for outbound connections.  
**Stream Response** |  If this value is `true`, Mule streams received responses.  
**Response Buffer Size** |  Size of the buffer that stores the HTTP response, in bytes.  
Parameter app name.  
**Private Key Id** |  Private key ID for the Google connected app.  
**Private Key** |  Private key for the Google connected app.  
Client email.  
**Audience Url** |  The audience identifies the authorization server as an intended audience. The authorization server must verify that it is an intended audience for the token. Use the authorization server’s URL for the audience value: `https://bigquery.googleapis.com/`. |  https://bigquery.googleapis.com/  
**Token Timeout** |  Timeout for the token.  
**Token Timeout Unit** |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

|  Time unit for the **Token Timeout** field.  
Enumeration, one of: **HTTP** HTTPS |  Protocol to use for communication.  
**TLS Configuration** |  TLS configuration.  
**Reconnection** |  |  What to do if, when an app is deployed, a connectivity test does not pass after exhausting the associated reconnection strategy:
  * `true` Allow the deployment to fail.
  * `false` Ignore the results of the connectivity test.

  
##### Oauth2 Connection
Use OAuth 2.0 to delegate user authentication to the service hosting the user account. For more information, refer to Configuring OAuth 2.0 for Connectors or Configuring OAuth 2.0 for Connectors on CloudHub.
###### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
**Project Id** |  Project ID.  
Parameter base URI. Each instance or tenant gets its own parameter base URI. |  https://bigquery.googleapis.com/bigquery/v2  
**Default Headers** |  Default headers to include in the request.  
**Query Parameters** |  Query parameters to include in the request.  
**Connection Timeout** |  How long the connector waits before timing out when establishing a connection to the remote service.  
**Connection Timeout Unit** |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

|  Time unit for the **Connection Timeout** field.  
**Use Persistent Connections** |  Indicates whether to use persistent connections:
  * `true` Mule uses persistent connections.
  * `false` Mule closes the connection after the first request completes.

  
**Max Connections** |  Maximum number of connections to open to the backend. HTTP requests are sent in parallel over multiple connections. Setting this value too high can impact latency and consume additional resources without increasing throughput.  
**Connection Idle Timeout** |  When persistent connections are enabled, how long a connection can remain idle before Mule closes it.  
**Connection Idle Timeout Unit** |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

|  Time unit for the **Connection Idle Timeout** field.  
**Proxy Config** |  Configures a proxy for outbound connections.  
**Stream Response** |  If this value is `true`, Mule streams received responses.  
**Response Buffer Size** |  Size of the buffer that stores the HTTP response, in bytes.  
Parameter app name.  
**Access_type** |  Indicates whether to refresh access tokens when the user is not present at the browser.
  * online Retrieves an access token.
  * offline Retrieves a refresh token and an access token.

  
**Refresh Token Condition** |  Refresh condition.  
Enumeration, one of: |  Protocol to use for communication.  
**TLS Configuration** |  Configures TLS. If using the HTTPS protocol, you must configure TLS.  
**Reconnection** |  |  What to do if, when an app is deployed, a connectivity test does not pass after exhausting the associated reconnection strategy:
  * `true` Allow the deployment to fail.
  * `false` Ignore the results of the connectivity test.

  
**Consumer Key** |  OAuth consumer key, as registered with the service provider.  
**Consumer Secret** |  OAuth consumer secret, as registered with the service provider.  
**Authorization Url** |  URL of the service provider’s authorization endpoint. |  https://accounts.google.com/o/oauth2/auth  
**Access Token Url** |  URL of the service provider’s access token endpoint. |  https://oauth2.googleapis.com/token  
OAuth scopes to request during the OAuth dance. This value defaults to the scopes in the annotation. |  https://www.googleapis.com/auth/bigquery  
**Resource Owner Id** |  Resource owner ID to use with the authorization code grant type.  
Name of the flow to execute immediately before starting the OAuth dance.  
Name of the flow to execute immediately after receiving an access token.  
**Listener Config** |  Configuration for the HTTP listener that listens for requests on the access token callback endpoint.  
**Callback Path** |  Path of the access token callback endpoint.  
**Authorize Path** |  Path of the local HTTP endpoint that triggers the OAuth dance.  
**External Callback Url** |  URL that the OAuth provider uses to access the callback endpoint if the endpoint is behind a proxy or accessed through an indirect URL.  
**Object Store** |  Configures the object store that stores data for each resource owner. If not configured, Mule uses the default object store.  
## Supported Operations
  *   *   * Get Query Results
  *   *   * 

## Associated Sources
  * 

## Operations
### Cancel Job
`<bigquery:cancel-job>`
Cancels a job. This operation makes an HTTP POST request to the /project/{projectId}/jobs/{jobId}/cancel endpoint.
#### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
**Configuration** |  Name of the configuration to use.  
**Content Type** |  Content type. |  application/json  
**Config Ref** |  ConfigurationProvider |  Name of the configuration to use to execute this component.  
**Streaming Strategy** | 
  * Repeatable In Memory Stream
  * Repeatable File Store Stream
  * non-repeatable-stream
## Associated Sources
  * 

## Operations
### Cancel Job
`<bigquery:cancel-job>`
Cancels a job. This operation makes an HTTP POST request to the /project/{projectId}/jobs/{jobId}/cancel endpoint.
#### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
**Configuration** |  Name of the configuration to use.  
**Content Type** |  Content type. |  application/json  
**Config Ref** |  ConfigurationProvider |  Name of the configuration to use to execute this component.  
**Streaming Strategy** | 
  * Repeatable In Memory Stream
  * Repeatable File Store Stream
  * non-repeatable-stream

|  Configures how Mule processes streams. Repeatable streams are the default behavior.  
**Custom Query Parameters** |  Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.  
**Custom Headers** |  Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.  
**Response Timeout** |  How long Mule waits for a response to complete before the request times out.  
**Response Timeout Unit** |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

|  Time unit for the **Response Timeout** field.  
**Streaming Type** |  Enumeration, one of:
  * ALWAYS
  * NEVER

|  How the connector streams request content to the remote service:
  * `AUTO` (default) Connector automatically uses the best streaming strategy based on the request content.
  * `ALWAYS` Connector always streams the request content.
  * `NEVER` Connector does not stream the request content.

  
**Target Variable** |  Name of the variable that stores the operation’s output.  
**Target Value** |  Expression that evaluates the operation’s output. The outcome of the expression is stored in the **Target Variable** field.  
**Reconnection Strategy** | 
  *   * Reconnect Forever

|  Retry strategy in case of connectivity errors.  
#### Output
Attributes Type |  HTTP Response Attributes  
---|---  
#### For Configurations
  * Configuration


#### Throws
  * BIGQUERY:BAD_REQUEST
  * BIGQUERY:CLIENT_ERROR
  * BIGQUERY:CONNECTIVITY
  * BIGQUERY:INTERNAL_SERVER_ERROR
  * BIGQUERY:NOT_FOUND
  * BIGQUERY:PROJECT_NOT_FOUND
  * BIGQUERY:RETRY_EXHAUSTED
  * BIGQUERY:SERVER_ERROR
  * BIGQUERY:TIMEOUT
  * BIGQUERY:UNAUTHORIZED


### Delete Job
`<bigquery:delete-job>`
Deletes a job. This operation makes an HTTP DELETE request to the /project/{projectId}/job/{jobId} endpoint.
#### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
**Configuration** |  Name of the configuration to use.  
**Config Ref** |  ConfigurationProvider |  Name of the configuration to use to execute this component.  
**Custom Query Parameters** |  Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.  
**Custom Headers** |  Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.  
**Response Timeout** |  How long Mule waits for a response to complete before the request times out.  
**Response Timeout Unit** |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

|  Time unit for the **Response Timeout** field.  
**Streaming Type** |  Enumeration, one of:
  * ALWAYS
  * NEVER

|  How the connector streams request content to the remote service:
  * `AUTO` (default) Connector automatically uses the best streaming strategy based on the request content.
  * `ALWAYS` Connector always streams the request content.
  * `NEVER` Connector does not stream the request content.

  
**Reconnection Strategy** | 
  *   * Reconnect Forever

|  Retry strategy in case of connectivity errors.  
#### For Configurations
  * Configuration


#### Throws
  * BIGQUERY:BAD_REQUEST
  * BIGQUERY:CLIENT_ERROR
  * BIGQUERY:CONNECTIVITY
  * BIGQUERY:INTERNAL_SERVER_ERROR
  * BIGQUERY:NOT_FOUND
  * BIGQUERY:PROJECT_NOT_FOUND
  * BIGQUERY:RETRY_EXHAUSTED
  * BIGQUERY:SERVER_ERROR
  * BIGQUERY:TIMEOUT
  * BIGQUERY:UNAUTHORIZED


### Get Job
`<bigquery:get-job>`
Gets a job. This operation makes an HTTP GET request to the /project/{projectId}/jobs/{jobId} endpoint.
#### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
**Configuration** |  Name of the configuration to use.  
**Config Ref** |  ConfigurationProvider |  Name of the configuration to use to execute this component.  
**Streaming Strategy** | 
  * Repeatable In Memory Stream
  * Repeatable File Store Stream
  * non-repeatable-stream

|  Configures how Mule processes streams. Repeatable streams are the default behavior.  
**Custom Query Parameters** |  Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.  
**Custom Headers** |  Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.  
**Response Timeout** |  How long Mule waits for a response to complete before the request times out.  
**Response Timeout Unit** |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

|  Time unit for the **Response Timeout** field.  
**Streaming Type** |  Enumeration, one of:
  * ALWAYS
  * NEVER

|  How the connector streams request content to the remote service:
  * `AUTO` (default) Connector automatically uses the best streaming strategy based on the request content.
  * `ALWAYS` Connector always streams the request content.
  * `NEVER` Connector does not stream the request content.

  
**Target Variable** |  Name of the variable that stores the operation’s output.  
**Target Value** |  Expression that evaluates the operation’s output. The outcome of the expression is stored in the **Target Variable** field.  
**Reconnection Strategy** | 
  *   * Reconnect Forever

|  Retry strategy in case of connectivity errors.  
#### Output
Attributes Type |  HTTP Response Attributes  
---|---  
#### For Configurations
  * Configuration


#### Throws
  * BIGQUERY:BAD_REQUEST
  * BIGQUERY:CLIENT_ERROR
  * BIGQUERY:CONNECTIVITY
  * BIGQUERY:INTERNAL_SERVER_ERROR
  * BIGQUERY:NOT_FOUND
  * BIGQUERY:PROJECT_NOT_FOUND
  * BIGQUERY:RETRY_EXHAUSTED
  * BIGQUERY:SERVER_ERROR
  * BIGQUERY:TIMEOUT
  * BIGQUERY:UNAUTHORIZED


### Get Query Results
`<bigquery:get-query-results>`
Get results of a query. This operation makes an HTTP GET request to the /projects/{projectId}/queries/{jobId} endpoint.
#### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
**Configuration** |  Name of the configuration to use.  
**Start Index** |  Zero-based index of the starting row.  
**Max Results** |  Maximum number of comments to return per page.  
**Page Token** |  Token for continuing a previous list request on the next page. Set this parameter to the value of `nextPageToken` from the previous response. This field takes precedence over **Start Index** and **Max Results**.  
Geographic location of the job.  
Specifies the maximum amount of time, in milliseconds, to wait for the query to complete.  
**Output Mime Type** |  MIME type of the payload that this operation outputs.  
**Output Encoding** |  Encoding of the payload that this operation outputs.  
**Config Ref** |  ConfigurationProvider |  Name of the configuration to use to execute this component.  
**Streaming Strategy** | 
  * Repeatable In Memory Iterable
  * Repeatable File Store Iterable
  * non-repeatable-iterable

|  Configures how Mule processes streams. Repeatable streams are the default behavior.  
**Custom Query Parameters** |  Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.  
**Custom Headers** |  Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.  
**Response Timeout** |  How long Mule waits for a response to complete before the request times out.  
**Response Timeout Unit** |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS
|  Configures how Mule processes streams. Repeatable streams are the default behavior.  
**Custom Query Parameters** |  Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.  
**Custom Headers** |  Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.  
**Response Timeout** |  How long Mule waits for a response to complete before the request times out.  
**Response Timeout Unit** |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

|  Time unit for the **Response Timeout** field.  
**Streaming Type** |  Enumeration, one of:
  * ALWAYS
  * NEVER

|  How the connector streams request content to the remote service:
  * `AUTO` (default) Connector automatically uses the best streaming strategy based on the request content.
  * `ALWAYS` Connector always streams the request content.
  * `NEVER` Connector does not stream the request content.

  
**Target Variable** |  Name of the variable that stores the operation’s output.  
**Target Value** |  Expression that evaluates the operation’s output. The outcome of the expression is stored in the **Target Variable** field.  
**Reconnection Strategy** | 
  *   * Reconnect Forever

|  Retry strategy in case of connectivity errors.  
#### Output
Array of Any  
---  
Attributes Type | Array of Any  
#### For Configurations
  * Configuration


#### Throws
  * BIGQUERY:BAD_REQUEST
  * BIGQUERY:CLIENT_ERROR
  * BIGQUERY:CONNECTIVITY
  * BIGQUERY:INTERNAL_SERVER_ERROR
  * BIGQUERY:NOT_FOUND
  * BIGQUERY:PROJECT_NOT_FOUND
  * BIGQUERY:SERVER_ERROR
  * BIGQUERY:TIMEOUT
  * BIGQUERY:UNAUTHORIZED


### Insert Job
`<bigquery:insert-job>`
Inserts a job. This operation makes an HTTP POST request to the /project/{projectId}/jobs endpoint.
#### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
**Configuration** |  Name of the configuration to use.  
**Job Values Content** |  Job values content.  
**Config Ref** |  ConfigurationProvider |  Name of the configuration to use to execute this component.  
**Streaming Strategy** | 
  * Repeatable In Memory Stream
  * Repeatable File Store Stream
  * non-repeatable-stream

|  Configures how Mule processes streams. Repeatable streams are the default behavior.  
**Custom Query Parameters** |  Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.  
**Custom Headers** |  Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.  
**Response Timeout** |  How long Mule waits for a response to complete before the request times out.  
**Response Timeout Unit** |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

|  Time unit for the **Response Timeout** field.  
**Streaming Type** |  Enumeration, one of:
  * ALWAYS
  * NEVER

|  How the connector streams request content to the remote service:
  * `AUTO` (default) Connector automatically uses the best streaming strategy based on the request content.
  * `ALWAYS` Connector always streams the request content.
  * `NEVER` Connector does not stream the request content.

  
**Target Variable** |  Name of the variable that stores the operation’s output.  
**Target Value** |  Expression that evaluates the operation’s output. The outcome of the expression is stored in the **Target Variable** field.  
**Reconnection Strategy** | 
  *   * Reconnect Forever

|  Retry strategy in case of connectivity errors.  
#### Output
Attributes Type |  HTTP Response Attributes  
---|---  
#### For Configurations
  * Configuration


#### Throws
  * BIGQUERY:BAD_REQUEST
  * BIGQUERY:CLIENT_ERROR
  * BIGQUERY:CONNECTIVITY
  * BIGQUERY:INTERNAL_SERVER_ERROR
  * BIGQUERY:NOT_FOUND
  * BIGQUERY:PROJECT_NOT_FOUND
  * BIGQUERY:RETRY_EXHAUSTED
  * BIGQUERY:SERVER_ERROR
  * BIGQUERY:TIMEOUT
  * BIGQUERY:UNAUTHORIZED


### List Jobs
`<bigquery:list-jobs>`
Lists jobs. This operation makes an HTTP GET request to the /projects/{projectId}/jobs endpoint.
#### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
**Configuration** |  Name of the configuration to use.  
**Content Type** |  Content type. |  application/json  
**Max Results** |  Maximum number of comments to return per page.  
**Pretty Print** |  Returns the response with indentations and line breaks.  
**Page Token** |  Token for continuing a previous list request on the next page. Set this parameter to the value of `nextPageToken` from the previous response.  
**Quota User** |  Opaque string that represents a user for quota purposes. Must not exceed 40 characters.  
Deprecated. Use **Quota User** instead.  
Selector specifying which fields to include in a partial response.  
**Min Created Time** |  Minimum value of `modifiedTime` for the result comments (RFC 3339 date-time).  
**Max Created Time** |  Maximum value of `modifiedTime` for the result comments (RFC 3339 date-time).  
**Output Mime Type** |  MIME type of the payload that this operation outputs.  
**Output Encoding** |  Encoding of the payload that this operation outputs.  
**Config Ref** |  ConfigurationProvider |  Name of the configuration to use to execute this component.  
**Streaming Strategy** | 
  * Repeatable In Memory Iterable
  * Repeatable File Store Iterable
  * non-repeatable-iterable

|  Configures how Mule processes streams. Repeatable streams are the default behavior.  
**Custom Query Parameters** |  Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.  
**Custom Headers** |  Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.  
**Response Timeout** |  How long Mule waits for a response to complete before the request times out.  
**Response Timeout Unit** |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

|  Time unit for the **Response Timeout** field.  
**Streaming Type** |  Enumeration, one of:
  * ALWAYS
  * NEVER

|  How the connector streams request content to the remote service:
  * `AUTO` (default) Connector automatically uses the best streaming strategy based on the request content.
  * `ALWAYS` Connector always streams the request content.
  * `NEVER` Connector does not stream the request content.

  
**Target Variable** |  Name of the variable that stores the operation’s output.  
**Target Value** |  Expression that evaluates the operation’s output. The outcome of the expression is stored in the **Target Variable** field.  
**Reconnection Strategy** | 
  *   * Reconnect Forever

|  Retry strategy in case of connectivity errors.  
#### Output
Array of Any  
---  
#### For Configurations
  * Configuration


#### Throws
  * BIGQUERY:BAD_REQUEST
  * BIGQUERY:CLIENT_ERROR
  * BIGQUERY:CONNECTIVITY
  * BIGQUERY:INTERNAL_SERVER_ERROR
  * BIGQUERY:NOT_FOUND
  * BIGQUERY:PROJECT_NOT_FOUND
  * BIGQUERY:SERVER_ERROR
  * BIGQUERY:TIMEOUT
  * BIGQUERY:UNAUTHORIZED


### Query
`<bigquery:query>`
Executes a query. This operation makes an HTTP POST query request to the /projects/{projectId}/queries endpoint.
#### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
**Configuration** |  Name of the configuration to use.  
**Query Values Content** |  Query values content.  
**Output Mime Type** |  MIME type of the payload that this operation outputs.  
**Output Encoding** |  Encoding of the payload that this operation outputs.  
**Config Ref** |  ConfigurationProvider |  Name of the configuration to use to execute this component.  
**Streaming Strategy** | 
  * Repeatable In Memory Iterable
  * Repeatable File Store Iterable
  * non-repeatable-iterable
|  Retry strategy in case of connectivity errors.  
#### Output
Array of Any  
---  
#### For Configurations
  * Configuration


#### Throws
  * BIGQUERY:BAD_REQUEST
  * BIGQUERY:CLIENT_ERROR
  * BIGQUERY:CONNECTIVITY
  * BIGQUERY:INTERNAL_SERVER_ERROR
  * BIGQUERY:NOT_FOUND
  * BIGQUERY:PROJECT_NOT_FOUND
  * BIGQUERY:SERVER_ERROR
  * BIGQUERY:TIMEOUT
  * BIGQUERY:UNAUTHORIZED


### Query
`<bigquery:query>`
Executes a query. This operation makes an HTTP POST query request to the /projects/{projectId}/queries endpoint.
#### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
**Configuration** |  Name of the configuration to use.  
**Query Values Content** |  Query values content.  
**Output Mime Type** |  MIME type of the payload that this operation outputs.  
**Output Encoding** |  Encoding of the payload that this operation outputs.  
**Config Ref** |  ConfigurationProvider |  Name of the configuration to use to execute this component.  
**Streaming Strategy** | 
  * Repeatable In Memory Iterable
  * Repeatable File Store Iterable
  * non-repeatable-iterable

|  Configures how Mule processes streams. Repeatable streams are the default behavior.  
**Custom Query Parameters** |  Custom query parameters to include in the request. The specified query parameters are merged with the default query parameters that are specified in the configuration.  
**Custom Headers** |  Custom headers to include in the request. The specified custom headers are merged with the default headers that are specified in the configuration.  
**Response Timeout** |  How long Mule waits for a response to complete before the request times out.  
**Response Timeout Unit** |  Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

|  Time unit for the **Response Timeout** field.  
**Streaming Type** |  Enumeration, one of:
  * ALWAYS
  * NEVER

|  How the connector streams request content to the remote service:
  * `AUTO` (default) Connector automatically uses the best streaming strategy based on the request content.
  * `ALWAYS` Connector always streams the request content.
  * `NEVER` Connector does not stream the request content.

  
**Target Variable** |  Name of the variable that stores the operation’s output.  
**Target Value** |  Expression that evaluates the operation’s output. The outcome of the expression is stored in the **Target Variable** field.  
**Reconnection Strategy** | 
  *   * Reconnect Forever

|  Retry strategy in case of connectivity errors.  
#### Output
Array of Any  
---  
Attributes Type | Array of Any  
#### For Configurations
  * Configuration


#### Throws
  * BIGQUERY:BAD_REQUEST
  * BIGQUERY:CLIENT_ERROR
  * BIGQUERY:CONNECTIVITY
  * BIGQUERY:INTERNAL_SERVER_ERROR
  * BIGQUERY:NOT_FOUND
  * BIGQUERY:PROJECT_NOT_FOUND
  * BIGQUERY:SERVER_ERROR
  * BIGQUERY:TIMEOUT
  * BIGQUERY:UNAUTHORIZED


### Unauthorize
`<bigquery:unauthorize>`
Deletes all the access token information of a given resource owner ID so that it is impossible to execute any operation for that user without doing the authorization dance again.
#### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
**Configuration** |  Name of the configuration to use.  
**Resource Owner Id** |  ID of the resource owner for whom to invalidate access.  
**Config Ref** |  ConfigurationProvider |  Name of the configuration to use to execute this component.  
#### For Configurations
  * Configuration


## Sources
### On Table Row
`<bigquery:on-table-row>`
Returns all rows of a table based on a watermark.
#### Parameters
Name | Type | Description | Default Value | Required  
---|---|---|---|---  
**Configuration** |  Name of the configuration to use.  
**Config Ref** |  ConfigurationProvider |  Name of the configuration to use to execute this component.  
**Primary Node Only** |  Determines whether to execute this source on only the primary node when running Mule instances in a cluster.  
**Scheduling Strategy** |  scheduling-strategy |  Configures the scheduler that triggers the polling.  
**Redelivery Policy** |  Redelivery Policy |  Defines a policy for processing the redelivery of the same message.  
**Dataset Name** |  Name of the table to select from.  
**Table Name** |  Name of the table to select from.  
**Watermark Column** |  Name of the column to use for the watermark. Values taken from this column are used to filter the contents of the next poll, so that rows only with a greater watermark value are processed.  
Value to use as watermarking.  
Name of the column to consider as the row ID. If provided, this parameter ensures that the same row is not processed twice by concurrent polls.  
**Reconnection Strategy** | 
  *   * Reconnect Forever

|  Retry strategy in case of connectivity errors.  
#### Output
Attributes Type |  HTTP Response Attributes  
---|---  
#### For Configurations
  * Configuration


## Types
### Proxy
Configures a proxy for outbound connections.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
Hostname or IP address of the proxy server.  
Port of the proxy server.  
Username to authenticate against the proxy server.  
Password to authenticate against the proxy server.  
**Non Proxy Hosts** |  Comma-separated list of hosts that the proxy must not be used against.  
Configures TLS to provide secure communications for the Mule app.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**Enabled Protocols** |  Comma-separated list of protocols enabled for this context.  
**Enabled Cipher Suites** |  Comma-separated list of cipher suites enabled for this context.  
**Trust Store** |  Configures the TLS truststore.  
Configures the TLS keystore.  
**Revocation Check** | 
  * Standard Revocation Check
  * Custom OCSP Responder

|  Configures a revocation checking mechanism.  
### Truststore
Configures the truststore for TLS.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
Path to the truststore. Mule resolves the path relative to the current classpath and file system.  
Password used to protect the truststore.  
Type of truststore.  
Encryption algorithm that the truststore uses.  
If `true`, Mule stops performing certificate validations. Setting this to `true` can make connections vulnerable to attacks.  
### Keystore
Configures the keystore for the TLS protocol. The keystore you generate contains a private key and a public certificate.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
Path to the keystore. Mule resolves the path relative to the current classpath and file system.  
Type of keystore.  
Alias of the key to use when the keystore contains multiple private keys. By default, Mule uses the first key in the file.  
**Key Password** |  Password used to protect the private key.  
Password used to protect the keystore.  
Encryption algorithm that the keystore uses.  
### Standard Revocation Check
Configures standard revocation checks for TLS certificates.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**Only End Entities** |  Which elements to verify in the certificate chain:
  * `true` Verify only the last element in the certificate chain.
  * `false` Verify all elements in the certificate chain.

  
**Prefer Crls** |  How to check certificate validity:
  * `true` Check the Certification Revocation List (CRL) for certificate validity.
  * `false` Use the Online Certificate Status Protocol (OCSP) to check certificate validity.

  
**No Fallback** |  Whether to use the secondary method to check certificate validity:
  * `true` Use the method that wasn’t specified in the **Prefer Crls** field (the secondary method) to check certificate validity.
  * `false` Do not use the secondary method to check certificate validity.

  
What to do if the revocation server can’t be reached or is busy:
  * `true` Avoid verification failure.
  * `false` Allow the verification to fail.
**Prefer Crls** |  How to check certificate validity:
  * `true` Check the Certification Revocation List (CRL) for certificate validity.
  * `false` Use the Online Certificate Status Protocol (OCSP) to check certificate validity.

  
**No Fallback** |  Whether to use the secondary method to check certificate validity:
  * `true` Use the method that wasn’t specified in the **Prefer Crls** field (the secondary method) to check certificate validity.
  * `false` Do not use the secondary method to check certificate validity.

  
What to do if the revocation server can’t be reached or is busy:
  * `true` Avoid verification failure.
  * `false` Allow the verification to fail.

  
### Custom OCSP Responder
Configures a custom OCSP responder for certification revocation checks.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
URL of the OCSP responder.  
**Cert Alias** |  Alias of the signing certificate for the OCSP response. If specified, the alias must be in the truststore.  
### CRL File
Specifies the location of the certification revocation list (CRL) file.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
Path to the CRL file.  
### Reconnection
Configures a reconnection strategy for an operation.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**Fails Deployment** |  What to do if, when an app is deployed, a connectivity test does not pass after exhausting the associated reconnection strategy:
  * `true` Allow the deployment to fail.
  * `false` Ignore the results of the connectivity test.

  
**Reconnection Strategy** | 
  *   * Reconnect Forever

|  Reconnection strategy to use.  
### Reconnect
Configures a standard reconnection strategy, which specifies how often to reconnect and how many reconnection attempts the connector source or operation can make.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
How often to attempt to reconnect, in milliseconds.  
If `false`, the reconnection strategy runs in a separate, non-blocking thread.  
How many reconnection attempts the Mule app can make.  
### Reconnect Forever
Configures a forever reconnection strategy by which the connector source or operation attempts to reconnect at a specified frequency for as long as the Mule app runs.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
How often to attempt to reconnect, in milliseconds.  
If `false`, the reconnection strategy runs in a separate, non-blocking thread.  
### Expiration Policy
Configures an expiration policy strategy.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**Max Idle Time** |  Configures the maximum amount of time that a dynamic configuration instance can remain idle before Mule considers it eligible for expiration.  
Enumeration, one of:
  * NANOSECONDS
  * MICROSECONDS
  * MILLISECONDS
  * SECONDS
  * MINUTES
  * HOURS

|  Time unit for the **Max Idle Time** field.  
### HTTP Response Attributes
Configures HTTP response attributes for the configuration.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**Status Code** |  HTTP status code of the response.  
Map of HTTP headers in the message.  
**Reason Phrase** |  HTTP reason phrase of the response.  
### Redelivery Policy
Configures the redelivery policy for executing requests that generate errors. You can add a redelivery policy to any source in a flow.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**Max Redelivery Count** |  Maximum number of times that a redelivered request can be processed unsuccessfully before returning a REDELIVERY_EXHAUSTED error.  
**Message Digest Algorithm** |  Secure hashing algorithm to use if the **Use Secure Hash** field is `true`. If the payload of the message is a Java object, Mule ignores this value and returns the value that the payload’s `hashCode()` returned.  
**Message Identifier** |  Redelivery Policy Message Identifier |  One or more expressions that determine if a message was redelivered. This property can be set only if the **Use Secure Hash** field is `false`.  
**Object Store** |  ObjectStore |  Configures the object store that stores the redelivery counter for each message.  
### Redelivery Policy Message Identifier
Configures how to identify a redelivered message and how to find out when the message was redelivered.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**Use Secure Hash** |  If `true`, Mule uses a secure hash algorithm to identify a redelivered message.  
**Id Expression** |  One or more expressions that determine when a message was redelivered. You can set this property only if the **Use Secure Hash** field is `false`.  
### Repeatable In Memory Stream
Configures the in-memory streaming strategy by which the request fails if the data exceeds the MAX buffer size. Always run performance tests to find the optimal buffer size for your specific use case.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**Initial Buffer Size** |  Initial amount of memory to allocate to the data stream. If the streamed data exceeds this value, the buffer expands by **Buffer Size Increment** , with an upper limit of **Max In Memory Size value**.  
**Buffer Size Increment** |  Amount by which the buffer size expands if it exceeds its initial size. Setting a value of `0` or lower specifies that the buffer can’t expand.  
**Max Buffer Size** |  The maximum amount of memory to use. If more than that is used then a STREAM_MAXIMUM_SIZE_EXCEEDED error is raised. A value lower than or equal to zero means no limit.  
**Buffer Unit** |  Enumeration, one of: |  Unit for the **Initial Buffer Size** , **Buffer Size Increment** , and **Buffer Unit** fields.  
### Repeatable File Store Stream
Configures the repeatable file-store streaming strategy by which Mule keeps a portion of the stream content in memory. If the stream content is larger than the configured buffer size, Mule backs up the buffer’s content to disk and then clears the memory.
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**In Memory Size** |  Maximum amount of memory that the stream can use for data. If the amount of memory exceeds this value, Mule buffers the content to disk. To optimize performance:
  * Configure a larger buffer size to avoid the number of times Mule needs to write the buffer on disk. This increases performance, but it also limits the number of concurrent requests your application can process, because it requires additional memory.
  * Configure a smaller buffer size to decrease memory load at the expense of response time.

  
**Buffer Unit** |  Enumeration, one of: |  Unit for the **In Memory Size** field.  
### Repeatable In Memory Iterable
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**Initial Buffer Size** |  Amount of instances to initially keep in memory to consume the stream and provide random access to it. If the stream contains more data than can fit into this buffer, then the buffer expands according to the **Buffer Size Increment** attribute, with an upper limit of **Max In Memory Size**. Default value is 100 instances.  
**Buffer Size Increment** |  This is by how much the buffer size expands if it exceeds its initial size. Setting a value of `0` or lower means that the buffer must not expand, meaning that a `STREAM_MAXIMUM_SIZE_EXCEEDED` error is raised when the buffer gets full. Default value is 100 instances.  
**Max Buffer Size** |  Maximum amount of memory to use. If more than that is used, a `STREAM_MAXIMUM_SIZE_EXCEEDED` error is raised. A value lower than or equal to `0` means no limit.  
### Repeatable File Store Iterable
Field | Type | Description | Default Value | Required  
---|---|---|---|---  
**In Memory Objects** |  Maximum amount of instances to keep in memory. If more than that is required, content on the disk is buffered.  
**Buffer Unit** |  Enumeration, one of: |  Unit for the **In Memory Size** field.  
## See Also
  * Introduction to Anypoint Connectors
  * MuleSoft Help Center