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-exasolConnecting 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