SQLDatabase
Properties
| Property | Type | Attributes | Description |
|---|---|---|---|
displayName | string | Required | The item display name |
workspaceId | string | Required, Identifier | The containing Fabric workspace ID |
backupRetentionDays | int | Read-only | The backup retention period in days |
collation | string | Read-only | The collation of the database |
configuration | SQLDatabaseConfiguration | The SQL Database creation configuration. Changing this forces recreation of the SQL Database. | |
connectionString | string | Read-only | The connection string of the database |
databaseName | string | Read-only | The database name |
definition | FabricItemDefinition | The item definition | |
description | string | The item description | |
earliestRestorePoint | string | Read-only | The earliest point in time the database can be restored to |
folderId | string | The folder that contains the item | |
id | string | Read-only, Identifier | The Fabric item ID |
latestRestorePoint | string | Read-only | The latest point in time the database can be restored to |
serverFqdn | string | Read-only | The server fully qualified domain name (FQDN) |
tags | string[] | The IDs of the tags applied to the item. Tags applied outside of Bicep are left untouched when this is not set. | |
type | string | Read-only | The Fabric item type |
SQLDatabaseConfiguration
| Property | Type | Attributes | Description |
|---|---|---|---|
creationMode | 'New' | 'Restore' | 'RestoreDeletedDatabase' | Required | The creation mode of the SQL database |
backupRetentionDays | int | The backup retention period in days. Minimum 1, maximum 35. | |
collation | string | The collation of the SQL database. Only applies when creationMode is 'New'. | |
restorableDeletedDatabaseName | string | The name of the restorable deleted database to restore. Required when creationMode is 'RestoreDeletedDatabase'. | |
restorePointInTime | string | The point in time (UTC, YYYY-MM-DDTHH:mm:ssZ) to restore the source database from. Applies when creationMode is 'Restore' or 'RestoreDeletedDatabase'. | |
sourceDatabaseReference | SQLDatabaseSourceReference | The source database to restore from. Applies when creationMode is 'Restore'. |
FabricItemDefinition
| Property | Type | Attributes | Description |
|---|---|---|---|
parts | FabricItemDefinitionPart[] | Required | The item definition parts |
format | string | The definition format |
SQLDatabaseSourceReference
| Property | Type | Attributes | Description |
|---|---|---|---|
itemId | string | Required | The ID of the source item |
workspaceId | string | Required | The workspace ID of the source item |
FabricItemDefinitionPart
| Property | Type | Attributes | Description |
|---|---|---|---|
path | string | Required | The definition part path |
payload | string | Required | The base64-encoded definition part payload |