Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field Name

Field Type

Description

Label*

Default ValueBigQuery Table List
ExampleBabynames Table List

String/Expression

Specify a unique name for the Snap. Modify this to be more specific, especially if you have more than one Snap of the same type in your Pipeline.

Project ID

Default Value: N/A
Example: Test-project-324543

String/Expression/Suggestion

Specify the project ID in which the dataset

Dataset ID

Default Value: N/A
Example: project-test-43433

String/Expression/Suggestion

Specify the dataset ID of the destination.

Detailed Information

Default value: Deselected

Checkbox

Select this checkbox to enable the Snap to access additional fields for displaying them in the output.

Snap Execution

Default ValueValidate & Execute
Example: Disabled

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, 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.

Example

Reading a BigQuery Dataset and Listing the Tables

This example Pipeline demonstrates how to read the tables from the a BigQuery dataset and list the tables from the specified dataset in the output.

...

Configure the Snap with the Project ID and the Dataset ID of the dataset from which the table names need to be listed.

...

On validation, the Snap lists the table data tables in the output.

...

Download this Pipeline. 

Attachments
patterns*.slp, *.zip

Downloads

Info
  1. Download and import the Pipeline into SnapLogic.

  2. Configure Snap accounts, as applicable.

  3. Provide Pipeline parameters, as applicable.

Attachments
patterns*.slp, *.zip
sortByname

...