Skip to main content
Google BigQuery logo

Google BigQuery

Overview​

Connect Superblocks to BigQuery to build apps with read and write access to BigQuery:

  • Read data from a BigQuery and utilize it in API steps or UI components

Read data from BigQuery in an application

  • Save information retrieved by other API steps or UI components by writing data to BigQuery

Use SQL to write to BigQuery in an API step

Setting up Google BigQuery​

Before getting started in Superblocks, set up a GCP Service Account with the following IAM roles:

  • Data Viewer
  • Metadata Viewer
  • Job User

Then generate a service account key.

1. Add integration​

Select BigQuery from the integrations page.

2. Configure settings​

Fill out the form with the following settings:

SettingRequiredDescription
NameTRUEName that will be displayed to users when selecting this integration in Superblocks
Service Account KeyTRUEPaste your Google Service Account Key JSON object in this field

3. Test and save​

Click Test Connection to check that Superblocks can connect to the data source.

info

If using Superblocks Cloud, add these Superblocks IPs to your allowlist (not necessary for On-Premise-Agent).

After connecting successfully, click Create to save the integration.

4. Set profiles​

Optionally, configure different profiles for separate development environments.

tip

Google BigQuery connected Now you can use Google BigQuery in any Application, Workflow, or Scheduled Job.

Creating Google BigQuery steps​

Connect to your BigQuery integration from Superblocks by creating steps in Application APIs, Workflows and Scheduled Jobs. You can configure a Superblocks BigQuery integration with read only, read/write, or write only users. You can then configure a Superblocks BigQuery step to read from a database, as well as modify/delete data. To get started, enter your SQL query into the text area of the BigQuery step. Then click "Run" to see the Result and Executed SQL statement below.

See the results and executed SQL of a BigQuery step

Use cases​

Applications

Visualize data from BigQuery in UI components like charts, tables, and grids.

Visualize BigQuery data in applications using a grid component

Workflows

Enrich customer order data within BigQuery with shipping data from snowflake or other datastores.

Use a workflow to enrich BigQuery data with data from other datastores like GraphQL

Scheduled Jobs

Copy data from BigQuery to a Google Sheet on a daily basis for teams who need to see info on new bookings, but don't have access to the database.

Use a scheduled job to query BigQuery and send out a daily report

Troubleshooting​

Date column is not formatting correctly

caution

If using a Date type column in your BigQuery query, the data will appear in the form:

{"your_column":

  {"value": "TIMESTAMP"}

}