Skip to main content

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

NameTypeDescription
EnvironmentStringEnvironment (PRD, TST, ACC, DEV) used in Azure Devops pipeline
EnvironmentDescriptionStringLonger name for the environment like Production
ServiceConnectionStringName of the service connection in Azure DevOps
VsSolutionNameStringFilename of the Visual Studio solution
ApiconfigfileStringFilepath to the api configuration file
MetaFolderStringPath on the Meta lakehouse in fabric for the meta data files
TenantIdStringThe tenant id where this is deployed
ApplicationClientIdStringThe application id that is used to deploy things that require a service principal for authentication.
ApplicationKeyvaultSecretStringThe secret name in the keyvault for the service principal
ColumnNamesToLowerboolAll columns generated will be lowercase (except for the system columns, those are in UPPER case
ColumnNamesAutoFixboolIf a column has special characters not suitable for delta table those will be replaced
RemoveNewLineFromScriptsbool
BronzeConnectionPrefixboolBronze objects will have a connection prefix
DataplatformFolderStringThe root dataplatform folder
TempFolderStringThe temp folder for local temp in the project.
DatabaseFolderStringFolder where the object yaml files are located
DatabaseOutputFolderStringFolder where the generated table definitions and view definitions will be saved
NotebooksFolderStringFolder where the notebook folders are located
NotebooksOutputFolderStringFolder where the generated notebooks will be saved
RequestFolderStringFolder where the requests will be saved. Useful for debugging purposes
FabricProjectNameStringThe project where the generated objects will be saved into
DimObjectPrefixStringA prefix for a dimension table in Gold
FactObjectPrefixStringA prefix for a fact view in Gold
DimSurrogatekeyPrefixStringA prefix for a surrogate key column in Gold
TransformationObjectPrefixStringA prefix for a transformation table in Gold
WorkspaceStringWorkspace for this environment in Fabric
KeyvaultStringKeyvault for this environment
SchemaHistoryStringHistory schema used for history tables (default='his')
FunctionAppNameStringThe name of the Azure Function used for the triggers

Fabric Lakehouse

NameTypeDescription
Lakehouse (Required)StringName of the lakehouse for the given layer
Layer (Required)FabricMedallionLayerLayer for the medallion architecture: Bronze, Silver, Gold
Workspace (Required)StringFabric Workspace name (workspace has to exist and user needs access)

Tabular Models

NameTypeDescription
Model (Required)StringName of the lakehouse for the given layer
TabularName (Required)FabricMedallionLayerLayer for the medallion architecture: Bronze, Silver, Gold
CompatibilityLevel (Required)StringFabric Workspace name (workspace has to exist and user needs access)
AddMembersbool
DatabaseSchemaString
WorkspaceString
DefaultPowerBIDataSourceVersionString
LoginTypeString
PartitionDeploymentbool
RoleDeploymentbool
LakehouseString
BimFolderString
BimFileString
SourceQueryCultureString
ModelFolderString
ModelFileString
DataSourceTypeString
DataSourceNameString
DatasetString
TabularSystemFolderString
MeasureTemplateFileString
FormatStringFileString

Power BI Reports

NameTypeDescription
GroupNameStringA name for the group of reports. Used to reference this setting in Azure DevOps pipeline
FilePathFabricMedallionLayerRelative filepath to the reports.yaml config file
ReportFolderStringRelative Path to the folder with the PBIX files

Bronze and Silver Table settings

Can be set as bronzetablesettings and silvertablesettings

NameTypeDescription
delta.enableChangeDataFeedbool
delta.autoOptimize.optimizeWritebool
delta.autoOptimize.autoCompactbool
delta.logRetentionDurationString
delta.deletedFileRetentionDurationString
spark.sql.parquet.vorder.defaultbool
spark.databricks.delta.optimizeWrite.enabledbool
spark.sql.parquet.vorder.defaultbool
delta.stats.extended.collectbool
delta.stats.extended.injectbool

Those settings are added to the table creation script when generated.