Skip to main content Skip to complementary content

Building access to BigQuery

Procedure

  1. In the Dataset field of the Component view, enter the dataset you need to transfer data in. In this scenario, it is documentation.
    This dataset must exist in BigQuery. The following figure shows the dataset used by this scenario.
  2. In the Table field, enter the name of the table you need to write data in, for example, UScustomer.
  3. In the Action on data field, select the action. In this example, select Truncate to empty the contents, if there are any, of target table and to repopulate it with the transferred data.
  4. In the Authentication area, add the authentication information to access your Google Cloud account. For more information on the available authentication modes, see tBigQueryOutput Standard properties.
  5. If you have been using the OAuth 2.0 authentication mode, in the Action on data field, select the action to be performed on your data. In this example, select Truncate to empty the contents, if there are any, of target table and to repopulate it with the transferred data. If your are using Service account, ignore this step.
    If the table to be used does not exist in BigQuery, select Create the table if it doesn't exist.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!