Skip to main content

Google BigQuery Output Tool Icon Google BigQuery Output Tool

Use the Google BigQuery Output tool to write data from Designer to the tables in Google BigQuery. See Google BigQuery for information about known limitations.

Alteryx Analytics Gallery

Important

The Google BigQuery Output tool is deprecated. You can still use the Input Data tool  to connect to Google BigQuery.

Configure the Tool

Log in to Google BigQuery - Authentication Mode

You can log in to Google BigQuery with Service-to-Service or End user credentials.

Use Service-to-Service authentication over End user authentication whenever possible. Managing distinct keys for various applications authenticating for the same service account allows the revocation of access for a specific application without requiring the other applications to update their authentication credentials.

Note

Contact your Google Cloud Administrator for help with your Google BigQuery credentials.

Service-to-Service Authentication

Note

Service-to-Service authentication requires a Google Service Account File, also known as a service account JSON key file.

You can obtain a service account JSON key file from the Google Cloud Console, or you can create a new key for an existing service account. More information about Google BigQuery can be found on the Google Big Query Documentation site in Creating and Managing Service Account Keys.

  1. Under the Authentication drop-down, select Service-to-Service.

  2. Click the Select a file button to select your Google service account file.

  3. In the Open File pop-up window, select the JSON file that contains your Google service account key. Selecting the file enters your Google Cloud Service account key ID and Service account email.

  4. Click the Select table button to display the BigQuery Table Output Configuration window, followed by selecting a BigQuery table. Select your project's drop-down menu.

    Note

    If your key file is invalid, an error will display with the tool on your canvas, preventing you from running your workflow.

  5. Select your table under the project's drop-down menu. In Select table output mode, options include...

    1. Append Existing - Append to an existing table.

    2. Overwrite Table (Drop) - Drop the existing table, and create a new table with the same nameAppend to another existing table. When selecting a table, your existing table will be dropped then overwritten.

  6. In Insert batch size, select the size of your data that you want to batch. This number specifies the number of rows that will be written to the Google BigQuery table at each call to insert API.

    Note

    Google sets limits on the number of API requests per second, the number of rows that may be inserted per second and per request, the size of the rows to be inserted, and the size of HTTP requests.

End User Authentication

  1. In Authentication mode, select End user.

  2. Enter your Client ID and Client Secret.

  3. Select Log in.

  4. In Sign in with Google, enter your Google email and password then click Allow to approve the connector's permission to access Google BigQuery on your behalf.

    1. Enter your email address again for your Alteryx sign in, followed by selecting Next.

    2. Enter your password and select Sign in.

    3. Select the Advanced option, then select the Alteryx link.

  5. Select Next.

Starting in Google BigQuery Output version 3.0.0, the Batch load API is used to push JSON files into BigQuery from Alteryx, see the Google BigQuery documentation for more information.

Note that loading time may vary depending on BigQuery’s usage at the time. A workflow writing output to BigQuery will finish once the data is indexed in the table, not once the JSON files are pushed to BigQuery. See the Google BigQuery documentation for any errors received.

In this section: