Google BigQuery Connector

Google BigQuery Connector

The high-performance Google BigQuery Connector provides read/write capabilities within your application, allowing you to perform numerous Google BigQuery operations with minimal coding or even no-coding at all. Integrate Google BigQuery data into applications such as SSIS, SQL Server, any ODBC-compatible application, or even directly within a programming language using this connector.

Download for SSIS Download for SQL Server and ODBC Documentation

Integrate Google BigQuery with these applications

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC applications

Actions supported by Google BigQuery Connector

Google BigQuery Connector supports following actions for REST API integration:

[Dynamic Action]

Description

Read data from [$parent.tableReference.datasetId$].[$parent.tableReference.tableId$] for project .

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • -Dynamic-
  • [Dynamic Column]_DT

Visit documentation for more information.

Create Dataset

Description

Creates a new empty dataset.

Parameters

You can provide the following parameters to this action:

  • Dataset Name
  • ProjectId
  • Description

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • datasetId
  • projectId
  • kind
  • id
  • location
  • friendlyName
  • description
  • access

Visit documentation for more information.

Delete Dataset

Description

Deletes the dataset specified by the datasetId value. Before you can delete a dataset, you must delete all its tables, either manually or by specifying deleteContents. Immediately after deletion, you can create another dataset with the same name.

Parameters

You can provide the following parameters to this action:

  • DatasetId
  • ProjectId
  • Delete All Tables

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Response

Visit documentation for more information.

Delete Table

Description

Deletes the dataset specified by the datasetId value. Before you can delete a dataset, you must delete all its tables, either manually or by specifying deleteContents. Immediately after deletion, you can create another dataset with the same name.

Parameters

You can provide the following parameters to this action:

  • TableId
  • ProjectId
  • DatasetId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Response

Visit documentation for more information.

Get Query Schema (From SQL)

Description

Runs a BigQuery SQL query synchronously and returns query schema.

Parameters

You can provide the following parameters to this action:

  • SQL Query
  • Filter
  • Use Legacy SQL Syntax?
  • timeout (Milliseconds)
  • Job Location

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • name
  • type

Visit documentation for more information.

Get Table Schema

Description

Gets the specified table resource by table ID. This method does not return the data in the table, it only returns the table resource, which describes the structure of this table.

Parameters

You can provide the following parameters to this action:

  • DatasetId
  • TableId
  • Filter

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • name
  • type

Visit documentation for more information.

Insert Table Data

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • ProjectId
  • DatasetId
  • TableId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • index
  • reason
  • location
  • debugInfo
  • message

Visit documentation for more information.

List Datasets

Description

Lists all BigQuery datasets in the specified project to which the user has been granted the READER dataset role.

Parameters

You can provide the following parameters to this action:

  • ProjectId
  • SearchFilter
  • all

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • datasetId
  • projectId
  • kind
  • id
  • location

Visit documentation for more information.

List Projects

Description

Lists Projects that the caller has permission on and satisfy the specified filter.

Parameters

You can provide the following parameters to this action:

  • SearchFilter

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • projectId
  • name
  • projectNumber
  • lifecycleState
  • createTime

Visit documentation for more information.

List Tables

Description

Lists BigQuery Tables for the specified project / dataset to which the user has been granted the READER dataset role.

Parameters

You can provide the following parameters to this action:

  • DatasetId
  • ProjectId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • tableId
  • datasetId
  • projectId
  • kind
  • id
  • type
  • creationTime

Visit documentation for more information.

Post Dynamic Endpoint

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • -Dynamic-
  • [Dynamic Column]_DT

Output Fields

The following fields are returned after calling this action:

  • index
  • reason
  • location
  • debugInfo
  • message

Visit documentation for more information.

Read Data using SQL Query -OR- Execute Script (i.e. CREATE, SELECT, INSERT, UPDATE, DELETE)

Description

Runs a BigQuery SQL query synchronously and returns query results if the query completes within a specified timeout.

Parameters

You can provide the following parameters to this action:

  • SQL Statement (i.e. SELECT / DROP / CREATE)
  • Use Legacy SQL Syntax?
  • timeout (Milliseconds)
  • Job Location

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • -Dynamic-
  • [Dynamic Column]_DT

Visit documentation for more information.

Read Table Rows

Description

Gets the specified table resource by table ID. This method does not return the data in the table, it only returns the table resource, which describes the structure of this table.

Parameters

You can provide the following parameters to this action:

  • TableId
  • ProjectId
  • DatasetId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • -Dynamic-
  • [Dynamic Column]_DT

Visit documentation for more information.

Make Generic API Request

Description

This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • Url
  • Body
  • IsMultiPart
  • Filter
  • Headers

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Make Generic API Request (Bulk Write)

Description

This is a generic endpoint for bulk write purpose. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • Url
  • IsMultiPart
  • Filter
  • Headers

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Download for SSIS Download for SQL Server and ODBC