HelixDB

Interact with HelixDB - the time-series database for modern applications. Requires HelixDB server running with deployed HelixQL queries.

Actions8

Raw Query → Run HelixQL

AI-generated

Overview

This node executes raw HelixQL queries against a HelixDB time-series database. It is useful for users who want to run custom, pre-deployed HelixQL queries directly, allowing flexible and advanced data retrieval or manipulation beyond standard CRUD operations. For example, a user can run a query named 'getUserByName' with specific parameters to fetch user data.

Use Case Examples

  1. Run a HelixQL query named 'getUserByName' with parameters to retrieve user details.
  2. Execute a custom HelixQL query to aggregate time-series data stored in HelixDB.

Properties

Name Meaning
HelixQL Query The name of the HelixQL query to execute, which must be already deployed to HelixDB.
Query Parameters Parameters for the HelixQL query provided as a JSON object to customize the query execution.

Output

JSON

  • json - The JSON response returned from executing the HelixQL query, containing the query results or data.

Dependencies

  • Requires a HelixDB API key credential to authenticate and connect to the HelixDB server.

Troubleshooting

  • Ensure the HelixQL query name is correctly spelled and already deployed to the HelixDB server.
  • Verify that the query parameters are valid JSON and match the expected parameters of the HelixQL query.
  • Common error: 'Unsupported operation' if the resource or operation parameters are incorrect; verify that 'resource' is set to 'rawQuery' and 'operation' to 'runHelixQL'.
  • Connection errors may occur if the HelixDB server is not reachable or the API credentials are invalid.

Discussion