dbt-sqlserver

dbt-sqlserver copied to clipboard

upgrade to support dbt-core v1.2.0

1

We've just published the release cut of dbt-core 1.2.0, `dbt-core 1.2.0rc1` ([PyPI](https://pypi.org/project/dbt-core/1.2.0rc1/) | [GitHub release notes](https://github.com/dbt-labs/dbt-core/releases/tag/v1.2.0rc1)). https://github.com/dbt-labs/dbt-core/discussions/5468 is an open discussion with more detailed information, and https://github.com/dbt-labs/dbt-core/issues/5474 is for keeping...

dataders

dbt test runs into internal error

2

When excecuting dbt test on the dbt-sqlserver adapter, the dbt test command runs into an error: dbt internally failed to execute test.temp.not_null_my_first_dbt_model_id.5fb22c2710: Returned 0 rows, but expected 1 row. This...

SvenRelijveld1995

updates the create schema statement

3

Adds authorization based on the create schema syntax defined by Microsoft. https://docs.microsoft.com/en-us/sql/t-sql/statements/create-schema-transact-sql?view=sql-server-ver15#remarks resolves: #153

vigyuv

Bumps [dbt-tests-adapter](https://github.com/dbt-labs/dbt-tests-adapter) from 1.1.1 to 1.2.1. Commits See full diff in compare view [](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores) Dependabot will resolve any conflicts with this PR as long as you don't alter...

dependabot[bot]

Retry model on connection errors

15

Hey Guys, Is it possible to implement re-trying of queries if the query fails due to non-model related errors? For example, sometimes Azure SQL fails with errors like this: ```...

infused-kim

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

baldwicc

Bumps [docker/build-push-action](https://github.com/docker/build-push-action) from 3.0.0 to 3.1.1. Release notes Sourced from docker/build-push-action's releases. v3.1.1 Fix GitHub token not passed with Git context if subdir defined by @​crazy-max (#663) Replace deprecated fs.rmdir...

dependabot[bot]

updates: - [github.com/adrienverge/yamllint: v1.26.3 → v1.27.1](https://github.com/adrienverge/yamllint/compare/v1.26.3...v1.27.1) - [github.com/hadialqattan/pycln: v1.3.5 → v2.1.1](https://github.com/hadialqattan/pycln/compare/v1.3.5...v2.1.1) - [github.com/pre-commit/mirrors-mypy: v0.961 → v0.971](https://github.com/pre-commit/mirrors-mypy/compare/v0.961...v0.971)

pre-commit-ci[bot]

Encrypt=No seems to be required in connection string

1

Hello, I am trying to run `dbt debug` on a MS SQL server that I have few information about. Here is the Dbt profile I use (host and password hidden):...

nsaintgeours

add TrustServerCertificate to Windows login

1

`ODBC Driver 18 for SQL Server` gives the following database error when compiling and needs this in the connection string. Tested locally with both Drivers 17 and 18. Database Error...

bsalerno