Impala adapter for DBT
Project description
dbt-impala
The dbt-impala adapter allows you to use dbt along with Apache Impala and Cloudera Data Platform
Getting started
- Install dbt
- Read the introduction and viewpoint
- For using
dbt-impalaadapter against Apache Kudu, please follow Kudu Integration guidelines.
Requirements
Current version of dbt-impala uses dbt-core 1.9.*. We are actively working on supporting the next available version of dbt-core.
Python >= 3.9 dbt-core == 1.9.*
For development/testing or contribution to the dbt-impala, please follow Contributing guidelines.
Installing dbt-impala
pip install dbt-impala
Profile Setup
demo_project:
target: dev
outputs:
dev:
type: impala
host: impala-coordinator.my.org.com
port: 443
dbname: my_db
schema: my_db
user: my_user
password: my_pass
auth_type: ldap
http_path: cliservice
Supported features
| Name | Supported | Iceberg | Kudu |
|---|---|---|---|
| Materialization: View | Yes | N/A | N/A |
| Materialization: Table | Yes | Yes | Yes |
| Materialization: Table with Partitions | Yes | Yes | Yes |
| Materialization: Incremental - Append | Yes | Yes | Yes |
| Materialization: Incremental - Append with Partitions | Yes | Yes | No |
| Materialization: Incremental - Insert+Overwrite | Yes | Yes | No |
| Materialization: Incremental - Insert+Overwrite with Partition | Yes | Yes | No |
| Materialization: Incremental - Merge | No | No | No |
| Materialization: Ephemeral | Yes | Yes | No |
| Seeds | Yes | Yes | Yes |
| Tests | Yes | Yes | Yes |
| Snapshots | No | No | No |
| Documentation | Yes | Yes | Yes |
| Authentication: LDAP | Yes | Yes | Yes |
| Authentication: Kerberos | Yes | No | No |
Tests Coverage
Functional Tests
| Name | Base | Iceberg | Kudu |
|---|---|---|---|
| Materialization: View | Yes | N/A | N/A |
| Materialization: Table | Yes | Yes | Yes |
| Materialization: Table with Partitions | Yes | Yes | Yes |
| Materialization: Incremental - Append | Yes | Yes | Yes |
| Materialization: Incremental - Append with Partitions | Yes | Yes | No |
| Materialization: Incremental - Insert+Overwrite | Yes | No | No |
| Materialization: Incremental - Insert+Overwrite with Partition | Yes | Yes | No |
| Materialization: Ephemeral | Yes | Yes | No |
| Seeds | Yes | Yes | Yes |
| Tests | Yes | Yes | Yes |
| Snapshots | No | No | No |
| Documentation | Yes | Yes | Yes |
| Authentication: LDAP | Yes | Yes | Yes |
| Authentication: Kerberos | No | No | No |
