2026.8.25.4

Overview
Name azureelasticsql
Tag 2026.8.25.4
FullName br:bicepacrdevwcom.azurecr.io/bicep/modules/existing/sql/elasticpool/azureelasticsql:2026.8.25.4
Last updated 2026-08-25 10:39:00:+00:00
Created 2026-08-25 10:39:00:+00:00
Digest sha256:3d8972cc9af6a3043be7ace2b6a9bda816b2a92569acd5e8412f1144e126b9ac

Parameters

Name Type Required Description
env string Yes The environment to be created
sqlDBs array Yes Array of databases and collation. If not specified, default collation is Finnish_Swedish_CI_AS. Example:
var sqlDatabases = [
{
name: 'databaseName'
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
elasticPoolName string Yes
serverName string Yes
defaultCollation string No
'Finnish_Swedish_CI_AS'
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
serverName string

Example

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

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

@description('Array of databases and collation. If not specified, default collation is Finnish_Swedish_CI_AS. Example:
var sqlDatabases = [
  {
    name: 'databaseName'
    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 elasticPoolName string

param serverName string


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