---
title: "How to configure an Azure Synapse destination"
slug: "how-to-configure-an-azure-synapse-destination"
description: "Learn how to configure Azure Synapse as a destination in Supermetrics Hub, including hostname, database name, and user permissions."
updated: 2025-07-04T08:20:48Z
published: 2025-07-04T08:20:48Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to configure an Azure Synapse destination

When you create a Azure Synapse destination in the Supermetrics Hub, the configuration requires details that can be obtained from the Azure portal.

## Before you begin

Before you create an Azure Synapse destination, please make sure all prerequisites are met. Learn more about the [prerequisites for creating an Azure Synapse destination](/v1/docs/about-azure-synapse-prerequisites).

> [!NOTE]
> About permissions
> 
> You may need specific permissions to access the details needed in the configuration. If you are unable to access some information, please contact your Azure admin.

## Azure Synapse configuration

The configuration stage of [creating a new destination](/v1/docs/how-to-connect-to-a-data-warehouse-destination) in the Supermetrics Hub includes the following fields.

1. **Display name** will be used as the name of this destination within the Supermetrics Hub, to distinguish it from other destinations.
2. **Hostname** refers to the **Server name** of the dedicated SQL pool you want to use as a destination. Find your hostname from the [Azure portal](https://portal.azure.com/#home) under the **Essentials** information of your SQL pool overview. The hostname has a format such as `my-company.database.windows.net`.
3. **Database name** refers to the name of the dedicated SQL pool you want to use as a destination.
4. **Database schema** refers to the name of the destination database schema. You can create your own schema or use the default schema called “dbo” provided by Azure Synapse. See Azure documentation to learn more about [Synapse schemas](https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-user-defined-schemas).
5. **Username** of your Synapse user account.
6. **Password** of your Synapse user account.

## More resources

- [About Azure Synapse prerequisites](/v1/docs/about-azure-synapse-prerequisites)
- [How to create a destination](/v1/docs/how-to-connect-to-a-data-warehouse-destination)
- [How to create a transfer](/v1/docs/how-to-create-a-transfer)