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:
Default value: Execute only |
Snap Pack History
Â
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.