Configuration config
The general configuration that is used to generate the objects with the requested settings.
Fabric Configuration
The configuration needed to build the model
| Name | Type | Description |
|---|---|---|
| Environment | String | Environment (PRD, TST, ACC, DEV) used in Azure Devops pipeline |
| EnvironmentDescription | String | Longer name for the environment like Production |
| ServiceConnection | String | Name of the service connection in Azure DevOps |
| VsSolutionName | String | Filename of the Visual Studio solution |
| Apiconfigfile | String | Filepath to the api configuration file |
| MetaFolder | String | Path on the Meta lakehouse in fabric for the meta data files |
| TenantId | String | The tenant id where this is deployed |
| ApplicationClientId | String | The application id that is used to deploy things that require a service principal for authentication. |
| ApplicationKeyvaultSecret | String | The secret name in the keyvault for the service principal |
| ColumnNamesToLower | bool | All columns generated will be lowercase (except for the system columns, those are in UPPER case |
| ColumnNamesAutoFix | bool | If a column has special characters not suitable for delta table those will be replaced |
| RemoveNewLineFromScripts | bool | |
| BronzeConnectionPrefix | bool | Bronze objects will have a connection prefix |
| DataplatformFolder | String | The root dataplatform folder |
| TempFolder | String | The temp folder for local temp in the project. |
| DatabaseFolder | String | Folder where the object yaml files are located |
| DatabaseOutputFolder | String | Folder where the generated table definitions and view definitions will be saved |
| NotebooksFolder | String | Folder where the notebook folders are located |
| NotebooksOutputFolder | String | Folder where the generated notebooks will be saved |
| RequestFolder | String | Folder where the requests will be saved. Useful for debugging purposes |
| FabricProjectName | String | The project where the generated objects will be saved into |
| DimObjectPrefix | String | A prefix for a dimension table in Gold |
| FactObjectPrefix | String | A prefix for a fact view in Gold |
| DimSurrogatekeyPrefix | String | A prefix for a surrogate key column in Gold |
| TransformationObjectPrefix | String | A prefix for a transformation table in Gold |
| Workspace | String | Workspace for this environment in Fabric |
| Keyvault | String | Keyvault for this environment |
| SchemaHistory | String | History schema used for history tables (default='his') |
| FunctionAppName | String | The name of the Azure Function used for the triggers |
Fabric Lakehouse
| Name | Type | Description |
|---|---|---|
| Lakehouse (Required) | String | Name of the lakehouse for the given layer |
| Layer (Required) | FabricMedallionLayer | Layer for the medallion architecture: Bronze, Silver, Gold |
| Workspace (Required) | String | Fabric Workspace name (workspace has to exist and user needs access) |
Tabular Models
| Name | Type | Description |
|---|---|---|
| Model (Required) | String | Name of the lakehouse for the given layer |
| TabularName (Required) | FabricMedallionLayer | Layer for the medallion architecture: Bronze, Silver, Gold |
| CompatibilityLevel (Required) | String | Fabric Workspace name (workspace has to exist and user needs access) |
| AddMembers | bool | |
| DatabaseSchema | String | |
| Workspace | String | |
| DefaultPowerBIDataSourceVersion | String | |
| LoginType | String | |
| PartitionDeployment | bool | |
| RoleDeployment | bool | |
| Lakehouse | String | |
| BimFolder | String | |
| BimFile | String | |
| SourceQueryCulture | String | |
| ModelFolder | String | |
| ModelFile | String | |
| DataSourceType | String | |
| DataSourceName | String | |
| Dataset | String | |
| TabularSystemFolder | String | |
| MeasureTemplateFile | String | |
| FormatStringFile | String |
Power BI Reports
| Name | Type | Description |
|---|---|---|
| GroupName | String | A name for the group of reports. Used to reference this setting in Azure DevOps pipeline |
| FilePath | FabricMedallionLayer | Relative filepath to the reports.yaml config file |
| ReportFolder | String | Relative Path to the folder with the PBIX files |
Bronze and Silver Table settings
Can be set as bronzetablesettings and silvertablesettings
| Name | Type | Description |
|---|---|---|
| delta.enableChangeDataFeed | bool | |
| delta.autoOptimize.optimizeWrite | bool | |
| delta.autoOptimize.autoCompact | bool | |
| delta.logRetentionDuration | String | |
| delta.deletedFileRetentionDuration | String | |
| spark.sql.parquet.vorder.default | bool | |
| spark.databricks.delta.optimizeWrite.enabled | bool | |
| spark.sql.parquet.vorder.default | bool | |
| delta.stats.extended.collect | bool | |
| delta.stats.extended.inject | bool |
Those settings are added to the table creation script when generated.