Delete Rows
The Delete Rows stage removes one or more rows from any Supabase table based on filter conditions.
Input Parameters
| Parameter | Variable | Required | Description |
| Table Name | {{tableName}} | Yes | The name of the table to delete from |
| Filters | {{filters}} | Yes | Filter string to identify rows to delete |
Output
| Output | Variable | Description |
| Deleted Rows | {{deletedRows}} | Array of deleted row objects |
| Success | {{success}} | Boolean indicating if the delete succeeded |
Usage Examples
Example 1: Delete Single Row by ID
| Parameter | Value |
| tableName | users |
| filters | id=eq.123 |
Example 2: Delete Multiple Rows by IDs
| Parameter | Value |
| tableName | orders |
| filters | id=in.(101,102,103) |
Example 3: Delete by Condition
| Parameter | Value |
| tableName | users |
| filters | status=eq.inactive |
Example 4: Delete with Multiple Conditions
| Parameter | Value |
| tableName | sessions |
| filters | status=eq.expired&created_at=lt.2024-01-01 |
Example 5: Delete by Pattern Match
| Parameter | Value |
| tableName | users |
| filters | email=ilike.*@test.com |
Safety Considerations
| Filter | Risk Level | Rows Affected |
| id=eq.123 | Safe | 1 specific row |
| id=in.(1,2,3) | Safe | Specific rows only |
| user_id=eq.456 | Medium | All rows for that user |
| status=eq.deleted | Medium | Could be many rows |
| created_at=lt.2024-01-01 | High | Potentially many rows |
Important Notes
- Deletes are permanent - always double-check filters
- Test with Query Rows first to see what would be deleted
- Returns deleted data in {{deletedRows}} for verification