Apply Azure SQL database free offer via Terraform

Question

Is it possible to apply the free offer via Terraform? So far I can only apply it when I manually create the database and click on the "Apply offer" button.

I would expect that this is possible, since this offer has been around for 1-2 years, but I have not found anything about it.

The “Apply offer” feature is a UI-specific workflow.Microsoft has not published an API or flag to enable the offer programmatically (via ARM, Bicep, or REST either). You can still deploy a serverless database via Terraform, and then manually apply the offer once from the Azure Portal — Venkateswarlu V
– Venkateswarlu V, Commented Apr 16 at 11:31

Venkateswarlu V · Accepted Answer · 2025-04-16 12:07:08Z

0

Apply Azure SQL database free offer via Terraform

AFAIK, it's not possible to apply the Azure SQL free offer via Terraform. The Apply offer option is currently only available through the Azure Portal UI, and there’s no exposed parameter or API in ARM, Bicep, or Terraform to enable it programmatically.

You can, however, deploy a serverless Azure SQL Database using Terraform and then manually apply the offer once through the portal. Once applied, the offer remains active for the lifetime of the subscription (within usage limits), and you can continue to manage the database using Terraform.

answered Apr 16 at 12:07

Venkateswarlu V

8,2932 gold badges5 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Norbi Apr 17 at 8:37

I wanted indeed manually apply the offer after I have created the serverless DB, but I don't have the offer anymore. Location: France Central Pricing tier: General Purpose, Gen5, Vcore 1

trine · Accepted Answer · 2025-04-17 14:59:29Z

0

I tried editing the SKU of a azurerm_mssql_database resource to "Free" and the terraform validation allows this value while throwing errors for any fictional values.

resource "azurerm_mssql_database" "this" {
  name        = "test-db"
  sku_name    = "Free"
  server_id   = azurerm_mssql_server.this.id //defined outside the code snippet
  collation   = "SQL_Latin1_General_CP1_CI_AS"
  max_size_gb = 2
}

I'm not sure if this is equivalent to applying the offer, but I don't know of any other free tier.

So maybe give it a try!

answered Apr 17 at 14:59

trine

1

1 Comment

Blackout May 24 at 7:12

While this works, it is different from applying the free offer from the Portal. Within the Free tier, you will have 5 DTUs and 32 MB of shared storage. And this free DB trial will end in 365 days, after which it will be upgraded to Basic. This is in contrast to the free offer from Portal which will give you 32 GB of storage and 100,000 vCore seconds every month.

Collectives™ on Stack Overflow

Apply Azure SQL database free offer via Terraform

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related