Exasol setup

Community plugin

Some core functionality may be limited. If you're interested in contributing, check out the source code for each repository listed below.

Overview of dbt-exasol

• Maintained by: Community
• Authors: Torsten Glunde, Ilija Kutle
• GitHub repo: tglunde/dbt-exasol
• PyPI package: dbt-exasol
• Slack channel: n/a
• Supported dbt Core version: v0.14.0 and newer
• dbt Cloud support: Not Supported
• Minimum data platform version: Exasol 6.x

Installing dbt-exasol

pip is the easiest way to install the adapter:

pip install dbt-exasol

Installing dbt-exasol will also install dbt-core and any other dependencies.

Configuring dbt-exasol

For Exasol-specifc configuration please refer to Exasol Configuration

For further info, refer to the GitHub repository: tglunde/dbt-exasol

dbt-exasol

Connecting to Exasol with dbt-exasol

User / password authentication

Configure your dbt profile for using Exasol:

Exasol connection information

profiles.yml

dbt-exasol:
  target: dev
  outputs:
    dev:
      type: exasol
      threads: 1
      dsn: HOST:PORT
      user: USERNAME
      password: PASSWORD
      dbname: db
      schema: SCHEMA

Optional parameters

• connection_timeout — defaults to pyexasol default
• socket_timeout — defaults to pyexasol default
• query_timeout — defaults to pyexasol default
• compression — default: False
• encryption — default: False
• protocol_version — default: v3
• row_separator — default: CRLF for windows - LF otherwise
• timestamp_format — default: YYYY-MM-DDTHH:MI:SS.FF6