[FEAT] Mirrored Azure SQL Database

[Lachlan-White]

🚀 Feature description

Enable the provisioning of Mirrored Azure SQL Database resources into OneLake

🔈 Motivation

Simplify the ability to create a single automation approach to metadata-driven ingestion within Fabric.

🛰 Alternatives

PowerShell within Terraform module for script calls.

🚧 Potential Configuration / Desired Solution

resource "fabric_azure_sql_database" "this" {
  display_name = "MetaDataDrivenIngestion"
  description  = "This is Mirrored SQL Database for Metadata Driven Ingestion"

  source = {
    server_id   = azurerm_mssql_database.source.id
    database_id = azuerm_mssql_database.source.id
  }

  target = {
    workspace_id = fabric_workspace.target.id
    lakehouse_id = fabric_lakehouse.bronze.id
    type         = "DeltaTables"
  }
}

📎 Additional context

No response

☑️ Acceptance Criteria

No response

🔰 Code of Conduct

• I agree to follow this project's Code of Conduct.