Chris Baldwin

fix: adds pyodbc output converter for DATETIMEOFFSET

2

Fixes #253 Refs: https://github.com/mkleehammer/pyodbc/wiki/Using-an-Output-Converter-function https://github.com/mkleehammer/pyodbc/issues/134#issuecomment-281739794

Cannot use `dbt source freshness` with DATETIMEOFFSET column types

1

Running into issues with [`dbt source freshness`](https://docs.getdbt.com/reference/resource-properties/freshness) pointing at DATETIMEOFFSET columns, with pyodbc throwing the following error: ```` ODBC data type -155 is not supported. ```` Directly relates to https://github.com/mkleehammer/pyodbc/issues/134

Added links to [dbt-labs/dbt-utils](/dbt-labs/dbt-utils)'s README, so visitors can jump between checking compatibility & viewing usage examples.

**Describe the bug** On a fresh macOS 13.4 user profile with no `~/.ssh` folder, installing and running `gh net` appears to create the following files owned by `root:staff` rather than...

create_view_as - Show contracts warning only when contract_config.enf…

1

The `Model contracts cannot be enforced` warning should only be logged if `contract_config.enforced` is set. This change mimics the behavour that exists in [create_table_as.sql#L17](https://github.com/microsoft/dbt-synapse/blob/7d414cd122c91d3b45dd4e158afd82152c9695ff/dbt/include/synapse/macros/materializations/models/table/create_table_as.sql#L17) and follows guidance from the v1.5...

`'tmp_relation' is undefined` when altering a column's datatype on an incremental model

1

We're seeing error messages in v1.7.3 when the datatype of a column is altered (but the column name remains the same). ``` 04:07:16 Running with dbt=1.7.15 04:07:16 Registered adapter: synapse=1.7.3...

Missing dry-run support (`--empty`)

1

## Issue Summary `dbt build model_name --empty` executes `select * from schema.model_name where false limit 0` statements. These aren't valid in Synapse/T-SQL and return `Incorrect syntax near 'limit'.` errors. ##...