/
Google BigTable Batch Write

Google BigTable Batch Write

In this article

Overview

This Snap inserts new records into BigTable table in batches.

image-20250324-072652.png

Snap Type

The Write-type Snap writes data to the SnapLogic or external target database.

Prerequisites

None.

Limitations and Known Issues

None.

Snap Views

 

Type

Format

Number of Views

Examples of Upstream and Downstream Snaps

Description

Type

Format

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input 

Document

  • Min: 0

  • Max: 1

  • Mapper

  • JSON Formatter

Each document contains the data in the form of JSON.

Output

Document

  • Min: 1

  • Max: 1

  • Join

  • Copy

Each document contains a corresponding response in the form of JSON.

Error

Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter when running the Pipeline by choosing one of the following options from the When errors occur list under the Views tab:

  • Stop Pipeline Execution: Stops the current Pipeline execution if the Snap encounters an error.

  • Discard Error Data and Continue: Ignores the error, discards that record, and continues with the remaining records.

  • Route Error Data to Error View: Routes the error data to an error view without stopping the Snap execution.

Learn more about Error handling in Pipelines.

Snap Settings

  • Asterisk ( * ): Indicates a mandatory field.

  • Suggestion icon (): Indicates a dynamically populated list based on the configuration.

  • Expression icon ( ): Indicates the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.

  • Add icon ( ): Indicates that you can add fields in the field set.

  • Remove icon ( ): Indicates that you can remove fields from the field set.

  • The upload icon ( ): Indicates that you can upload files.

Field Name

Field Type

Description

 

Field Name

Field Type

Description

 

Label*

 

Default ValueWrite
Example: BigTable Write

String

The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your Pipeline.

 

 

Table*

 

Default Value
Example: employee

String/Expression/Suggestion

Specify the name of the table to insert records into the BigTable table

 

Create table if not present

Default state: Unselected
Example: Selected

Checkbox

Select this checkbox to create the table if not present

 

Row Key*

Default Value
Example:

String/Expression/Suggestion

Specify the Row Key of the table

 

Batch Size*

Default Value: 50
Example: 50

Number

Specify the batch size.

The number of records batched per request. If the input has 1000 records and the batch size is set to 100, the total number of requests would be 10.

 

Filter Search Criteria

Specify the filters to select the event information.

Filter Type

Default Value: rowKey
Example: rowKey

String/Expression/Suggestion

Provide/suggest the filter type that you want the Snap to use for the filter.

Match Type

Default Value: exact
Example: exact

String/Expression/Suggestion

Select the match type of the filter.

Value

Default Value: N/A
Example: row#employee#13

String/Expression

Enter the value of the filter type that you want the Snap to use for the filter.

Snap Execution

Default Value: Execute
Example: Validate & Execute

Dropdown list

Select one of the following three modes in which the Snap executes:

  • Validate & Execute: Performs limited execution of the Snap and generates a data preview during Pipeline validation. Subsequently, it performs complete execution of the Snap (unlimited records) during Pipeline runtime.

  • Execute only: Performs complete execution of the Snap during Pipeline execution without generating preview data.

  • Disabled: Disables the Snap and all Snaps that are downstream from it.

 

 

Snap Pack History