Tutorial: Deploy Schema Change with Rollout Policy
Role-based rollout
Default roles with permissions
Users with thebb.taskRuns.create
permission can perform rollouts. The following roles have this permission by default:
- Workspace Admin
- Workspace DBA
- Project Releaser
Environment-specific roles
If you want to use different roles to perform rollouts in different environments, you can specify environment-specific roles in the Environment policy settings. This allows you to control who can deploy changes to specific environments, such as having different teams responsible for staging versus production deployments.Automatic rollout
Enable automatic deployment when all checks pass by selecting theautomatic
option. Failed checks will block automatic rollout:
- SQL Review policy violations
Do not enable automatic rollout for GitOps Workflow as it can cause conflicts that result in failures.