Scripting: Python and R

You can create scripts using Python or R by adding the relevant node to your data flow and add the output as columns to the existing table, or to a new table.

The R and Python nodes may only be connected to Select, Query, or Multi Select nodes. Using the R node you can create or reference a "regular script," while the Python node can also be used to create learn and predict scripts.

There are three ways to configure your script in the Properties panel:

  • Write a script in the Script window
  • Click the shopping cart icon to download a script from the Marketplace
  • Click the folder icon to select an existing script that's been saved to the CMS



When writing R scripts, you must specify the packages that should be downloaded.


Python packages are managed from the Admin console under Scripting Environments. Simply select the required environment from the relevant drop down in the Properties panel; click the Packages button see which packages have been downloaded to the given environment.