appmixer.aws.redshift.UpdatedRow
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. |
| Updated Date Column | text | The 'updatedDateColumn' specifies the column in your database table that records the timestamp each time a row is updated. This column is essential for tracking changes and identifying the most recently modified rows. Typically, this could be a column with a datetime or timestamp data type, automatically updated to the current time whenever a row is altered. |
| Primary Key | text | The 'primaryKey' refers to the unique identifier column of your database table. This column is used to distinguish each row with a unique value, ensuring that each row can be individually identified and tracked. |
| Field | Type | Description |
|---|---|---|
| Row | - |