Peliqan icon

Peliqan

Get data from Peliqan

Actions8

Query → Execute SQL Query

AI-generated

Summary

Execute an arbitrary SQL query against a selected data warehouse in Peliqan and retrieve the query results.

Inputs

  • Data Warehouse Name or ID (required) — Select a data warehouse by choosing from the dropdown list or specifying its ID via an expression.
  • SQL Query (required) — Provide the SQL query string to execute, for example, 'SELECT * FROM my_table;'.

Output shape

a single JSON object containing the results of the executed SQL query

The output contains the JSON response from the Peliqan API representing the query results. It includes details as returned by the 'fetch' action on the selected data warehouse server. Pagination is not indicated in the operation, so all results are returned in one response.

Links

Discussion