Peliqan icon

Peliqan

Get data from Peliqan
Join our community

Actions8

Overview

This node allows users to execute SQL queries against a selected data warehouse within the Peliqan platform. It is useful for retrieving, manipulating, or analyzing data stored in various data warehouses supported by Peliqan. Typical use cases include running custom SELECT statements to fetch data, performing data transformations via SQL, or integrating query results into automated workflows.

For example, a user might select their data warehouse and run a query like SELECT * FROM sales_data WHERE region = 'EMEA'; to extract regional sales figures for further processing or reporting.

Properties

Name Meaning
Data Warehouse Name or ID Select the target data warehouse from a list or specify its ID using an expression. This determines where the SQL query will be executed.
SQL Query The SQL statement to execute on the selected data warehouse. Supports multi-line input. Example: SELECT * FROM my_table;

Output

The node outputs the result of the executed SQL query in the json field of the output items. This typically contains an array of objects representing rows returned by the query, with each object’s keys corresponding to column names.

If the query modifies data (e.g., INSERT, UPDATE), the output may contain metadata about the operation's success or affected rows.

No binary data output is indicated by the source code.

Dependencies

  • Requires an API key credential for authenticating with the Peliqan platform.
  • Needs access to the Peliqan API endpoint (https://app.eu.peliqan.io/).
  • The node depends on the Peliqan service being available and the specified data warehouse existing and accessible.

Troubleshooting

  • Common issues:

    • Invalid or missing API credentials will prevent connection to the Peliqan API.
    • Specifying a non-existent or inaccessible data warehouse will cause errors.
    • Malformed SQL queries will result in execution errors from the data warehouse.

  • Error messages and resolutions:

    • Authentication errors: Verify that the API key credential is correctly configured and has necessary permissions.
    • "Data warehouse not found" or similar: Check the selected warehouse name or ID is correct.
    • SQL syntax errors: Validate the SQL query syntax before running.
    • Network or timeout errors: Ensure network connectivity to the Peliqan API endpoint.

Links and References

Discussion