The scripting engines allow users to manipulate data during the ETL. Using the Pyramid Marketplace, users can choose from a collection of scripts in a variety of languages. Using R or Python, users are able to write code on top of Pyramid data, to create customized columns and tables.

Scripting Mechanics

Users can configure scripts in a few ways: by downloading them from the Pyramid Marketplace, which catalogs range of Python and R scripts; injecting shared scripts that were built in Formulate and saved to the Pyramid content manager; using AI to generate a script; or writing or pasting a script.

You'll need to define the input columns, to be injected into the script, and the output columns to be generated by the script. You can also choose where the output columns will be stored: within the current table, or in a new table.

You'll also need to set the virtual scripting environment, which will determine which language version, packages, and package versions are available.

  • Click here to learn more about the scripting mechanics.


Python scripts can be written manually, or injected via a shared script. A range of Python scripts are available for download from the Marketplace.

  • Click here to learn more about Python scripting.


Like Python, R scripts can be written or pasted manually, or injected from a shared script that was built and saved in Pyramid. A variety of R scripts can be downloaded from the Marketplace.

  • Click here to learn more about R scripting.