Extensibility

SQL projects are highly extensible, meaning you can add additional capabilities and functionalities beyond our out-of-the-box offerings. When you build new components in Prophecy, you can package, version, and share them for collaboration and control. You can accomplish this using the following features.

Dependencies

Make use of external or custom components in your pipelines and models

Functions

Build functions with SQL macros to be used in gem expressions

Stored procedures

Create and call stored procedures to use in pipelines

Gem Builder

Build custom gems for SQL models and pipelines