August 16, 2023

Building access to BigQuery – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Building access to BigQuery – Docs for ESB 6.x

Building access to BigQuery

  1. Double-click tBigQueryOutput to open its
    Component view.

    use_case-tbigqueryoutput3.png

  2. Click Sync columns to retrieve the schema
    from its preceding component.
  3. In the Local filename field, enter the
    directory where you need to create the file to be transferred to
    BigQuery.
  4. Navigate to the Google APIs Console in your web browser to access the
    Google project hosting the BigQuery and the Cloud Storage services you need
    to use.
  5. Click the API Access tab to open its view.
  6. In the Component view of the Studio,
    paste Client ID, Client secret and Project ID from the API Access tab view
    to the corresponding fields, respectively.
  7. In the Dataset field, 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.
    use_case-tbigqueryoutput4.png

  8. In the Table field, enter the name of the
    table you need to write data in, for example, UScustomer.

    If this table does not exist in BigQuery you are using, select Create the table if it doesn’t exist.
  9. 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.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x