Dbt-dremio

Changes
- [8307](https://github.com/dbt-labs/dbt-core/discussions/8307) Allow source freshness to be evaluated from table metadata
- [8307](https://github.com/dbt-labs/dbt-core/discussions/8307) Catalog fetch performance improvements
- [8307](https://github.com/dbt-labs/dbt-core/discussions/8307) Migrate data_spine macros
- [195](https://github.com/dremio/dbt-dremio/issues/195) Ensure api call to create folders does not get called when creating a table
- [220](https://github.com/dremio/dbt-dremio/pull/220) Optimize networking performance with Dremio server

Changes

- [199](https://github.com/dremio/dbt-dremio/issues/199) Populate PyPI's `long_description` with contents of `README.md`
- [167](https://github.com/dremio/dbt-dremio/issues/167) Remove parentheses surrounding views in the create_view_as macro. In more complex queries, the parentheses cause performance issues.
- [211](https://github.com/dremio/dbt-dremio/issues/211) Make fetching model data false by default. This improves performance where job results do not need to be populated.
- [203](https://github.com/dremio/dbt-dremio/issues/203) Allow for dots in schema name, by surrounding in single and double quotes.
- [193](https://github.com/dremio/dbt-dremio/issues/193) Fixes Reflection bug: The name argument to ref() must be a string, got <class 'jinja2.runtime.Undefined'>
- [Versioning](https://github.com/dremio/dbt-dremio/pull/210) Added optional parameter v to the ref macro

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.