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