Language interoperability
Pass data between Python, R and SQL blocks in the same project.
You can mix Python, R and SQL blocks in one project, and pass data between them. A dataframe created in a Python block can be used in an R block connected after it, and the other way round. A SQL block can query a dataframe from a Python block.
How it works
When a block runs, its outputs are saved in common formats, such as Parquet for dataframes, along with information about each variable. Each language has its own runtime, which reads those saved results. So you don't need to write code to convert data between languages.
Example
A SQL block pulls trades from your warehouse. A Python block cleans them and calculates returns. An R block fits a statistical model to the returns, using an R package your team prefers.
Last updated
Was this helpful?
