sqlserver-cli.mdx

SQL Server connection profile

After installing Elementary's dbt package upon running dbt deps, you can generate Elementary's profile for usage with edr by running the following command within your project:

dbt run-operation elementary.generate_elementary_cli_profile

The command will print to the terminal a partially filled template of the profile that's needed for edr to work.

## SQL SERVER ##
## By default, edr expects the profile name 'elementary'.      ##
## Configure the database and schema of elementary models.     ##
## Check where 'elementary_test_results' is to find it.        ##

elementary:
  outputs:
    default:
      type: sqlserver
      driver: ODBC Driver 18 for SQL Server
      server: [hostname]
      port: 1433
      database: [database name]
      schema: [schema name] # elementary schema, usually [schema name]_elementary
      user: [username]
      password: [password]
      threads: [1 or more]
      # encrypt: true # default true in dbt-sqlserver >= 1.2.0
      # trust_cert: false

We support the same format and connection methods as dbt. Please refer to dbt's documentation of SQL Server profile for further details.