Duplicate
Duplicate Metadata Objects
The Duplicate function in AnalyticsCreator allows you to create a copy of an existing metadata object with all its configurations. This is particularly useful when defining similar roles or deployment settings across multiple domains or environments.
Duplicate Role
Duplicating a role allows you to quickly replicate row-level security definitions. This is useful when you need to define similar access rules across different user groups or business areas (e.g., Finance vs. Sales).
How to Duplicate
- In the Navigation Tree, go to Roles.
- Right-click the role you want to duplicate.
- Select Duplicate.
- Give the new role a name and modify filters or permissions as needed.
Use Cases
- Apply similar security logic across departments
- Create variations of a base role for testing
- Standardize access models across galaxies or stars
Duplicate Deployment
Duplicating a deployment allows you to reuse an existing configuration — such as environment settings, DACPAC output paths, or schema mappings — for another deployment target (e.g., Dev, Test, Prod).
How to Duplicate
- In the Navigation Tree, go to Deployments.
- Right-click the deployment definition you want to duplicate.
- Select Duplicate.
- Rename the copy and adjust environment-specific settings.
Use Cases
- Create deployment pipelines for different environments
- Test changes in a sandbox without altering the main deployment
- Set up backups or rollback configurations
The duplicate feature saves time, ensures consistency, and helps maintain governance by avoiding manual reconfiguration of similar objects.