Reference
No results for 'undefined'
    Powered by Algolia

    Read Big Query

    Summary

    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.

    Properties

    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:

    {
    "type": "service_account",
    "project_id": "project-id",
    "private_key_id": "key-id",
    "private_key": "-----BEGIN PRIVATE KEY-----\nYOUR_PRIVATE_KEY_HERE\n-----END PRIVATE KEY-----\n",
    "client_email": "service-account-email",
    "client_id": "client-id",
    "auth_uri": "https://accounts.google.com/o/oauth2/auth",
    "token_uri": "https://accounts.google.com/o/oauth2/token",
    "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
    "client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/service-account-email"
    }

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

    Property
    Description
    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

    Sorry, your browser is not supported. MINTDATA™ works best on Google Chrome 50.0+ and Firefox 44.0+.
    Contents