Publication concepts

Publication lets you create versioned releases of a project and deploy those releases to development, staging, or production environments. Publication applies only to SQL projects that use Simple Version Control. Projects that use standard Git workflows manage releases through Git instead.

​

Publication workflow

Projects move through three lifecycle stages:

​

Save a draft

As you develop and edit your project, you can save drafts to store in-progress project changes before publication. Use drafts to:

• Save work while continuing development.
• Collaborate with other users.
• Review changes before publication.
• Prepare a version for deployment.

Saving a draft does not create a deployable project version and does not make changes available in deployment environments.

​

Publish a version

Publishing creates a versioned release of your project. A published release can be deployed to one or more environments, but publishing alone does not deploy it. Until deployment occurs, the published version remains available in Prophecy but is not yet available in a development or production environment. When you publish a version, Prophecy:

• Assigns a version number and description.
• Packages the project.
• Makes the version available for deployment.

Published versions are immutable. After a version is published, it cannot be modified. Any changes require publishing a new version. This allows Prophecy to preserve published versions as stable references for deployment and rollback. This helps you:

• Track project changes over time.
• Deploy consistent versions across environments.
• Roll back to earlier project versions if necessary.

​

Deploy a project

When you deploy a project,you make a published version available for execution in a specific deployment environment. In Prophecy, deployment environments are called fabrics. Examples include development, staging, and production environments for platforms such as Databricks, Snowflake, or BigQuery. Different environments often require different configurations, such as connections, schemas, or runtime parameters. You can use project parameter sets to apply environment-specific configuration during deployment. During deployment, Prophecy:

• Builds the project in the selected environment.
• Applies the selected project parameter set.
• Creates or updates the deployment for that environment.

You can deploy different versions of the same project to different environments. For example, a development environment might run version 1.1 while production continues to run version 1.0 until validation is complete. Each environment (such as Dev or Prod) can contain only one deployed version of a project at a time. After deployment, you can schedule pipelines independently for each environment.