appmixer.aws.redshift.NewRow
1.0.0
Public
| Field | Type | Description |
|---|---|---|
| SQL Query | textarea | Enter the SQL query to fetch data from your database. This query should select from the table you want to monitor for new rows. Avoid including a WHERE clause for filtering by the compare field, as this will be handled automatically to detect new entries For example, if you want to monitor a table named 'orders', your query might be SELECT * FROM orders. The component will add necessary conditions to check for new rows. Semicolon will be ignored. |
| Compare Field | text | Specify the field (column name) in your table that will be used to identify new rows. This should be a field with unique, incrementing values, like an auto-increment ID or a timestamp. If your table uses an auto-incrementing ID, you might enter 'id'. If it uses a timestamp to record when each row is added, you might enter 'created_at'. |
| Field | Type | Description |
|---|---|---|
| Row | - |