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, which automatically installs dbt-core
and any additional dependencies. Use the following command for installation:
python -m pip install dbt-exasol
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 defaultsocket_timeout
— defaults to pyexasol defaultquery_timeout
— defaults to pyexasol defaultcompression
— default: Falseencryption
— default: Falseprotocol_version
— default: v3row_separator
— default: CRLF for windows - LF otherwisetimestamp_format
— default:YYYY-MM-DDTHH:MI:SS.FF6
0