2026.8.26.3

Overview
Name azureelasticsql
Tag 2026.8.26.3
FullName br:bicepacrdevwcom.azurecr.io/bicep/modules/existing/sql/elasticpool/azureelasticsql:2026.8.26.3
Last updated 2026-08-26 07:43:54:+00:00
Created 2026-08-26 07:43:54:+00:00
Digest sha256:d76e3f12f864109a764e3742f61606283c96780d6cfcdd03ac83608a34c0660a

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.26.3' = {
    name: 'azureelasticsql${env}${version}'
    params: {
      env: env
      sqlDBs: sqlDBs
      tags: tags
      location: location
      elasticPoolName: elasticPoolName
      serverName: serverName
    }
}