Versions Compared

Key

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

In this article

Table of Contents
minLevel1
maxLevel2
absoluteUrltrue

...

Support for Ultra Pipelines

Does not work in Ultra Pipelines

Known Issues and Limitations

...

Field/Fieldset Name

Field TypeField Dependency

Description

Label*

Default valueGeneric JDBC - Schema List

Example: Load Employee Schema

StringNone.

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

Snap Execution

Default valueValidate & Execute
Example: Execute only

Dropdown listN/A

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.

Examples

The following example pipeline demonstrates how to retrieve all the schemas for the selected account. 

...

Configure the Generic JDBC - Schema List Snap as follows.

...

On validation, the Snap displays the following output:

...

Snap Pack History

...

titleClick here to expand...

...

Release 

...

Snap Pack Version

...

Date

...

Type

...

  Updates

...

February 2024

...

...

Stable

Added the following Snaps in the JDBC Snap Pack:

...

Generic JDBC - Schema List: Obtains a list of schemas for the specified account from the database.

...

Download this pipeline.

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

Snap Pack History

Expand
titleClick here to expand...

Insert excerpt
JDBC Snap Pack
JDBC Snap Pack
nameJDBC_SPH
nopaneltrue

...