Versions Compared

Old Version 3

changes.mady.by.user Shilpa

Saved on

compared with

New Version 4

changes.mady.by.user Shilpa

Saved on

Key

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

...

You can use this Snap to execute queries such as selecting and joining data across datasets. You can query the Data Lake via SQL-like statements using the query service.

...

Snap Type

The Adobe Experience Platform Execute Snap is a Read-type Snap that reads the data from the input stream.

Prerequisites

  • Valid client ID.

  • The SQL Statement you want to execute.

Support for Ultra Pipelines

Works in Ultra Pipelines. 

Limitations and Known Issues

None.

Snap Views

Type

Format

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input 

Document

  • Min: 0

  • Max: 1

  • Mapper

Ensure to provide input, which is the SQL statement to execute the query.

Output

Document

  • Min: 0

  • Max: 1

  • Mapper

The output document contains the SQL query execution result.

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.

...