BigQuery Table Delete

Use this Snap to delete BigQuery tables.

Overview

You can use this Snap to delete BigQuery tables.



Prerequisites

A valid Google BigQuery Account with the required permissions.

Limitations and Known Issues

None.

Supported Accounts

This Snap works with the following account types. For more information, see Configuring Google BigQuery Accounts.

Snap Views

Type Format Number of Views Examples of Upstream and Downstream Snaps Description
Input Document
  • Min: 0
  • Max: 1
  • Mapper
  • JSON Generator

The Project ID, Dataset ID, and Table ID.
Output Document
  • Min: 1
  • Max: 1
  • Mapper

The status of the table deletion and the details of the deleted table: Project ID, Dataset ID, Table ID, and Table Type.
Learn more about Error handling.

Snap Settings

Note: Learn about the common controls in the Snap settings dialog.
Field/Field set Description
Label

String

Specify a unique name for the Snap.

Default value: BigQuery Table Delete

Example: Delete Contract Employees
Project ID

String/Expression

Specify the project ID in which the dataset to be deleted resides.

Default value: N/A

Example: contract-project-123
Dataset ID

String/Expression

Specify the ID of the dataset that you want to delete.

Default value: N/A

Example: contract_emp_names
Table ID

String/Expression

Specify the ID of the target table that you want to delete.

Default value: N/A

Example: Contract_Emp123
Snap execution

Dropdown list
Choose one of the three modes in which the Snap executes. Available options are:
  • Validate & Execute. Performs limited execution of the Snap and generates a data preview during pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during pipeline runtime.
  • Execute only. Performs full execution of the Snap during pipeline execution without generating preview data.
  • Disabled. Disables the Snap and all Snaps that are downstream from it.

Default value: Execute only

Example: Validate & Execute

Implicit retries in BigQuery Snaps

The BigQuery Snaps handle all retriable BigQuery errors (BigQuery exception, IO exception, and Runtime exception) internally.

  • 429 (Too Many Requests):
    • Retry attempts: Maximum of 5 retries.
    • Delay Between Retries: Backoff strategy with jitter (random variation) is applied to prevent synchronized retries and reduce load.
  • 401 (Unauthorized):
    • Retry attempts: Maximum of 3 retries.
    • Delay Between Retries: Backoff strategy is applied.
    • Additional Actions: Reloads the BigQuery account on the retry event.
  • IOException and 500, 502, 503, 504 (Server Errors):
    • Retry attempts: Maximum of 3 retries.
    • Delay Between Retries: Backoff strategy is applied.