# Connect Microsoft Azure Synapse Analytics to dbt Core

Local development

info

The following is a guide to using Azure Synapse Analytics dedicated SQL pools (formerly SQL DW). For more info, refer to [What is dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics?](https://learn.microsoft.com/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is) for more info.

For Microsoft Fabric setup with dbt, refer to [Microsoft Fabric Data Warehouse](./fabric-setup.md).

* **Maintained by**: Microsoft
* **Authors**: Microsoft (https\://github.com/Microsoft)
* **GitHub repo**: [Microsoft/dbt-synapse](https://github.com/Microsoft/dbt-synapse) [![](https://img.shields.io/github/stars/Microsoft/dbt-synapse?style=for-the-badge)](https://github.com/Microsoft/dbt-synapse)
* **PyPI package**: `dbt-synapse` [![](https://badge.fury.io/py/dbt-synapse.svg)](https://badge.fury.io/py/dbt-synapse)
* **Slack channel**: [#db-synapse](https://getdbt.slack.com/archives/C01DRQ178LQ)
* **Supported dbt Core version**: v0.18.0 and newer
* **dbt support**: Supported
* **Minimum data platform version**: Azure Synapse 10

## Installing dbt-synapse

Use `pip` to install the adapter. Use the following command for installation:

`python -m pip install dbt-synapse`

## Configuring dbt-synapse

For Synapse-specific configuration, please refer to [Synapse configs.](../../../reference/resource-configs/azuresynapse-configs.md)

Dedicated SQL only

Azure Synapse Analytics offers both dedicated SQL pools and serverless SQL pools. \*\*Only Dedicated SQL Pools are supported by this adapter.

### Prerequisites

On Debian/Ubuntu make sure you have the ODBC header files before installing

```bash
sudo apt install unixodbc-dev
```

Download and install the [Microsoft ODBC Driver 18 for SQL Server](https://docs.microsoft.com/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15). If you already have ODBC Driver 17 installed, then that one will work as well.

Default settings change in dbt-synapse v1.2 / ODBC Driver 18

Microsoft made several changes related to connection encryption. Read more about the changes [here](./mssql-setup.md).

### Authentication methods

This adapter is based on the adapter for Microsoft SQL Server. Therefore, the same authentication methods are supported.

The configuration is the same except for 1 major difference: instead of specifying `type: sqlserver`, you specify `type: synapse`.

Example:

profiles.yml

```yaml
your_profile_name:
  target: dev
  outputs:
    dev:
      type: synapse
      driver: 'ODBC Driver 17 for SQL Server' # (The ODBC Driver installed on your system)
      server: workspacename.sql.azuresynapse.net # (Dedicated SQL endpoint of your workspace here)
      port: 1433
      database: exampledb
      schema: schema_name
      user: username
      password: password
```

You can find all the available options and the documentation and how to configure them on [the documentation page for the dbt-sqlserver adapter](./mssql-setup.md).

## Was this page helpful?

YesNo

[Privacy policy](https://www.getdbt.com/cloud/privacy-policy)[Create a GitHub issue](https://github.com/dbt-labs/docs.getdbt.com/issues)

This site is protected by reCAPTCHA and the Google [Privacy Policy](https://policies.google.com/privacy) and [Terms of Service](https://policies.google.com/terms) apply.