Run Job Page

In the Run Job page, you can specify transformation and profiling jobs for the currently loaded dataset. Available options include output formats and output destinations.

Tip: Columns that have been hidden in the Transformer page still appear in the generated output. Before you run a job, you should verify that all currently hidden columns are ok to include in the output.

Figure: Run Job Page

Options

Profile Results: Optionally, you can disable profiling of your output, which can improve the speed of overall job execution. When the profiling job finishes, details are available through the Job Results page, including links to download results.

NOTE: Percentages for valid, missing, or mismatched column values may not add up to 100% due to rounding.

See Job Results Page.

Publishing Actions

You can add, remove, or edit the outputs generated from this job. By default, a CSV output for your home directory on the selected datastore is included in the list of destinations, which can be removed if needed. You must include at least one output destination.

Columns:

  • Actions: Lists the action and the format for the output.
  • Location: The directory and filename or table information where the output is to be written.
  • Settings: Identifies the output format and any compression, if applicable, for the publication.

Actions:

  • To change format, location, and settings of an output, click the Edit icon.
  • To delete an output, click the X icon.

Add Publishing Action

From the available datastores in the left column, select the target for your publication.

Figure: Add Publishing Action

NOTE: Do not create separate publishing actions that apply to the same file or database table.

Steps:

  1. Select the publishing target. Click an icon in the left column.
    1. BigQuery: You can published your results to the current project or to a different one to which you have access.

      NOTE: You must have read and write access to any BigQuery database to which you are publishing. For more information, see Using BigQuery.

      To publish to a different project, click the BigQuery link at the front of the breadcrumb trail. Then, enter the identifier for the project where you wish to publish your job results.

      Tip: Your projects and their identifiers are available for review through the Cloud Dataprep by TRIFACTA menu bar. See UI Reference.

      Click Go. Navigate to the database where you wish to write your BigQuery results. For more information, see BigQuery Browser.

  2. Locate a publishing destination: Do one of the following.

    1. Explore:

      NOTE: The publishing location must already exist before you can publish to it. The publishing user must have write permissions to the location.

      For Google Cloud Storage, you can create a new folder in an accessible location.
      1. To sort the listings in the current directory, click the carets next to any column name.
      2. For larger directories, browse using the paging controls.
      3. Use the breadcrumb trail to explore the target datastore. Navigate folders as needed.
    2. Search: Use the search bar to search for specific locations in the current folder only.
    3. Manual entry: Click the Edit icon to manually edit or paste in a destination.
  3. Create Folder: Depending on the storage destination, you can click it to create a new folder for the job inside the currently selected one.
  4. Create a new file: Enter the filename under which to save the dataset.

    1. Select the Data Storage Format.
    2. Supported output formats:
      1. CSV
      2. JSON
      3. Avro
    3. You can also write as BigQuery Table, if connected to BigQuery.
  5. BigQuery: When publishing to BigQuery, you must specify the table to which to publish and related actions. See below.
  6. To save the publishing destination, click Save Settings.

File Settings

When you generate file-based results, you can configure the filename, storage format, compression, number of files, and the updating actions in the right-hand panel.

Figure: Output File Settings

Configure the following settings.

  1. Create a new file: Enter the filename to create. A filename extension is automatically added for you, so you should omit the extension from the filename.
  2. Output directory: Read-only value for the current directory.
    1. To change it, navigate to the proper directory.

  3. Data Storage Format: Select the output format you want to generate for the job.
    1. CSV and JSON: These formats are supported for all types of imported datasets and all running environments.

    2. For more information, see Supported File Formats.
  4. Publishing action: Select one of the following:

    1. Create new file every run: For each job run with the selected publishing destination, a new file is created with the same base name with the job number appended to it (e.g. myOutput_2.csv, myOutput_3.csv, and so on).
    2. Append to this file every run: For each job run with the selected publishing destination, the same file is appended, which means that the file grows until it is purged or trimmed.

      NOTE: Compression of published files is not supported for an append action.

    3. Replace this file every run: For each job run with the selected publishing destination, the existing file is overwritten by the contents of the new results.
  5. More Options:

    1. Include headers as first row: For CSV outputs, you can choose to include the column headers as the first row in the output. For other formats, these headers are included automatically.

      NOTE: Headers cannot be applied to compressed outputs.

    2. Single File: Output is written to a single file.

    3. Multiple Files: Output is written to multiple files.
  6. To save the publishing action, click Save Settings.

BigQuery Table Settings

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:
      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 Save Settings.

Run Job

To execute the job as configured, click Run Job. The job is queued for execution.

After a job has been queued, you can track its progress toward completion. See Dataset Details Page.

Was this page helpful? Let us know how we did:

Send feedback about...

Google Cloud Dataprep Documentation