Dbt-dremio

Features

Fixes

Under the Hood
- [179](https://github.com/dremio/dbt-dremio/issues/179) Upgrade to support dbt-core v1.5.0.
- Add support for Python 3.11.
- Add support for relevant Tests:
- caching
- hooks
- simple_copy
- Add support for model contracts (Stub the feature to let users know the feature is not supported).

Dependency

- Upgrade sqlparse to 0.4.4 [180](https://github.com/dremio/dbt-dremio/issues/180).
- Upgrade dbt-core to 1.5.0.
- Upgrade dbt-tests-adapter to 1.5.0.
- Upgrade Requests to 2.31.0. [183](https://github.com/dremio/dbt-dremio/issues/183).

Features

Fixes

- [142](https://github.com/dremio/dbt-dremio/issues/142) Ensure ssl verification is enabled in all api calls. Also added an option called `verify_ssl` so it can be disabled in necessary circumstances.

Under the Hood

- [64](https://github.com/dremio/dbt-dremio/issues/64) Add BaseArrayTests and throw exceptions for unsupported Array Macros.
- [117](https://github.com/dremio/dbt-dremio/issues/117) Add support for Query Comment Tests and Python 3.11
- [134](https://github.com/dremio/dbt-dremio/issues/134) Add dremio:exact_search_enabled variable that if set to true, replaces usage of ilike with a basic equality in dremio\_\_list_relations_without_caching when reflections are not enabled.
- [117](https://github.com/dremio/dbt-dremio/issues/117) Add Base Current Timestamps Tests
- [117](https://github.com/dremio/dbt-dremio/issues/117) Replace deprecated dbt-core exceptions
- [117](https://github.com/dremio/dbt-dremio/issues/117) Add support for changing relation type test

Dependency

- Upgrade dbt-core to 1.4.5.
- Upgrade dbt-tests-adapter to 1.4.5.

Features

Fixes

- Override dbt-core `default__type_string()` macro to use Dremio Supported VARCHAR instead of the default string. ([80](https://github.com/dremio/dbt-dremio/pull/80))

- Change \_populate_job_results() to have an optional row_limit argument with default set to 100 (Dremio's default). ([61](https://github.com/dremio/dbt-dremio/issues/61))

- Implement pagination in \_populate_job_results() ([61](https://github.com/dremio/dbt-dremio/issues/61))

- Fix error handling so the error reported when a job fails is the actual error from Dremio. ([69](https://github.com/dremio/dbt-dremio/issues/69))

- Override dbt-core `default__rename_relation()` macro to use Dremio Supported CTAS and DROP instead of ALTER TABLE and RENAME to. ([44](https://github.com/dremio/dbt-dremio/issues/44))

Under the Hood

- [32](https://github.com/dremio/dbt-dremio/issues/32) Add pre-commit hooks (most significant being `black`, `flake8`, and `bandit`)

- Implement new Incremental materialization logic from dbt 1.3 as part of the upgrade to support dbt-core v1.3.0. ([44](https://github.com/dremio/dbt-dremio/issues/44), [#16](https://github.com/dremio/dbt-dremio/issues/16))

Dependency

- Upgrade dbt-core to 1.3.2.

- Upgrade dbt-tests-adapter to 1.3.2.