Skip to content

Commit

Permalink
Replaced boilerplace/wrong copypasta
Browse files Browse the repository at this point in the history
  • Loading branch information
mattberns authored Sep 17, 2020
1 parent ad0b2ce commit b0a2d2b
Showing 1 changed file with 4 additions and 42 deletions.
46 changes: 4 additions & 42 deletions website/docs/reference/warehouse-profiles/azuresynapse-profile.md
Original file line number Diff line number Diff line change
Expand Up @@ -9,12 +9,14 @@ This is a Community Contributed plugin for dbt. If you're interested in contribu

:::

## Overview of dbt-sqlserver
## Overview of dbt-azuresynapse
**Status:** Community Contributed

**Author:** Ernesto Barajas and Matt Berns

**Source Code:** https://github.com/embold-health/dbt-azuresynapse

**dbt-sqlserver**
**dbt-azuresynapse**
Only supports dbt 0.17 and newer!

Easiest install is to use pip:
Expand Down Expand Up @@ -49,43 +51,3 @@ dbt-azuresynapse:
authentication: SqlPassword
schema: [schema]
```
------------------------------------------------------------
## Overview of dbt-azuresynapse
**Status:** Community Contributed
**Author:** Ernesto Barajas and Matt Berns
**Source Code:** https://github.com/embold-health/dbt-azuresynapse
**dbt-azuresynapse** is a custom adapter for dbt that adds support for Azure Synapse 10 and later. `pyodbc` is used as the connection driver as that is what is [suggested by Microsoft](https://docs.microsoft.com/en-us/sql/connect/python/python-driver-for-sql-server).

dbt-azuresynapse is currently in a beta release. It is passing all of the [dbt integration tests](https://github.com/fishtown-analytics/dbt-integration-tests/) on Azure Synapse DW 10.

### Connecting to SQL Server with **dbt-azuresynapse**

#### User / password authentication

A connection can be configured using basic user/password authentication as shown below.

<File name='profiles.yml'>

```yaml
dbt-azuresynapse:
target: dev
outputs:
dev:
type: sqlserver
driver: 'ODBC Driver 17 for SQL Server' (The ODBC Driver installed on your system)
server: server-host-name or ip
port: 1433
user: [username]
password: [password]
database: [databasename]
authentication: SqlPassword
schema: [schema]
```

</File>

0 comments on commit b0a2d2b

Please sign in to comment.