Dremio Query icon

Dremio Query

Execute custom SQL query on Dremio.

Dremio Query

AI-generated

Summary

Execute a custom SQL query on a Dremio server within optional specified contexts and return the query results as separate JSON items.

Inputs

  • Query (required) — The SQL query string to execute on the Dremio server.
  • Context — Optional array of context strings (database/schema paths) to set the execution context for the query, each representing one context such as a folder or space.

Output shape

a list of JSON objects, each representing a row returned by the query; output is a stream of rows from the completed query job.

The node waits for the query job to complete and then emits each row of the result sequentially as individual output items. If no contexts are provided, the query runs in the default context. Errors during authentication, query execution, or job completion will cause the node to fail.

Examples

Example 1: Querying a table

Provide a SQL SELECT statement in the Query parameter and optional contexts for the database or schema to run the query in.

Links

Discussion