There are two ways how data in KBC can be manipulated: via Transformations (simpler) and Applications (not as simple but more powerful). Both pick data from Storage, manipulate it and then store it back.
Transformations — can be created by writing a free-form manipulation scripts in either SQL (for MySQL, Redshift or Snowflake backend), R, or Python. KBC provides each user with Sandbox — a safe environment for your experiments.
Applications — Unlike the free-form Transformations, Applications are predefined blocks which can be used to do some pretty advanced stuff like sentiment analysis, association discovery, or histogram grouping. Applications can also augment data (for example, add Weather or Exchange Rates) by calling on 3rd party services to bring in additional data. Their functionality can be customized or parametrized to some extent. All applications are implemented as extensions and as such can be completely created by 3rd party developers.
Application and Transformations share many common properties. However, they differ in certain important aspects.
When deciding between the two, consider your capabilities, available resources and the complexity of the task you need to perform. For more details, go to our Developer Documentation.