Azure / Azure/bicep-types-az

Microsoft.Sql/servers/databases: The property "kind" is read-only

Open
#1,933 1 comment 0 reactions 0 assignees View on GitHub
Service Attention SQL
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.