Chris Baldwin comments

Results 7 comments of


                                            Chris Baldwin

fix: adds pyodbc output converter for DATETIMEOFFSET

Done - saw this has v1.1.1 milestone so updated changelog.md accordingly

Cannot use `dbt source freshness` with DATETIMEOFFSET column types

A much simpler and less invasive solution to this specific issue would be to cast the issue away as per [freshness#loaded_at_field](https://docs.getdbt.com/reference/resource-properties/freshness#loaded_at_field) in the docs e.g. ````yaml loaded_at_field: CAST(updated_datetimeoffset_at AS datetime)...

Multi-platform build failing due to outdated skopeo in ubuntu-latest

FWIW, I'm getting the same `docker tag` failure with the [Azure DevOps task example](https://github.com/devcontainers/ci/blob/main/docs/multi-platform-builds.md#azure-devops-task-example)

including database name in relation causes issue w/ SSDT

+1 on disabling three-part names by default. If a statement includes references to objects that don't exist, Synapse will respond with "USE is not supported on this platform" instead of...

create_view_as - Show contracts warning only when contract_config.enf…

@prdpsvs let me know if you need anything else for this PR

Query Preview ignoring template setting

Upstream cause: https://github.com/microsoft/dbt-synapse/pull/235 A quick local workaround is to create a `macros/get_limit_subquery_sql.sql` macro with the following: ```sql {# Synapse doesnt support ANSI LIMIT clause - instead set rowcount for the...

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

In our local projects we've just overridden this by lifting the [`alter_column_type`](https://github.com/dbt-msft/dbt-sqlserver/blob/f789ab0815b926bd68af6e901cd0e33b2895db3f/dbt/include/sqlserver/macros/adapters/columns.sql#L1-L18) macro from dbt-msft/dbt-sqlserver as we update to v1.7.x, as Synapse does support ALTER TABLE and sp_rename for columns:...