The Teradata adapter plugin for dbt (data build tool)
Project description
dbt-teradata
This plugin ports dbt functionality to Teradata Vantage.
Sample profile
Here is a working example of a dbt-teradata
profile:
my-teradata-db-profile:
target: dev
outputs:
dev:
type: teradata
host: localhost
user: dbc
password: dbc
schema: dbt_test
tmode: ANSI
At a minimum, you need to specify host
, user
, password
, schema
(database), tmode
.
Optional configurations
Logmech
The logon mechanism for Teradata jobs that dbt executes can be configured with the logmech
configuration in your Teradata profile. The logmech
field can be set to: TD2
, LDAP
, KRB5
, TDNEGO
. For more information on authentication options, go to Teradata Vantage authentication documentation.
my-teradata-db-profile:
target: dev
outputs:
dev:
type: teradata
host: <host>
user: <user>
password: <password>
schema: dbt_test
tmode: ANSI
logmech: LDAP
Port
If your Teradata database runs on port different than the default (1025), you can specify a custom port in your dbt profile using port
configuration.
my-teradata-db-profile:
target: dev
outputs:
dev:
type: teradata
host: <host>
user: <user>
password: <password>
schema: dbt_test
tmode: ANSI
port: <port>
Other Teradata connection parameters
The plugin also supports the following Teradata connection parameters:
- account
- column_name
- cop
- coplast
- encryptdata
- fake_result_sets
- field_quote
- field_sep
- lob_support
- log
- logdata
- max_message_body
- partition
- sip_support
- teradata_values
For full description of the connection parameters see https://github.com/Teradata/python-driver#connection-parameters.
Supported Features
Materializations
view
table
ephemeral
incremental
Commands
All dbt commands are supported.
Custom configurations
Seeds
use_fastload
configuration will instruct the plugin to use fastload when handlingdbt seed
command. You can set this seed configuration option in yourproject.yml
file, e.g.:seeds: <project-name>: +use_fastload: true
Limitations
Transaction mode
Only ANSI transaction mode is supported.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for dbt_teradata-0.19.0.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c7af9df5e2923ca0baf0fe2da228505522de3792dab10a1f94cdf5a0834601e9 |
|
MD5 | a8db8b885d4d023df7a5bd98e1ef4c9b |
|
BLAKE2b-256 | 4ec4eca091ff13ecaadf24f691d137431cc506154980dc545222eaa40d5fcf61 |