Skip to main content

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.

  • 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

Use pip to install the adapter. Before 1.8, installing the adapter would automatically install dbt-core and any additional dependencies. Beginning in 1.8, installing an adapter does not automatically install dbt-core. This is because adapters and dbt Core versions have been decoupled from each other so we no longer want to overwrite existing dbt-core installations. Use the following command for installation:

Configuring dbt-exasol

For Exasol-specific configuration, please refer to Exasol configs.

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

0