--- title: Google Bigquery slug: connectors/google-bigquery docTags: createdAt: 2026-06-09T16:29:58.412Z --- Google BigQuery is a serverless, highly scalable, and cost-effective multi-cloud data warehouse designed for business agility. Google BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. The Google BigQuery connector for Swimlane Turbine allows users to execute SQL queries and manage data analytics seamlessly within the platform. By integrating with Google BigQuery, Swimlane Turbine end-users can automate data retrieval and analysis processes, enhancing their ability to make data-driven decisions quickly and efficiently. This integration empowers security teams to leverage BigQuery's powerful data processing capabilities directly within their automated workflows, reducing manual effort and improving response times. ## Prerequisites Before you can use the Google BigQuery connector for Turbine, you'll need access to the Google BigQuery API. This requires the following: - Google OAuth2 authentication using the following parameters: - URL: The endpoint for accessing Google APIs. - Credentials: Your Google account credentials for authentication. - Scopes: Permissions required for accessing specific Google services. - API Key: A key to authenticate requests to the Google API. ## Limitations None to date. ## Capabilities This Connector provides the following capabilities: - Jobs Query ### Jobs Query Runs a BigQuery SQL query synchronously and returns query results if the query completes within a specified timeout. Google BigQuery documentation for this action can be found [here](https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs/query) ## Additional Documentation - [Google Bigquery Connector Documentation](https://docs.swimlane.com/connectors/google-bigquery) - [Google Bigquery API Documentation](https://cloud.google.com/bigquery/docs/reference/rest) # Configurations ## Google Authentication Authenticates using Google credentials ### Configuration Parameters | **Parameter** | **Description** | **Type** | **Required** | | ------------- | ----------------------------------------------------------------------------------------------------- | -------- | ------------ | | url | A URL to the target host. | string | Required | | credentials | Base64-encoded contents from Service Account JSON credentials file. See README for setup instructions | string | Required | | scope | List of permission scopes for this action. | array | Required | | apiKey | An optional API key to include as a query parameter. | string | Required | | verify\_ssl | Verify SSL certificate | boolean | Optional | | http\_proxy | A proxy to route requests through. | string | Optional | # Actions ## Jobs Query Execute a synchronous SQL query on Google BigQuery and return results within the specified timeout. Requires 'projectId' and 'query'. ### Endpoint - **URL:** `{{projectId}}/queries` - **Method:** `POST` ### Input | **Argument Name** | **Type** | **Required** | **Description** | | ----------------------------------------------- | -------- | ------------ | -------------------------------------------------------------------------------------------------------------------- | | `parameters.$.xgafv` | number | Optional | V1 error format. | | `parameters.access_token` | string | Optional | access token | | `parameters.alt` | string | Optional | Data format for response. | | `parameters.callback` | string | Optional | callback response | | `parameters.fields` | string | Optional | Selector specifying which fields to include in a partial response. | | `parameters.prettyPrint` | boolean | Optional | Returns response with indentations and line breaks. | | `parameters.quotaUser` | string | Optional | Available to use for quota purposes for server-side applications. | | `parameters.uploadType` | string | Optional | type of the upload. | | `parameters.upload_protocol` | string | Optional | upload protocol for media. | | `path_parameters.projectId` | string | Required | Project ID of the query request. | | `kind` | string | Optional | The resource type of the request. | | `query` | string | Optional | A query string to execute, using Google Standard SQL or legacy SQL syntax. | | `maxResults` | number | Optional | The maximum number of rows of data to return per page of results. | | `defaultDataset` | object | Optional | Specifies the default datasetId and projectId to assume for any unqualified table names in the query. | | `defaultDataset.datasetId` | string | Required | A unique ID for this dataset, without the project name. | | `defaultDataset.projectId` | string | Required | The ID of the project containing this dataset. | | `timeoutMs` | number | Optional | Specifies the maximum amount of time, in milliseconds, that the client is willing to wait for the query to complete. | | `destinationEncryptionConfiguration` | object | Optional | Custom encryption configuration. | | `destinationEncryptionConfiguration.kmsKeyName` | string | Optional | Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. | | `dryRun` | boolean | Optional | If set to true, BigQuery doesn't run the job. | | `preserveNulls` | boolean | Optional | This property is deprecated. | | `useQueryCache` | boolean | Optional | Whether to look for the result in the query cache. | | `useLegacySql` | boolean | Optional | Specifies whether to use BigQuery's legacy SQL dialect for this query. | | `parameterMode` | string | Optional | Specifies whether the query uses positional or named parameters. | | `queryParameters` | array | Optional | jobs.query parameters for GoogleSQL queries. | ### Input Example `{"parameters":{"$.xgafv":1,"access_token":"string","alt":"json","callback":"string","fields":"string","prettyPrint":true,"quotaUser":"string","uploadType":"media","upload_protocol":"raw"},"json_body":{"kind":"bigquery#queryRequest","query":"SELECT COUNT(f1) FROM myProjectId.myDatasetId.myTableId","maxResults":0,"defaultDataset":{"datasetId":"d12","projectId":"p12"},"timeoutMs":0,"destinationEncryptionConfiguration":{"kmsKeyName":"KMS"},"dryRun":false,"preserveNulls":false,"useQueryCache":false,"useLegacySql":false,"queryParameters":[{"name":"test","parameterType":{"type":"test","timestampPrecision":6},"parameterValue":{"value":"mynewval","rangeValue":{"start":{"value":"0"},"end":{"value":"100"}}}}],"location":"US","formatOptions":{"timestampOutputFormat":"FLOAT64","useInt64Timestamp":false},"connectionProperties":[{"key":"test_key","value":"myval"}],"labels":{"test":"v1"},"maximumBytesBilled":0,"requestId":"abc123","createSession":false,"jobCreationMode":"JOB_CREATION_MODE_UNSPECIFIED","jobTimeoutMs":0,"reservation":"projects/1/locations/eu/reservations/2"},"path_parameters":{"projectId":"abc123"}}` ### Output | **Parameter** | **Type** | **Description** | | -------------------------------------- | -------- | ---------------------------------------- | | `status_code` | number | HTTP status code of the response | | `reason` | string | Response reason phrase | | `kind` | string | Output field: kind | | `schema` | object | Output field: schema | | `schema.fields` | array | Output field: schema.fields | | `schema.fields.name` | string | Name of the resource | | `schema.fields.type` | string | Type of the resource | | `schema.fields.mode` | string | Output field: schema.fields.mode | | `schema.fields.fields` | array | Output field: schema.fields.fields | | `schema.fields.fields.name` | string | Name of the resource | | `schema.fields.fields.type` | string | Type of the resource | | `schema.fields.fields.mode` | string | Output field: schema.fields.fields.mode | | `schema.fields.description` | string | Output field: schema.fields.description | | `schema.fields.policyTags` | object | Output field: schema.fields.policyTags | | `schema.fields.policyTags.names` | array | Name of the resource | | `schema.fields.dataPolicies` | array | Response data | | `schema.fields.dataPolicies.name` | string | Response data | | `schema.fields.maxLength` | string | Output field: schema.fields.maxLength | | `schema.fields.precision` | string | Output field: schema.fields.precision | | `schema.fields.scale` | string | Output field: schema.fields.scale | | `schema.fields.roundingMode` | string | Output field: schema.fields.roundingMode | | `schema.fields.collation` | string | Output field: schema.fields.collation | | `schema.fields.defaultValueExpression` | string | Value for the parameter | | `schema.fields.rangeElementType` | object | Type of the resource | | `schema.fields.rangeElementType.type` | string | Type of the resource | ### Output Example `{"status_code":200,"reason":"OK","json_body":{"kind":"bigquery#queryResponse","schema":{"fields":[]},"jobReference":{"projectId":"x123","jobId":"abc123","location":"US"},"jobCreationReason":{"code":"REQUESTED"},"queryId":"xyz123","location":"US","totalRows":"100","pageToken":"abc123","rows":[{}],"totalBytesProcessed":"0","jobComplete":true,"errors":[{}],"cacheHit":false,"numDmlAffectedRows":"10","sessionInfo":{"sessionId":"session_123"}}}` # Response Headers | **Header** | **Description** | **Example** | | ------------ | ----------------------------------------------------- | ----------------------------- | | Content-Type | The media type of the resource | application/json | | Date | The date and time at which the message was originated | Thu, 01 Jan 2024 00:00:00 GMT |