Actions8
- Table Actions
- Endpoint Actions
- Pipeline Actions
- Query Actions
- Script Actions
Overview
This node allows users to execute SQL queries against a selected data warehouse within the UbuntuFabric platform. It is useful for retrieving, manipulating, or analyzing data stored in various data warehouses connected to the platform. Typical use cases include running custom SELECT statements to fetch data, performing data transformations via SQL, or integrating query results into larger workflows for reporting or automation.
For example, a user might select their "Sales Data Warehouse" and run a query like SELECT * FROM customers WHERE region = 'EMEA'; to extract customer data for further processing.
Properties
| Name | Meaning |
|---|---|
| Data Warehouse Name or ID | Select the target data warehouse by name or ID from a list of available connections. |
| SQL Query | The SQL statement to execute on the selected data warehouse. Supports multi-line input. |
Output
The node outputs the result of the executed SQL query in the json field of the output data. This typically contains an array of objects where each object represents a row returned by the query, with key-value pairs corresponding to column names and their values.
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 active connection to a data warehouse configured in the UbuntuFabric platform.
- Needs an API authentication token or credential to access the UbuntuFabric API endpoint (
https://app.ubuntufabric.io/). - The node uses a POST request to the internal API proxy endpoint
/api/proxy/db/to submit the SQL query.
Troubleshooting
Common issues:
- Invalid or missing data warehouse selection will prevent query execution.
- Syntax errors in the SQL query will cause the API to return errors.
- Network or authentication failures can block communication with the UbuntuFabric API.
Error messages:
- Errors related to authentication usually indicate missing or invalid API credentials; verify and update them accordingly.
- SQL syntax errors are returned from the database engine; review and correct the query string.
- Connection timeouts or unreachable endpoints suggest network issues or incorrect base URL configuration.
Links and References
- n8n Expressions Documentation
- UbuntuFabric platform documentation (not publicly linked here) for details on data warehouse setup and API usage.