# Synapse SQL Pool Connection string

**URL:** <https://discuss.hashicorp.com/t/synapse-sql-pool-connection-string/44598>\
**Category:** Azure\
**Created:** [September 21, 2022, 5:00pm UTC](https://discuss.hashicorp.com/t/synapse-sql-pool-connection-string/44598 "2022-09-21T17:00:44Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jimbrew](https://sea2.discourse-cdn.com/hashicorp/user_avatar/discuss.hashicorp.com/jimbrew/32/30872_2.png) [@jimbrew](https://discuss.hashicorp.com/u/jimbrew)\
**Post date:** [September 21, 2022, 5:00pm UTC](https://discuss.hashicorp.com/t/synapse-sql-pool-connection-string/44598/1 "2022-09-21T17:00:44Z")

</div>

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`

```auto
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
}

```