Run SQL and insert or update rows in a CrateDB cluster from workflows, over its PostgreSQL wire protocol.
Explore 3 workflow actions for CrateDB, including account permissions and operation limits.
0 read actions3 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 CrateDB query
Write
Run parameterized SQL against the selected CrateDB cluster over its PostgreSQL wire protocol.
Permissions and limits
Account permissions
Privileges required by the SQL statement
Operation limits
SQL may change data. Use a CrateDB user with only the privileges this workflow needs.
CrateDB has no transactions; a lost write response is marked uncertain and not repeated.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Insert CrateDB row
Write
Insert one row into a CrateDB table and return it.
Permissions and limits
Account permissions
DML on the table
Operation limits
CrateDB makes new rows visible after a table refresh (about once a second by default).
A repeated request may repeat the external action. Review the previous result before retrying a write.
Update CrateDB rows
Write
Update rows matching one equality condition and return them.
Permissions and limits
Account permissions
DML on the table
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 CrateDB. A saved workflow is not a completed provider action.
