Execute Query

Executes a query using the query builder. The <code>from</code> field is required.

<p>Minimal example: <pre> { "from": [ { "catalogName": "peaka", "schemaName": "query", "tableName": "samplequery" } ] } </pre> <p>With columns, filters, limit, offset, and orderBy: <pre> { "columns": ["amount"], "from": [ { "catalogName": "wilderman_green", "schemaName": "payment", "tableName": "charges" } ], "filters": { "and": [ [ { "column": { "catalogName": "wilderman_green", "schemaName": "payment", "tableName": "charges", "columnName": "amount" } }, ">", [150] ] ] }, "limit": 50, "offset": 0, "orderBy": ["amount DESC"] } </pre>

Executes a query by its ID.

<pre> { "id": "709922802836177297" } </pre>

Executes a query by its fully qualified name in the format <code><catalogName>.<schemaName>.<tableName></code>.

<pre> {"qualifiedName": "peaka.query.samplequery"} </pre>

Executes a raw SQL statement directly via the queries/execute endpoint.

<pre> { "statement": "SELECT * FROM \"peaka\".\"query\".\"samplequery\"", "bindArgs": ["arg1", "arg2"] } </pre>