Benefit of Using / Best Practice:
Allows user to apply a function based on a dynamically (run-time) selected set of columns; as new columns matching the criteria are added to the source tables, the function will be applied to them. This feature offers flexibility and ease-of-use, empowering users to streamline data processing without being limited to regular expressions.
Differentiates Us? (compared to SQL or competitor)
StreamSets can apply functions to a set of columns chosen by a regular expression. For example, you could apply a user defined function to columns with name ending "_DATE". New columns would automatically get the function applied.
When it comes to dates, never again get your interval wrong. How many times in the world of code do you sit and wonder, is 'month' a capital 'M', or does that mean minute? StreamSets reduces the need to search elsewhere like on Stack Overflow or read through documentation.
Productivity Impact (H/M/L):
H