Page tree

Trifacta Dataprep


Contents:

On April 28, 2021, Google is changing the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.

   

When publishing to BigQuery, please complete the following steps to configure the table and settings to apply to the publish action.Steps:

  1. Select location: Navigate the BigQuery browser to select the database and table to which to publish.
    1. To create a new table, click Create a new table.
  2. Select table options:
    1. Table name:

      NOTE: BigQuery does not support destinations with a dot (.) in the name.

      1. New table: Enter a name for it. You may use a pre-existing table name, and schema checks are performed against it.
      2. Existing table: You cannot modify the name.
    2. Output database: To change the database to which you are publishing, click the BigQuery icon in the sidebar. Select a different database.
    3. Publish actions: Select one of the following.
      1. Create new table every run: Each run generates a new table with a timestamp appended to the name.
      2. Append to this table every run: Each run adds any new results to the end of the table.
      3. Truncate the table every run: With each run, all data in the table is truncated and replaced with any new results.
      4. Drop the table every run: With each run, the table is dropped (deleted), and all data is deleted. A new table with the same name is created, and any new results are added to it.
  3. To save the publishing action, click Add.

This page has no comments.