Home › Manage Objects › Common Operations › Add

Add

Add Metadata Objects

In AnalyticsCreator, most metadata elements can be added manually via the navigation tree, toolbar, or diagram. This section lists all supported "Add" operations and describes what each object represents and how it's typically used in a Fabric-based, metadata-driven data warehouse.

ID Add Operation Purpose
1 Add Connector Create a connection to an external system (SQL Server, SAP, REST, etc.). Serves as a parent for sources.
2 Add to Diagram Filter Add filtering rules in the diagram to focus on specific layers, schemas, or objects.
3 Add Import Create a data import definition from an external source into the staging area.
4 Add Export Define an export operation to push data to an external system.
5 Add Source Reference Manually define a relationship between source tables (1:N joins).
6 Add Schema Create a new schema within a DWH layer (staging, core, datamart).
7 Add Import Package ETL package to load raw data into staging tables from sources.
8 Add Historization Package Package that captures historical changes for slowly changing dimensions or facts.
9 Add Historization Define historization logic on individual tables or transformations.
10 Add Persisting Package ETL package for persisting data into core DWH structures (e.g., SCD Type 1/2).
11 Add External Package Wraps custom processes or external systems into the ETL orchestration.
12 Add Script Package ETL package type that executes SQL or PowerShell scripts as part of workflow.
13 Add Export Package Defines logic to export curated data to external targets or reporting layers.
14 Add Workflow Package Controls the sequence and dependencies between other packages.
15 Add Index Create database indexes on DWH tables to optimize performance.
16 Add Role Define security roles for row-level access control in semantic models.
17 Add Stars Create a new star schema representing a subject area in the data mart layer.
18 Add Hierarchy Define drillable levels within dimensions (e.g., Year > Quarter > Month).
19 Add Partition Partition tables by key fields to improve performance and maintainability.
20 Add Macro Create reusable T-SQL or SSIS code blocks for use in transformations.
21 Add Pre-Creation Script Define SQL to run before table creation during deployment.
22 Add Post-Creation Script Define SQL to run immediately after table creation (e.g., indexing).
23 Add Pre-Deployment Script Run SQL logic before the full deployment process begins.
24 Add Post-Deployment Script Run SQL logic after the deployment has finished.
25 Add Pre-Workflow Script Logic executed before running workflow packages.
26 Add Post-Workflow Script Logic executed after workflow execution finishes.
27 Add Repository Extension Script Advanced metadata script that modifies repository objects directly.
28 Add Object Script Script bound to a specific metadata object (e.g., renaming columns).
29 Add Predefined Transformation Create reusable transformation logic applied by data type.
30 Add Snapshot Define a time-based snapshot (e.g., current, prior month) for historization logic.
31 Add Snapshot Group Group multiple snapshots under a logical structure.
32 Add Deployment Create a deployment configuration with environment-specific settings.
33 Add Group Organize metadata objects into logical groups for filtering or workflow control.
34 Add Model Create a semantic model with facts, dimensions, KPIs, and calculations for Power BI.

 

Most "Add" operations are available via the right-click context menu in the navigation tree, or via the toolbar. Each object added becomes part of the repository metadata and is managed centrally in the project.