2026.8.26.3

Overview
Name azuresql
Tag 2026.8.26.3
FullName br:bicepacrdevwcom.azurecr.io/bicep/modules/existing/sql/azuresql:2026.8.26.3
Last updated 2026-08-26 07:43:52:+00:00
Created 2026-08-26 07:43:52:+00:00
Digest sha256:7424b1c3eee1ab950f55714cb79bff1c22cf5ed0a3baafbcec049738e588f8dc

Parameters

Name Type Required Description
env string Yes The environment to be created
sqlDBs array Yes Array of databases, collation and SKU. If not specified, default collation is Finnish_Swedish_CI_AS. Example:
var sqlDatabases = [
{
name: 'databaseName'
skuName: 'S0'
collation: 'Finnish_Swedish_CI_AS'
backupLongTermRetentionPoliciesWeeklyRetention: 'P12W'
backupLongTermRetentionPoliciesMonthlyRetention: 'P24M'
backupLongTermRetentionPoliciesYealyRetention: 'P10Y'
backupLongTermRetentionPoliciesWeekOfYear: 2
backupShortTermRetentionPoliciesDays: 20
}
]

Will generate a valid Managed Identity connection string output:
moduleName.outputs.connectionStrings.Database1
moduleName.outputs.connectionStrings.Database2
tags object Yes
location string Yes
serverName string Yes
defaultCollation string No
'Finnish_Swedish_CI_AS'
defaultSkuName string No
'S0'
defaultBackupShortTermRetentionPoliciesDays int No
if(or(equals(env, 'prd'), equals(env, 'prod')), 15, 7)
defaultBackupLongTermRetentionPoliciesWeeklyRetention string No
if(or(equals(env, 'prd'), equals(env, 'prod')), 'P8W', 'PT0S')
defaultBackupLongTermRetentionPoliciesMonthlyRetention string No
if(or(equals(env, 'prd'), equals(env, 'prod')), 'P12M', 'PT0S')
defaultBackupLongTermRetentionPoliciesYearlyRetention string No
if(or(equals(env, 'prd'), equals(env, 'prod')), 'P10Y', 'PT0S')
excludedRetentionPolicyDatabases array No
[
]

Outputs

Name Type Description
connectionstrings object
sqlDBIDs object
serverID string

Example

@description('The target environment.')
param env string

@description('The deployment version.')
param version string = '1.0.0.0'

@description('Array of databases, collation and SKU. If not specified, default collation is Finnish_Swedish_CI_AS. Example:
var sqlDatabases = [
  {
    name: 'databaseName'
    skuName: 'S0'
    collation: 'Finnish_Swedish_CI_AS'
    backupLongTermRetentionPoliciesWeeklyRetention: 'P12W'
    backupLongTermRetentionPoliciesMonthlyRetention: 'P24M'
    backupLongTermRetentionPoliciesYealyRetention: 'P10Y'
    backupLongTermRetentionPoliciesWeekOfYear: 2
    backupShortTermRetentionPoliciesDays: 20
  }
]

Will generate a valid Managed Identity connection string output:
moduleName.outputs.connectionStrings.Database1
moduleName.outputs.connectionStrings.Database2')
param sqlDBs array

param tags object

param location string

param serverName string


module azuresql 'br:bicepacrdevwcom.azurecr.io/bicep/modules/existing/sql/azuresql:2026.8.26.3' = {
    name: 'azuresql${env}${version}'
    params: {
      env: env
      sqlDBs: sqlDBs
      tags: tags
      location: location
      serverName: serverName
    }
}