Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Trifacta Dataprep



Contents:

   

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.

  • No labels

This page has no comments.