Biron icon

Biron

Interact with Biron API, for reverse ETL and more

Actions2

Datalake → Query

AI-generated

Summary

Execute a Clickhouse SQL query on a specified Biron datalake node and return the query results as JSON objects.

Inputs

  • Clickhouse Query (required) — The SQL query statement to execute on the Clickhouse datalake. Must be a valid SELECT query as per Clickhouse SQL syntax.
  • Clickhouse Node (required) — Identifier of the Clickhouse node hosting your datalake data, provided by Biron upon request.

Output shape

a list of JSON objects, each representing one row from the query result

The response is parsed from the server's JSONEachRow format. Each output item is paired with the input item index for tracing. Errors during query execution are raised as NodeApiError exceptions.

Links

Discussion