# Microsoft Azure Synapse DWH configurations

All [configuration options for the Microsoft SQL Server adapter](./mssql-configs.md) also apply to this adapter.

Additionally, the configuration options below are available.

### Indices and distributions

The main index and the distribution type can be set for models that are materialized to tables.

### Model config

models/example.sql

```sql
{{
    config(
        index='HEAP',
        dist='ROUND_ROBIN'
        )
}}

select *
from ...
```

### Project config

dbt\_project.yml

```yaml
models:
  your_project_name:
    materialized: view
    staging:
      materialized: table
      index: HEAP
```

The following are the supported index types:

* `CLUSTERED COLUMNSTORE INDEX` (default)
* `HEAP`
* `CLUSTERED INDEX (COLUMN_NAME)`
* `CLUSTERED COLUMNSTORE INDEX ORDER(COLUMN_NAME)`

The following are the supported distribution types:

* `ROUND_ROBIN` (default)
* `HASH(COLUMN_NAME)`
* `REPLICATE`

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