top menu gradient

Read Big Query


Reads data from Google BigQuery, a cloud data warehouse. Provide your project ID and authentication details to connect to BigQuery, and then specify your query to fetch data from your datasets.


The following table lists the Read Big Query block properties and describes the input for each property.

Note: To quickly fill out all the block properties except Query, upload a JSON file generated automatically when you create a key for your service account.

The JSON file contains the following security key information:


For more information about creating a service account key, see here.

Project IDThe ID of your Google Cloud project
Private Key IDThe ID of the private key for the service account
Private KeyThe private key for the service account
Client EmailThe service-account email
Client IDThe client ID
Client Certificate URLThe URL of the client certificate
QueryThe query to send

Sample flow