---
title: "About Azure Synapse prerequisites"
slug: "about-azure-synapse-prerequisites"
description: "Learn what details you need in your Azure Synapse instance to connect with Supermetrics."
updated: 2025-06-26T12:45:23Z
published: 2025-06-26T12:45:23Z
canonical: "docs.supermetrics.com/about-azure-synapse-prerequisites"
---

> ## 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.

# About Azure Synapse prerequisites

To start using Azure Synapse as a Supermetrics destination, some requirements need to be met. These prerequisites ensure that a working connection can be set up to successfully transfer data to your Azure Synapse SQL pool.

> [!NOTE]
> About permissions
> 
> You may need specific permissions to verify these prerequisites are met. If you are unable to access some information, please contact your Azure admin.

## Prerequisites

### SQL pool

You need to have set up a [dedicated SQL pool](https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-dedicated-sql-pool) before you can use it as a destination. If you want to use the data within the SQL pool in a Synapse workspace, it should ideally also be set up before creating a data transfer with Supermetrics.

### Roles and permissions

The role Synapse User — or any role above it — and SQL permissions for the SQL pool you want to use are required. See Azure Synapse documentation for more information about [RBAC roles](https://docs.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-understand-what-role-you-need) and [access control](https://docs.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-access-control-overview#access-control-enforcement-in-synapse-studio).

### IP allowlisting

If your Synapse workspace only allows access from selected networks, IP allowlisting is needed. See Azure Synapse documentation for more information about [managing IP firewall rules](https://docs.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-ip-firewall).

Grant access to [these Supermetrics IP addresses](/v1/docs/about-ip-address-allowlisting-for-data-warehouse-destinations) under **Settings** → **Firewall** of your SQL server, SQL pool, and/or Synapse workspace. Don't forget to add your own IP address to avoid losing access to your server, pool, and/or workspace.

## More resources

- [How to configure an Azure Synapse destination](/v1/docs/how-to-configure-an-azure-synapse-destination)
- [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)