Run SQL on a QuestDB server and append rows to its tables over the REST API.
Explore 2 workflow actions for QuestDB, including account permissions and operation limits.
0 read actions2 write actions
WORKFLOW ACTIONS
What you can configure.
Choose an action in the workflow builder, connect an account, and map its inputs. These actions are available in the catalog; your account access and a successful test determine whether they work for your setup.
Execute QuestDB query
Write
Run one SQL statement on the QuestDB server and return its rows, or the statement result.
Permissions and limits
Account permissions
The QuestDB user's rights for the statement
Operation limits
QuestDB's REST API has no bound parameters; map values into the SQL only from trusted steps.
SQL may change data. A lost answer is uncertain and never resent automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Insert QuestDB rows
Write
Append rows to an existing QuestDB table, all or nothing.
Permissions and limits
Account permissions
Insert into the table
Operation limits
Rows are imported as CSV through QuestDB's /imp endpoint into an existing table (create=false); values are converted to the table's column types.
A lost answer is uncertain and never resent automatically.
A repeated request may repeat the external action. Review the previous result before retrying a write.
SETUP
Start with a controlled test.
01Connect the intended account
Use the account and permissions required for your process. Review the connection check before configuring a workflow action.
02Review inputs and access
Select a listed operation and map its required inputs. Use test records and add a human approval before writes that need review.
03Confirm the result
Inspect step outputs and confirm the result in QuestDB. A saved workflow is not a completed provider action.