In some contexts, like when setting the values of Environment Variables...or setting the Output Columns of a Join component...red triangles appear in the top-right corners of some of the fields that I modify.
If you're familiar with Excel, it looks very similar to the indicator that a cell has a comment, in an Excel spreadsheet.
What is the meaning of these red triangles, in Matillion?
4 Community Answers
Kevin Havice —
Oops, I mean the red triangle appears in the top-LEFT corner of the field.
(It's in Excel where the comment indicator appears in the top-right of the cell!)
This usually means that the field is not valid for some reason, but can also just be an indicator that something was changed.
You’ll see it if a mandatory value is missing (e.g. if an Output Column in a join component is not given a name), or (temporarily) if an Output Column’s name has been changed.
If there is an error which makes the component itself fail to validate, you’ll see the component’s border turn red. There will also be an accompanying error message in the Properties of the component which should help explain the error.
Personally, I think it's useful to indicate errors. But I don't want an indicator to say that something has changed.
Or, if it is necessary to keep an indicator to show that something changed, then I think that should be different from the error indicator. Maybe have the red triangle mean "error," but to show that something has changed, make it a different color? Like a blue triangle?
Yes, I agree that it can be a little confusing. The grids are generic HTML5 components, and their main aim is to highlight changes. We also have some validation on top of that in case of parse errors.
The best way to check for errors is by looking at the main component Properties, and the outline of the component on the canvas. When all is good, you should get a row of green OK’s and a green border on the component.