Dremio JDBC - Execute

In this article

Overview

You can use the Dremio JDBC Execute Snap to send SQL queries to a Dremio instance, which can be used to retrieve data from different data sources connected to Dremio.

Snap Type

Dremio JDBC - Execute is a Write-Snap to execute SQL statement/query.

Prerequisites

  • None.

Limitations and Known Issues

None.

Snap Views

Input

This Snap has at most one document input view. Each document contains data in the form of json..

Output

This Snap has at most one document output view. Each document contains corresponding response in the form of json.

Error

This Snap has at most one document error view and produces zero or more documents in the view. Each document contains the corresponding error record if snap is not able to process data.

Snap Settings

Label

required

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.

SQL statement

required

User can provide the SQL statement to execute.

Pass through

 Check box

Snap Execution

optional

Specifies the execution type:

  • Validate & Execute: Performs limited execution of the Snap (up to 2000 records based on Preview doc count, default is  50 records) during Pipeline validation; performs full execution of the Snap (unlimited records) during Pipeline execution.

  • Execute only: Performs full execution of the Snap during Pipeline execution; does not execute the Snap during Pipeline validation.

  • Disabled: Disables the Snap and, by extension, its downstream Snaps.

Default value: Execute only

Snap Pack History