Dependencies

Dependencies allow you to reuse logic in your SQL projects, so you can build on work that’s already been tested and versioned. Dependencies are scoped at the project level, and can include packaged Prophecy projects, as well as external packages from GitHub or the dbt Hub. Because packages can be improved over time, you can update your project dependencies whenever a new version is published. Your project will continue to use the current version until you choose to upgrade.

​

Dependency types

There are three types of dependencies for SQL projects.

​

Prophecy Project

When you import a project from the Package Hub as a dependency, you gain access to all its components, including pipelines, gems, and functions for use in your own project. If a new version of the project is published, you can update your dependency version to take advantage of the latest changes. Prophecy Project dependencies have the following parameters:

​

GitHub

Dependencies can be saved to GitHub repositories and imported from there. GitHub dependencies have the following parameters:

​

dbt Hub

Packages in the dbt Hub can be used to extend typical SQL functionality. If the package contains macros, you can use them via the Macro gem. dbt Hub dependencies have the following parameters:

​

Add a dependency to your project

To add a dependency to your project:

1. Open the project settings menu beside the project name in the project header.
2. Select Dependencies.
3. Click + Add Dependency.
4. Choose the dependency type (Project, GitHub, or DBT Hub).
5. Fill in the required fields to import the correct package version.
6. Click Create.
7. Click Reload and Save to validate and download the new dependency.

​

Use dependency components in your project

When you add a dependency to your project:

• The dependency will be visible in the Packages section of the left sidebar. Expand a dependency to view the various functions, gems, and other components that it may contain. You can drag these components directly onto the visual canvas.
• Any gems in the package will automatically appear in the gem drawer on the canvas itself.

​

Manage your project dependencies

To manage your project dependencies, there are two options: A) Open your project in the Studio. Then, open the project settings menu beside the project name and select Dependencies. B) Open your project in the Studio. Then, hover the Packages section of the left sidebar and click the gear icon. From here, you can add, edit, update, or remove dependencies from your project.