How do I get the connection string out of the sql pool I have created in terraform.
Please see the code below, I cannot find anywhere how to output the any data from azurerm_synapse_sql_pool
resource "azurerm_storage_account" "telemetrystoragedl" {
name = "${var.rg-name}telemstoredl"
resource_group_name = azurerm_resource_group.altoterraformgroup.name
location = azurerm_resource_group.altoterraformgroup.location
account_tier = "Standard"
account_replication_type = "LRS"
account_kind = "StorageV2"
is_hns_enabled = "true"
}
output "altodatalake_name" {
value = azurerm_storage_account.telemetrystoragedl.name
}
output "altodatalake_key" {
value = azurerm_storage_account.telemetrystoragedl.primary_access_key
sensitive = true
}
resource "azurerm_storage_data_lake_gen2_filesystem" "telemetryfilesystem" {
name = "telemetryfilesystem"
storage_account_id = azurerm_storage_account.telemetrystoragedl.id
}
output "altodatalake_filesystem" {
value = azurerm_storage_data_lake_gen2_filesystem.telemetryfilesystem.name
}
resource "azurerm_storage_data_lake_gen2_path" "livetelemetry" {
path = "livetelemetry"
filesystem_name = azurerm_storage_data_lake_gen2_filesystem.telemetryfilesystem.name
storage_account_id = azurerm_storage_account.telemetrystoragedl.id
resource = "directory"
}
resource "azurerm_storage_data_lake_gen2_path" "processedtelemetry" {
path = "processedtelemetry"
filesystem_name = azurerm_storage_data_lake_gen2_filesystem.telemetryfilesystem.name
storage_account_id = azurerm_storage_account.telemetrystoragedl.id
resource = "directory"
}
resource "azurerm_synapse_workspace" "synapseworkspace" {
name = "${var.rg-name}synapseworkspace"
resource_group_name = azurerm_resource_group.altoterraformgroup.name
location = azurerm_resource_group.altoterraformgroup.location
storage_data_lake_gen2_filesystem_id = azurerm_storage_data_lake_gen2_filesystem.telemetryfilesystem.id
sql_administrator_login = "sqladminuser"
sql_administrator_login_password = data.azurerm_key_vault_secret.synapsesqlpassword.value
tags = var.default_tags
identity {
type = "SystemAssigned"
}
}
data "azuread_user" "user" {
user_principal_name = "example@email.com"
}
data "azurerm_client_config" "current" {}
resource "azurerm_synapse_workspace_sql_aad_admin" "adduser" {
synapse_workspace_id = azurerm_synapse_workspace.synapseworkspace.id
login = "AzureAD Admin"
object_id = data.azuread_user.user.object_id
tenant_id = data.azurerm_client_config.current.tenant_id
}
resource "azurerm_synapse_sql_pool" "sqlpool" {
name = "${var.rg-name}sqlpool"
synapse_workspace_id = azurerm_synapse_workspace.synapseworkspace.id
sku_name = "DW100c"
create_mode = "Default"
tags = var.default_tags
}