Skip to main content

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​

Dependencies allow you to import external or custom packages into your project.

SQL Dependencies

Package Hub​

The Package Hub is a catalog of versioned projects that contain shareable components, such as pipelines, gems, user-defined functions, business rules, macros, and more. Browse the Package Hub to view available add-ons for SQL projects.

SQL packages

SQL Gem Builder​

Use the SQL Gem Builder to develop custom gems for individual or shared use. SQL gems are dbt macros that have a visual (UI) layer.

SQL Gem Builder