Microsoft.Sql/servers/databases: The property "kind" is read-only
- Dominant language
- TypeScript
- Stars
- 108
- Forks
- 44
- Avg merge
- 18h 53m
- Merged PRs (30d)
- 29
Description
### Resource Type
Microsoft.Sql/servers/databases
### Api Version
2023-02-01-preview
### Issue Type
Property(s) inaccurately marked read-only/write-only
### Other Notes
I was able to create a serverless Azure SQL DB by setting a kind to `'v12.0,user,vcore,serverless'`, but I'm getting a linter error ` The property "kind" is read-only`
### Bicep Repro
```bicep
param appName string = 'azure-tests'
param location string
resource databaseServer 'Microsoft.Sql/servers@2023-02-01-preview' = {
name: '${appName}-sqlserver'
location: location
properties: { administratorLogin: 'db_username'
administratorLoginPassword: '' } }
resource database 'Microsoft.Sql/servers/databases@2023-02-01-preview' = {
parent: databaseServer
name: '${appName}-sqldb'
location: location
kind: 'v12.0,user,vcore,serverless'
sku: {
name: 'GP_S_Gen5'
tier: 'GeneralPurpose'
family: 'Gen5'
capacity: 1
}
properties: {
collation: 'SQL_Latin1_General_CP1_CI_AS'
maxSizeBytes: 1073741824
catalogCollation: 'SQL_Latin1_General_CP1_CI_AS'
zoneRedundant: false
readScale: 'Disabled'
autoPauseDelay: 60
requestedBackupStorageRedundancy: 'Geo'
minCapacity: '0.5'
isLedgerOn: false
availabilityZone: 'NoPreference'
}
}
```
### Confirm
- [X] I have read the troubleshooting guide and looked for duplicates.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by locating the Microsoft.Sql/servers/databases@2023-02-01-preview type definition and inspect how the kind property is marked. Use the supplied Bicep repro to confirm that setting kind no longer produces the read-only linter error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, sql
- Domain
- cloud, databases, tooling
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100