Raw JSON report machine-readable
{
"data": {
"repo": {
"topics": [
"dbt-sqlserver",
"sql-server",
"azure-sql",
"azure-sql-db",
"transact-sql",
"tsql",
"microsoft",
"microsoft-sql-server",
"dbt",
"mssql",
"t-sql",
"data-engineering",
"analytics-engineering",
"sql"
],
"is_fork": false,
"size_kb": 2087,
"has_wiki": false,
"homepage": null,
"languages": {
"TSQL": 43350,
"Shell": 3194,
"Python": 647378,
"Makefile": 1988,
"Dockerfile": 2387
},
"pushed_at": "2026-07-27T04:16:43Z",
"created_at": "2019-06-25T20:14:56Z",
"owner_type": "Organization",
"updated_at": "2026-07-27T03:52:41Z",
"description": "dbt adapter for SQL Server and Azure SQL",
"is_archived": false,
"is_disabled": false,
"license_spdx": "MIT",
"default_branch": "master",
"license_spdx_raw": "MIT",
"primary_language": "Python",
"significant_languages": [
"Python"
]
},
"owner": {
"blog": null,
"name": "dbt + MSFT SQL",
"type": "Organization",
"login": "dbt-msft",
"company": null,
"location": null,
"followers": 47,
"avatar_url": "https://avatars.githubusercontent.com/u/73860967?v=4",
"created_at": "2020-11-03T00:36:58Z",
"is_verified": null,
"public_repos": 9,
"account_age_days": 2092
},
"license": {
"state": "standard",
"spdx_id": "MIT",
"raw_spdx": "MIT",
"file_present": true,
"scorecard_found": true,
"profile_has_license": true
},
"activity": {
"releases": [
{
"tag": "v1.11.0rc1",
"kind": "other",
"published_at": "2026-07-27T04:16:44Z"
},
{
"tag": "v1.10.1",
"kind": "patch",
"published_at": "2026-07-23T04:01:19Z"
},
{
"tag": "v1.10.1rc2",
"kind": "other",
"published_at": "2026-07-15T22:52:38Z"
},
{
"tag": "v1.10.1rc1",
"kind": "other",
"published_at": "2026-06-25T02:50:28Z"
},
{
"tag": "v1.10.0",
"kind": "minor",
"published_at": "2026-06-10T01:52:08Z"
},
{
"tag": "v1.10.0rc1",
"kind": "other",
"published_at": "2026-06-04T08:23:59Z"
},
{
"tag": "v1.9.2",
"kind": "patch",
"published_at": "2026-05-27T20:52:41Z"
},
{
"tag": "v1.9.1",
"kind": "patch",
"published_at": "2026-05-19T13:27:12Z"
},
{
"tag": "v1.9.1rc1",
"kind": "other",
"published_at": "2026-05-14T09:32:51Z"
},
{
"tag": "v1.9.0",
"kind": "minor",
"published_at": "2025-06-02T16:02:17Z"
},
{
"tag": "v1.8.7",
"kind": "patch",
"published_at": "2025-01-21T18:36:53Z"
},
{
"tag": "v1.8.6",
"kind": "patch",
"published_at": "2025-01-17T17:47:53Z"
},
{
"tag": "v1.8.5",
"kind": "patch",
"published_at": "2024-12-02T17:16:29Z"
},
{
"tag": "v1.8.4",
"kind": "patch",
"published_at": "2024-09-18T01:02:37Z"
},
{
"tag": "v1.8.3",
"kind": "patch",
"published_at": "2024-09-17T00:47:53Z"
},
{
"tag": "v1.8.2",
"kind": "patch",
"published_at": "2024-09-14T19:06:18Z"
},
{
"tag": "v1.8.1",
"kind": "patch",
"published_at": "2024-09-12T18:00:05Z"
},
{
"tag": "v1.8.0",
"kind": "minor",
"published_at": "2024-09-09T17:59:54Z"
},
{
"tag": "v1.8.0rc2",
"kind": "other",
"published_at": "2024-09-03T17:30:23Z"
},
{
"tag": "v1.8.0rc1",
"kind": "other",
"published_at": "2024-08-23T00:52:04Z"
},
{
"tag": "v1.7.4",
"kind": "patch",
"published_at": "2024-03-04T14:45:56Z"
},
{
"tag": "v1.7.3",
"kind": "patch",
"published_at": "2024-02-28T08:59:30Z"
},
{
"tag": "v1.7.2",
"kind": "patch",
"published_at": "2024-02-12T20:32:53Z"
},
{
"tag": "v1.7.2rc1",
"kind": "other",
"published_at": "2024-01-25T20:22:19Z"
},
{
"tag": "v1.4.3",
"kind": "patch",
"published_at": "2023-05-22T22:25:28Z"
},
{
"tag": "v1.4.2",
"kind": "patch",
"published_at": "2023-05-22T19:13:01Z"
},
{
"tag": "v1.4.1",
"kind": "patch",
"published_at": "2023-05-22T07:57:23Z"
},
{
"tag": "v1.4.0",
"kind": "minor",
"published_at": "2023-05-15T20:47:17Z"
},
{
"tag": "v1.3.2",
"kind": "patch",
"published_at": "2023-05-12T21:02:43Z"
},
{
"tag": "v1.3.1",
"kind": "patch",
"published_at": "2023-02-15T14:46:30Z"
},
{
"tag": "v1.3.0",
"kind": "minor",
"published_at": "2022-10-12T12:01:01Z"
},
{
"tag": "v1.3.0rc1",
"kind": "other",
"published_at": "2022-10-06T19:30:53Z"
},
{
"tag": "v1.2.0",
"kind": "minor",
"published_at": "2022-10-06T07:23:13Z"
},
{
"tag": "v1.2.0rc1",
"kind": "other",
"published_at": "2022-09-19T12:10:13Z"
},
{
"tag": "v1.3.0b1",
"kind": "other",
"published_at": "2022-09-17T12:25:30Z"
},
{
"tag": "v1.2.0b2",
"kind": "other",
"published_at": "2022-09-13T21:01:37Z"
},
{
"tag": "v1.2.0b1",
"kind": "other",
"published_at": "2022-09-12T20:56:45Z"
},
{
"tag": "v1.1.0",
"kind": "minor",
"published_at": "2022-06-09T19:17:23Z"
},
{
"tag": "v1.1.0.rc1",
"kind": "other",
"published_at": "2022-05-30T09:54:54Z"
},
{
"tag": "v1.0.0",
"kind": "major",
"published_at": "2021-12-17T20:04:41Z"
},
{
"tag": "v1.0.0rc2",
"kind": "other",
"published_at": "2021-12-16T02:50:31Z"
},
{
"tag": "v0.21.1",
"kind": "patch",
"published_at": "2021-11-30T22:24:04Z"
},
{
"tag": "v0.21.0",
"kind": "minor",
"published_at": "2021-11-29T22:48:36Z"
},
{
"tag": "v0.21.0rc2",
"kind": "other",
"published_at": "2021-11-11T06:27:45Z"
},
{
"tag": "v0.21.0rc1",
"kind": "other",
"published_at": "2021-11-06T01:07:29Z"
},
{
"tag": "v0.20.1",
"kind": "patch",
"published_at": "2021-09-08T23:37:52Z"
},
{
"tag": "v0.19.3",
"kind": "patch",
"published_at": "2021-09-08T23:34:19Z"
},
{
"tag": "v0.19.3rc1",
"kind": "other",
"published_at": "2021-09-08T20:08:35Z"
},
{
"tag": "0.20.0",
"kind": "minor",
"published_at": "2021-08-12T23:36:40Z"
},
{
"tag": "v0.20.0rc1",
"kind": "other",
"published_at": "2021-07-19T21:05:28Z"
},
{
"tag": "0.19.2",
"kind": "patch",
"published_at": "2021-07-19T18:41:32Z"
},
{
"tag": "0.19.1",
"kind": "patch",
"published_at": "2021-06-13T19:26:06Z"
},
{
"tag": "v0.19.0.2",
"kind": "other",
"published_at": "2021-03-30T13:33:49Z"
},
{
"tag": "v0.19.0.1",
"kind": "other",
"published_at": "2021-02-16T07:59:00Z"
},
{
"tag": "v0.19.0",
"kind": "minor",
"published_at": "2021-02-05T08:25:19Z"
},
{
"tag": "v0.19.0rc2",
"kind": "other",
"published_at": "2021-01-14T18:58:26Z"
},
{
"tag": "v0.19.0rc1",
"kind": "other",
"published_at": "2021-01-14T09:43:27Z"
},
{
"tag": "v0.18.1",
"kind": "patch",
"published_at": "2021-01-11T07:38:30Z"
},
{
"tag": "v0.18.0",
"kind": "minor",
"published_at": "2020-09-15T07:54:39Z"
},
{
"tag": "v0.15.3.1",
"kind": "other",
"published_at": "2020-09-15T07:32:58Z"
},
{
"tag": "v0.15.1",
"kind": "patch",
"published_at": "2020-01-29T10:02:06Z"
},
{
"tag": "v0.15.0",
"kind": "minor",
"published_at": "2019-12-09T19:31:11Z"
},
{
"tag": "v0.14.1",
"kind": "patch",
"published_at": "2019-09-06T06:40:52Z"
},
{
"tag": "v0.14.0",
"kind": "minor",
"published_at": "2019-09-06T06:39:20Z"
},
{
"tag": "v0.1.0",
"kind": "minor",
"published_at": "2019-07-04T21:51:43Z"
}
],
"recent_commits": [
{
"oid": "d36d1bf634ff213eb480cb5e2e4578108f3d818a",
"body": "test: consolidate functional test classes onto shared project fixtures",
"is_bot": false,
"headline": "Merge pull request #767 from axellpadilla/feat/optimize-tests",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-27T03:52:14Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0aa16d0103c91c83210f52b6439fcdcfe9d0d1d6",
"body": "…xtures\n\nContinues the class-merging optimization: query_options, index_config,\ntransactions, and full_refresh_build now share one project/schema per\nfile (or per isolation-requiring group) instead of one per test class,\nsince project setup dominates runtime more than the SQL itself. Also\nrestores t\n[…]\ntable_refresh_method consolidation.\n\nCoverage and assertions are unchanged; classes with project_config_update\nor whole-project result-count assumptions were kept isolated to avoid\ncross-test leakage.",
"is_bot": false,
"headline": "test: consolidate more functional test classes onto shared project fi…",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-27T03:45:06Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "fc2629bfbdaaaa4cd3ad378ec28fd69ff610d53e",
"body": null,
"is_bot": false,
"headline": "Update .gitignore",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-27T03:44:16Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4e3609c372fb060e25dd336122ac6e329190b54b",
"body": null,
"is_bot": false,
"headline": "init",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-27T03:44:16Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e2864bf3294951d68d4df496edeb7b280eb3962a",
"body": "chore: replace black with ruff format",
"is_bot": false,
"headline": "Merge pull request #766 from joshmarkovic/jm/ruff-format",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-27T03:39:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4a0c1078b75cba2989f8675a73411f400ce1fc17",
"body": "…tests\n\nfeat: add UDF function resource support and adapter tests for dbt-core v1.11",
"is_bot": false,
"headline": "Merge pull request #763 from axellpadilla/feat/add-function-resource-…",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-27T02:46:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f5372c6f5f6297539ba11e04da4993d8eb3b8652",
"body": "Adds the previous commit to .git-blame-ignore-revs so the cosmetic\nreformat does not shadow the real authors of those lines. Both\ngit blame --ignore-revs-file and GitHub's blame view honour the file.",
"is_bot": false,
"headline": "chore: ignore the ruff format reformat in git blame",
"author_name": "Josh Markovic",
"author_login": "joshmarkovic",
"committed_at": "2026-07-27T02:39:53Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "54beb6e6e5bd623b5356a939465f3b8367191843",
"body": "Completes the toolchain consolidation started in #707, which moved\nlinting to Ruff. The two black hooks are replaced by ruff-format hooks\nin the existing astral-sh/ruff-pre-commit block, so lint and format\nshare one repo, one version pin, and one [tool.ruff] config block.\n\nNo new configuration: ruff\n[…]\nles. All changes are cosmetic: joined implicit string\nconcatenations that now fit in 99 columns, assert message reflow,\ndecorator argument wrapping, and a blank line after a class header.\n\nCloses #711",
"is_bot": false,
"headline": "chore: replace black with ruff format",
"author_name": "Josh Markovic",
"author_login": "joshmarkovic",
"committed_at": "2026-07-27T02:39:53Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "b1ba99d711d382770e41bf309495f99419ec801a",
"body": "…ult-upstream\n\nfix: apply session-level SET XACT_ABORT ON to all connections",
"is_bot": false,
"headline": "Merge pull request #765 from axellpadilla/fix/xact-abort-session-defa…",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-27T01:50:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f2a3e348c7c742837c437b8e1d0667f0e0fece67",
"body": "Without it, a run-time error partway through a multi-statement batch\n(e.g. the DML table refresh's DELETE+INSERT swap) only aborts the\nfailing statement, not the batch, so a trailing COMMIT can still\npersist a partial result -- most notably an emptied target after the\nDELETE succeeds and the INSERT \n[…]\nnal tests\n run in the same `pytest` invocation. Added an autouse fixture to\n reset it before/after each test.\n- Run functional tests in parallel (-n auto) in CI, matching unit\n tests.\n\nCloses #718.",
"is_bot": false,
"headline": "fix: apply session-level SET XACT_ABORT ON to all connections",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-26T23:26:45Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "727ec57339be38db0265ae329a9c9e53a7cea58a",
"body": null,
"is_bot": false,
"headline": "chore: bump dbt-adapters to >=1.24.1, dbt-tests-adapter to >=1.20.0",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-24T23:15:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ade091a18bed9e2cdccdea6961c0dba6e4cf80ae",
"body": "feat: column-level Dynamic Data Masking (masked_with / masks)",
"is_bot": false,
"headline": "Merge pull request #746 from Benjamin-Knight/feat/dynamic-data-masking",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-24T22:48:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4743654e82d2e6ff6746b9765b77e3af42e2a153",
"body": "…ore-1.11\n\nchore: drop Python 3.10, bump dbt-core to 1.11",
"is_bot": false,
"headline": "Merge pull request #762 from dbt-msft/feat/drop-python-310-bump-dbt-c…",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-24T22:46:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f1db251cb28cc0f2eaba0a818eb873555d15dd07",
"body": "…e v1.11",
"is_bot": false,
"headline": "feat: add UDF function resource support and adapter tests for dbt-cor…",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-24T22:36:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ee338dd98a48f8d62ef78ab174a5d15ad85d141c",
"body": null,
"is_bot": false,
"headline": "chore: bump version to 1.11.0rc1",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-24T21:47:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "280871b679df176c46f1ef9aea73f61e63a19700",
"body": "- Update requires-python to >=3.11\n- Bump dbt-core minimum to 1.11.0\n- Remove Python 3.10 from CI matrices\n- Update default Python to 3.11 in Dockerfile, pre-commit, devcontainer\n- Update ruff/black target-version to py311\n- Update uv.lock (dbt-core 1.11.12)\n\nCloses #758, part of #719",
"is_bot": false,
"headline": "chore: drop Python 3.10 support, bump to dbt-core 1.11",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-24T21:41:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "05acdb10a9b04b449569498bf94f0ac136abe26d",
"body": "feat: full_refresh_build config with prebuilt in-place rebuild path",
"is_bot": false,
"headline": "Merge pull request #750 from Benjamin-Knight/feat/full-refresh-build",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-23T15:13:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "19bb1486123a9355bf18fe7e5cdfa2f5a469c9f5",
"body": "_normalize_function stripped whitespace and case-folded the whole masking\nexpression, including the partial() padding string. But the padding is data:\nSQL Server stores it verbatim (partial(1, \"X X\", 1) keeps the space; \"XxYy\"\nkeeps its case) and only reformats the surrounding syntax. Folding inside\n[…]\nanges are now detected\n(both fail without the fix), and SQL Server's syntactic reformatting plus\nfunction-name case remain no-ops.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "fix: compare DDM partial() padding verbatim, only fold syntax",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-07-23T13:49:47Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "d928f21e133b588ce3aeef0b9670b2aae18bba43",
"body": "The prebuilt full-refresh path had two related defects:\n\n1. The first-build branch (existing_relation is none) issued a bare\n CREATE / SELECT ... INTO with no drop, so a stale relation cache\n (table exists in the DB but absent from the cache, e.g. an orphaned\n concurrent writer created it afte\n[…]\nebuilt create, deterministically reproducing the drift. Verified the\ntests fail without the macro fix (Msg 2714) and pass with it.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "fix: make full_refresh_build=prebuilt cache-safe and idempotent",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-07-23T13:35:10Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "9e3a2e5cc2c95b65de9e732573633d163dcaa67c",
"body": "chore: prepare 1.10.1 release",
"is_bot": false,
"headline": "Merge pull request #755 from dbt-msft/release/1.10.1",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-23T03:58:57Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "505eac7dc9350b1aedcb35be4f4b191cc0a3b30a",
"body": null,
"is_bot": false,
"headline": "Merge remote-tracking branch 'origin/master' into release/1.10.1",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-23T03:55:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "99da21d3d3b0f95b75e71c8b4431e336c988e7ce",
"body": null,
"is_bot": false,
"headline": "chore: prepare 1.10.1 release",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-23T03:53:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8b0917b1762e9bd5ec518c2f0c8ba13ef495ab81",
"body": "…fected\n\nfix: report rows affected for incremental delete+insert",
"is_bot": false,
"headline": "Merge pull request #754 from axellpadilla/fix/583-incremental-rows-af…",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-23T03:14:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2edf9bf179af3b5a46f06fce262089ad32385ef0",
"body": null,
"is_bot": false,
"headline": "fix: report rows affected for incremental delete+insert",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-23T02:44:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1ef71ea92ab5ef024e37e11440650b380af7f12f",
"body": "…tions\n\nfix: emit query_options on table_refresh_method=dml refresh path",
"is_bot": false,
"headline": "Merge pull request #753 from Benjamin-Knight/fix/dml-refresh-query-op…",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-22T20:23:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3c9ab7939162fb83e5efcba4d38d60712aa6b7f0",
"body": null,
"is_bot": false,
"headline": "Merge branch 'master' into fix/dml-refresh-query-options",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-22T20:21:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7c7d0cf6f0846ea38446bce839d33df9976bd74c",
"body": "install dev group explicitly in setup_env",
"is_bot": false,
"headline": "Merge pull request #748 from Benjamin-Knight/fix/devcontainer-dev-group",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-22T19:48:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "da53182fd7bfa32c492914ccb84e9f81d4af0bb7",
"body": "…arison\n\nfix: don't aggregate columns for clustered columnstore indexes in describe_indexes",
"is_bot": false,
"headline": "Merge pull request #745 from Benjamin-Knight/fix/cci-skip-column-comp…",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-22T19:44:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4c2ea6f373caeb2746b7d6864c197a209a88564d",
"body": "sqlserver__table_dml_refresh never called get_query_options(), so\nquery_options / query_options_raw (and the LABEL query tag) were\nsilently dropped on every steady-state DML refresh — inconsistent with\ncreate_table_as, which honors them. Both grant-taking statements are\naffected: the scratch-build S\n[…]\n off the\ncaptured debug log and checks each statement bounded by its terminator,\nso a hint on one can't be mistaken for the other.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "fix: emit query_options on table_refresh_method=dml refresh path",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-07-20T09:56:38Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "90bb90af36dc6076c009dbbdb9bc510f4fb888c0",
"body": "Add a full_refresh_build model config. `prebuilt` rebuilds a table in\nplace - drop the old table, recreate it empty with its clustered design\n(as_columnstore CCI or the clustered index from the indexes config), then\nbulk-load via INSERT WITH (TABLOCK). No intermediate copy or rename swap,\nso peak re\n[…]\nncremental\n over a failed refresh errors instead of appending onto stale data.\n\nBuilds on the indexes feature shipped in v1.10.1.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "feat: full_refresh_build config with prebuilt in-place rebuild path",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-07-16T14:39:24Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "8f71431790012ee51411f48fd5073ed586604ba6",
"body": "…cribe_indexes\n\nA clustered columnstore index (type 5) stores the whole table and has no key\ncolumns, so sys.index_columns lists every column for it. describe_indexes was\naggregating all of them into the `columns` field, which:\n\n - is meaningless: reconciliation (index_config_changes) matches a CCI\n[…]\nine user-chosen identity.\n\nExtends the wide-columnstore functional test to assert describe_indexes\nreports no columns for the CCI.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "fix: don't aggregate columns for clustered columnstore indexes in des…",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-07-16T13:57:45Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "c82271c00cd5d1193d84e8e60f613ecabc394b10",
"body": "Apply SQL Server Dynamic Data Masking as a post-materialization step,\nmodelled on apply_grants, so masks are re-applied on every build and\nsurvive dbt's drop-and-recreate on full refresh.\n\nTwo config surfaces resolve to one per-column mask map:\n- column-level `masked_with:` property in schema YAML (\n[…]\nnce, opt-out, validation, full-refresh\nsurvival, masked-user read, incremental idempotency, snapshot). Docs in\nREADME + CHANGELOG.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "feat: column-level Dynamic Data Masking (masked_with / masks)",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-07-16T13:36:04Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "653af1039c995956eefd88e0dde59b6d6ca1bdcd",
"body": "The setup script relied on uv installing the `dev` dependency group by\ndefault. That behaviour varies by uv version, so on a fresh devcontainer\nbuild the `dev` group (which provides pre-commit) was not installed and\n`pre-commit install` failed with `command not found`.\n\nRestore the explicit `--group dev` that was dropped in b9a4b8b, and run\npre-commit via `uv run` so it no longer depends on the venv being active.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "fix(devcontainer): install dev group explicitly in setup_env",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-07-16T12:28:34Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "f8f61b8fa5740c35e994d1b829f76a81014fe275",
"body": null,
"is_bot": false,
"headline": "Bump version to 1.10.1rc2",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-15T22:51:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f5d00a966c7ccc2d37e105eb48ad78e1d34eb3fd",
"body": "…erflow\n\nfix: STRING_AGG 8000-byte overflow in describe_indexes on wide tables (#735)",
"is_bot": false,
"headline": "Merge pull request #739 from joshmarkovic/fix/string-agg-8000-byte-ov…",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-15T20:33:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e1c8bb98abbed1253e9fb7f5afbf3139072878b5",
"body": "Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "fix: cast describe_indexes STRING_AGG input to nvarchar(max) (#735)",
"author_name": "Josh Markovic",
"author_login": "joshmarkovic",
"committed_at": "2026-07-10T13:10:57Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "894c21700a970c823741906a2ece26b7c301d624",
"body": "fix: make cancel() actually cancel the in-flight query",
"is_bot": false,
"headline": "Merge pull request #733 from joshmarkovic/fix/cancel-noop",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-06T17:47:11Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2de450771797978fffeb3f0e416f51302791388f",
"body": "SQLServerConnectionManager.cancel() was a no-op (it only logged), so\ndbt-core's cancel_open() could not stop sibling queries on Ctrl-C or\nwhen another thread failed; in-flight statements kept running\nserver-side, holding locks.\n\nTrack the in-flight cursor on the Connection during add_query and call\n\n[…]\nows errors from a statement\nthat completed between lookup and cancel.\n\nAdd unit tests for cancel() (in-flight, absent, unsupported, error\npaths) and for add_query registering then clearing the cursor.",
"is_bot": false,
"headline": "fix: make cancel() actually cancel the in-flight query",
"author_name": "Josh Markovic",
"author_login": "joshmarkovic",
"committed_at": "2026-07-06T03:43:20Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "45d5c4b1b6acfae78b70c186975b7c151eb0aae7",
"body": "fix: escape embedded closing braces in pyodbc connection string values",
"is_bot": false,
"headline": "Merge pull request #734 from joshmarkovic/fix/pyodbc-brace-escaping",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-03T15:55:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a2e6196336c67a678b04029df2946190c06a36b5",
"body": "fix: honor configured query retries and correct the retry debug event",
"is_bot": false,
"headline": "Merge pull request #730 from joshmarkovic/fix/query-retry-loop",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-03T15:41:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4a1e661793cded621f392544fcd5718954f1126a",
"body": "The three failure-path tests differed only in retries, side effect,\nexpected exception and expected attempt count; collapse them into one\nparametrized test. Also drop the unused connection element from the\ntest helper's return value.",
"is_bot": false,
"headline": "test: parametrize add_query retry failure cases",
"author_name": "Josh Markovic",
"author_login": "joshmarkovic",
"committed_at": "2026-07-03T15:34:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "88ad636142c325ec4c8a4149382f5b26fcea181c",
"body": "Drop the event-construction comment narrating the old message= defect\nand reduce the retry_limit comment to the one fact a reader needs:\nretries caps total execute attempts, so retries: 1 disables retry.",
"is_bot": false,
"headline": "docs: keep only reader-facing retry comments",
"author_name": "Josh Markovic",
"author_login": "joshmarkovic",
"committed_at": "2026-07-03T15:34:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "44f92812d2880c823a42d6f4cb8482ff181e2e13",
"body": "The query-level retry in SQLServerConnectionManager.add_query had two\ndefects:\n\n- A `credentials.retries > 3` guard silently ignored configured retry\n counts of 1-3 and fell back to a hardcoded limit of 2, so even the\n default `retries: 3` only attempted a query twice. Use\n `credentials.retries` \n[…]\n retrying. Use `base_msg=` as dbt-core's base add_query does.\n\nAdd unit tests covering retry-until-success, the retries=3 regression,\nno-retry at retries=1, and non-retryable errors not being retried.",
"is_bot": false,
"headline": "fix: honor configured query retries and stop retry-event crash",
"author_name": "Josh Markovic",
"author_login": "joshmarkovic",
"committed_at": "2026-07-03T15:34:18Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "541ce1a361e611411deece14e8cb910cf2c28eac",
"body": "The pyodbc branch of format_connection_string_value wrapped values in\nbraces without doubling embedded closing braces, so a password like\npa}ss produced PWD={pa}ss} and the driver misparsed the rest of the\nconnection string. The mssql-python branch already escaped correctly.\nDouble the closing brace per the ODBC quoting rules and cover both\nbackends with unit tests.",
"is_bot": false,
"headline": "fix: escape embedded closing braces in pyodbc connection string values",
"author_name": "Josh Markovic",
"author_login": "joshmarkovic",
"committed_at": "2026-07-02T18:34:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "cc7ceb0b8713a5dbff3a47b23123eebd8c61147a",
"body": "Fix safe type expansion for incremental models",
"is_bot": false,
"headline": "Merge pull request #731 from dbt-msft/fix/safe-type-expansion",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-01T01:44:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "cfa5086a181fc2199340beab195ef917295a5867",
"body": "[pre-commit.ci] pre-commit autoupdate",
"is_bot": false,
"headline": "Merge pull request #720 from dbt-msft/pre-commit-ci-update-config",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-07-01T01:44:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "803412436871694e580cd6b03fb3e8d48d2d94a1",
"body": "…b-actions-updates-640176b5ab\n\nchore(deps): bump actions/checkout from 6 to 7 in the github-actions-updates group",
"is_bot": false,
"headline": "Merge pull request #727 from dbt-msft/dependabot/github_actions/githu…",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-30T15:41:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "901d4f442a10afc0344f71018d45049d647ae144",
"body": "…and add test for widening",
"is_bot": false,
"headline": "fix: set default value for column_type_expansion_max_rows to 1000000 …",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-30T15:39:36Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1c060e74e932e09b44d150fe3d8d609c86951090",
"body": "feat: SQL Server 2025 support (plus as_columnstore docs and a store-failures regression test)",
"is_bot": false,
"headline": "Merge pull request #728 from joshmarkovic/feat/sql-server-2025",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-30T15:39:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f04d8015199e8a06956a3599ef82c8cb2cd7c4b8",
"body": null,
"is_bot": false,
"headline": "Merge branch 'master' into feat/sql-server-2025",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-30T15:38:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "10e1c77c5c205cfdaeb63dac412ad015fa5aadee",
"body": "docs: correct stale version, release, and CI references",
"is_bot": false,
"headline": "Merge pull request #729 from joshmarkovic/fix/docs-drift",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-30T03:36:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "216e00aee3883c91f31ea42fc46b078b9f9cfe46",
"body": "- README: the adapter requires dbt-core 1.10+ (pyproject pins\n >=1.10.0,<2.0), not 0.14; update the versioning example to 1.10.x.\n- CONTRIBUTING: drop the `integration-tests-azure` pipeline from the\n list; no such workflow exists under .github/workflows.\n- CONTRIBUTING: releases are cut by publish\n[…]\n (the\n release-version workflow triggers on release publish, not a bare tag\n push), and the dbt-core constraint lives in pyproject.toml\n dependencies, not a `dbt_version` in a nonexistent setup.py.",
"is_bot": false,
"headline": "docs: correct stale version, release, and CI references",
"author_name": "Josh Markovic",
"author_login": "joshmarkovic",
"committed_at": "2026-06-29T20:09:39Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "6b0c70b9623aa5a22a3c6a12f998ea8850c72830",
"body": "updates:\n- [github.com/astral-sh/ruff-pre-commit: v0.15.17 → v0.15.20](https://github.com/astral-sh/ruff-pre-commit/compare/v0.15.17...v0.15.20)",
"is_bot": true,
"headline": "[pre-commit.ci] pre-commit autoupdate",
"author_name": "pre-commit-ci[bot]",
"author_login": "pre-commit-ci[bot]",
"committed_at": "2026-06-29T20:08:58Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8d9d883ae56f0bde6744bea40d8b523392c5a710",
"body": "The index feature emits OPTIMIZE_FOR_SEQUENTIAL_KEY and RESUMABLE (plus\nRESUMABLE's MAX_DURATION) unconditionally. These are only recognized on\nSQL Server 2019 (major 15)+, so on a genuine 2017 engine the CREATE INDEX\nfails with \"is not a recognized CREATE INDEX option\" (msg 155).\n\nThis was masked u\n[…]\nout them instead of failing. ONLINE is kept (recognized on\n2017, edition-gated not version-gated). Behavior on 2019+ is unchanged.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "fix: gate 2019+ CREATE INDEX options on detected engine version",
"author_name": "Josh Markovic",
"author_login": "joshmarkovic",
"committed_at": "2026-06-27T15:33:54Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "ad899620908439470bd182095dfec68ed5a3c52e",
"body": "Addresses @axellpadilla's review on #721.\n\n- integration tests: make 2025 the matrix baseline, replacing 2022 as the\n latest tier. Keep 2017, 2019 and 2022 as single legacy rows so all four\n versions stay covered by CI.\n- README: remove the duplicate \"Supported SQL Server versions\" heading and\n the Azure SQL Database / Managed Instance rows that were marked tested.\n Azure is now described as not covered by CI but expected to be compatible.",
"is_bot": false,
"headline": "ci: promote SQL Server 2025 to baseline and fix README support section",
"author_name": "Josh Markovic",
"author_login": "joshmarkovic",
"committed_at": "2026-06-25T14:42:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4938cf2b39e534b35878b7bd7531665ec34911e6",
"body": null,
"is_bot": false,
"headline": "Merge branch 'master' into feat/sql-server-2025",
"author_name": "joshmarkovic",
"author_login": "joshmarkovic",
"committed_at": "2026-06-25T03:34:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c137d8053e7fcdc40aec19b08a1d8d599827861f",
"body": "Co-authored-by: Axell Padilla <68310020+axellpadilla@users.noreply.github.com>",
"is_bot": false,
"headline": "Update README.md",
"author_name": "joshmarkovic",
"author_login": "joshmarkovic",
"committed_at": "2026-06-25T03:26:57Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bddbfe8b1430eaab580ac82c7f0d3465bffc5d18",
"body": "Bumps the github-actions-updates group with 1 update: [actions/checkout](https://github.com/actions/checkout).\n\n\nUpdates `actions/checkout` from 6 to 7\n- [Release notes](https://github.com/actions/checkout/releases)\n- [Changelog](https://github.com/actions/checkout/blob/main/CHANGELOG.md)\n- [Commits\n[…]\nendency-version: '7'\n dependency-type: direct:production\n update-type: version-update:semver-major\n dependency-group: github-actions-updates\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>",
"is_bot": true,
"headline": "chore(deps): bump actions/checkout in the github-actions-updates group",
"author_name": "dependabot[bot]",
"author_login": "dependabot[bot]",
"committed_at": "2026-06-25T03:22:20Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "8298b7be288acc81e834243b4985bc312befd3c8",
"body": "Add CHANGELOG entries for v1.10.1 release",
"is_bot": false,
"headline": "Merge pull request #724 from dbt-msft/feat/v1.10.1-changelog-review",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-25T03:15:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c0298e25f2926dcfb4b33ebf95f1f07b92220c80",
"body": "Includes bugfixes for hook transaction safety, columnstore guards, query_tag escaping, float mapping, default port, drop_schema_name, and access token errors. New features for dbt transaction handling, types, persist_docs, and mssql-python backend. Internal improvements consolidating linting to Ruff and dependency updates.",
"is_bot": false,
"headline": "Add CHANGELOG entries for v1.10.1 release",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-25T02:34:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "352d0a971f58460fb7f514df8e3a12a312ba8608",
"body": "feat: safe type expansion, NVARCHAR/NCHAR catalog fix, seed empty cell fix",
"is_bot": false,
"headline": "Merge pull request #702 from dbt-msft/fix/missing-type-handling",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-25T02:21:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6fd1c2e77f20b692bc518857af303658b78b9834",
"body": "…ndling",
"is_bot": false,
"headline": "Merge remote-tracking branch 'origin/master' into fix/missing-type-ha…",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-25T02:20:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3cc72e4d654aaf4b673063da07c48324de97afdc",
"body": "… as integer",
"is_bot": false,
"headline": "Remove PostgreSQL types from SQL Server integer detection and doc bit…",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-25T02:19:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9c00a87927a8a514aa1ff954807f36da3c70f033",
"body": "…ndling",
"is_bot": false,
"headline": "Merge remote-tracking branch 'origin/master' into fix/missing-type-ha…",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-25T02:11:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3768fea9fbf075c9acf048958d26a113dd8806f7",
"body": "Use uv sync --all-extras and run instead of explicit pip install commands",
"is_bot": false,
"headline": "Merge pull request #723 from dbt-msft/fix/devcontainer-odbc-env-standard",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-25T02:10:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b9a4b8bf5432a166c5b1de5d076c7be5dfc0c144",
"body": "commands",
"is_bot": false,
"headline": "Use uv sync --all-extras and run instead of explicit pip install",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-25T02:09:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "597e0a24d27d16003bcc9908bba2c81eb5d690f7",
"body": "Relocate SQLSERVER_TEST_DRIVER to setup_env.sh to comply with no spaces.",
"is_bot": false,
"headline": "Merge pull request #722 from dbt-msft/fix/devcontainer-odbc-env-standard",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-25T01:54:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "cb4c59c171bcf1c44b4c4626f06a15f4fa031985",
"body": null,
"is_bot": false,
"headline": "Relocate SQLSERVER_TEST_DRIVER to setup_env.sh to comply with no spaces.",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-25T01:43:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "66634a1c6f2e9b8638c7e0508f565520312feca1",
"body": "for more information, see https://pre-commit.ci",
"is_bot": true,
"headline": "[pre-commit.ci] auto fixes from pre-commit.com hooks",
"author_name": "pre-commit-ci[bot]",
"author_login": "pre-commit-ci[bot]",
"committed_at": "2026-06-24T20:30:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7d8e90b0fa0f43cb6184aaf9500f6338763d3b78",
"body": "A passing test run with --store-failures must replace prior failures with an empty audit table rather than drop it. Adds a functional regression test for dbt-msft/dbt-sqlserver#601.",
"is_bot": false,
"headline": "test: keep empty audit table on passing store-failures run (#601)",
"author_name": "Josh Markovic",
"author_login": "joshmarkovic",
"committed_at": "2026-06-24T19:58:04Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "391080c38043f277d530a70cab4a7c111222a053",
"body": "Explain that table materializations build a clustered columnstore index by default, and that as_columnstore: false is required for tables with (n)varchar(max)/LOB columns such as dbt store_failures audit tables.",
"is_bot": false,
"headline": "docs: document the as_columnstore table config",
"author_name": "Josh Markovic",
"author_login": "joshmarkovic",
"committed_at": "2026-06-24T19:58:04Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "703862b68734b806c42cf8fc8d86fd248633f8aa",
"body": "Cover SQL Server 2025 in the integration-test matrix (pyodbc and mssql-python on Python 3.13 / ODBC Driver 18) and add it to the published server CI images.\n\nRename the server Dockerfile build arg SQLServer_VERSION to MSSQL_VERSION to match the build-arg the workflow already passes; with the old name the matrix version was ignored and every image used the 2022 default.\n\nDocument 2025 as a supported version and refresh the stale dbt-core 0.14 compatibility note to 1.10.",
"is_bot": false,
"headline": "feat: add SQL Server 2025 support",
"author_name": "Josh Markovic",
"author_login": "joshmarkovic",
"committed_at": "2026-06-24T19:58:04Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d4ecf7ee8df575f777a27d4fb88c2b3ac0d6ff20",
"body": "Quick-win fixes: badge, exception type, is_integer, CI matrix, dead code",
"is_bot": false,
"headline": "Merge pull request #716 from joshmarkovic/fix/audit-quick-wins-2",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-22T20:32:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "39740efbd1f0b8cdff643e9fb7284742b5dc51b5",
"body": "sqlserver__create_or_replace_clone was unreachable (sqlserver__can_clone_table returns False and dbt-core provides default__create_or_replace_clone) and emitted invalid T-SQL. The unused 'tst' set block in create_view_as is also removed.",
"is_bot": false,
"headline": "chore: remove dead clone macro and unused view scaffolding variable",
"author_name": "Josh Markovic",
"author_login": "joshmarkovic",
"committed_at": "2026-06-22T18:37:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8bbc92eca609bf689db2a9b32544f53b3c9c066c",
"body": "requires-python is >=3.10; the 3.9 images were unused by the unit/integration/release workflows.",
"is_bot": false,
"headline": "ci: drop Python 3.9 from publish-docker matrix",
"author_name": "Josh Markovic",
"author_login": "joshmarkovic",
"committed_at": "2026-06-22T18:37:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fb744c050ef751028c6b2a5b3b3fd24224cb8c7e",
"body": "…ndling",
"is_bot": false,
"headline": "Merge remote-tracking branch 'origin/master' into fix/missing-type-ha…",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-20T05:28:36Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "68f7a363c8e399bbb9edbb9c8b4224fe64886de0",
"body": "Implements `dbt_sqlserver_use_dbt_transactions` behavior flag",
"is_bot": false,
"headline": "Merge pull request #710 from dbt-msft/fix/708-dbt-transactions",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-20T05:20:04Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2e1c6057d1731b2f9595b5ba3019688d57a14b4c",
"body": "…g is on; add snapshot functional test",
"is_bot": false,
"headline": "review: conditionally skip nested transaction in DML refresh when fla…",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-20T05:15:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5e9b03331749c486b77a344d5660fa30ed3b6c5e",
"body": "…saction support\n\nAdds a behavior flag that makes dbt transaction hooks (begin/commit/rollback)\nemit real T-SQL statements instead of being no-ops. The flag is stored at\nboth class level (for dbt-core's classmethod-based _rollback_handle) and\ninstance level (for add_begin_query/add_commit_query).\n\n-\n[…]\nsts: begin/commit/rollback behavior under both flag states\n- Functional tests: table/view/incremental materializations, rollback\n with and without flag, after-commit hooks, failed-then-successful run",
"is_bot": false,
"headline": "feat: add dbt_sqlserver_use_dbt_transactions flag for real T-SQL tran…",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-20T05:05:37Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "57decae39904cf08d474ffeecf95a78666c57b0d",
"body": "for more information, see https://pre-commit.ci",
"is_bot": true,
"headline": "[pre-commit.ci] auto fixes from pre-commit.com hooks",
"author_name": "pre-commit-ci[bot]",
"author_login": "pre-commit-ci[bot]",
"committed_at": "2026-06-20T03:39:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "425b86b967c0f11708d622eab7a22508eefe5580",
"body": null,
"is_bot": false,
"headline": "Merge branch 'master' into fix/missing-type-handling",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-20T03:39:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9f86896cc8f36c4794912cf5eccb49275ebebd86",
"body": "…indexes\n\n#535 Postgres style indexes",
"is_bot": false,
"headline": "Merge pull request #714 from Benjamin-Knight/feat/535-postgres-style-…",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-20T03:38:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "35cce4933d51f235bb431096b6a5e18b2a2759c6",
"body": "The previous underscore-joined approach could not distinguish\ncolumns=['a','b']\nfrom columns=['a'] with included_columns=['b'] since both produced the\nsame\nflat string 'a_b'. Using structured JSON with explicit field boundaries\npreserves the distinction.\nFix hash collision between key and included c\n[…]\no\ncolumns=['a','b'] produced the same hash as columns=['a'] with\nincluded_columns=['b']. Switch to structured JSON identity with named\nkeys\nso fields are distinguished regardless of grouping or order.",
"is_bot": false,
"headline": "Fix hash collision between key and included columns",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-19T07:57:49Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "add49ed3a19b791cc90472d873583dd937025fd8",
"body": "- Remove duplicate AdapterSpecificConfigs class attribute\n- Run ONLINE/RESUMABLE index creates outside the reconcile transaction\n (SQL Server forbids RESUMABLE in a user transaction; an ONLINE build\n wrapped in one holds its locks until commit, negating the non-blocking\n intent). index_changes no\n[…]\nn; not a framework hook)\n- Fix indexes config type hint Tuple[X] -> Tuple[X, ...]\n- black/isort formatting on test_index_macros.py\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "fix: address review findings on indexes feature",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-06-19T07:56:49Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "201a1c2fd4c2df27e0598bac56e777d3c878f467",
"body": "describe_indexes only hinted sys.indexes with NOLOCK; the OUTER APPLY\nreads of sys.index_columns, sys.columns and sys.partitions took shared\nlocks, so introspection queued on LCK_M_S behind concurrent index DDL on\nthe same table. Apply information_schema_hints() to every catalog read so\nthe whole metadata query is lock-free, matching the rest of the file.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "fix: lock-free index introspection across all catalog views",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-06-19T07:56:49Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "b18575fc2423da7616f0caf220a480cf566bf9ac",
"body": "Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "docs: changelog for the indexes feature set; SQL Server 2017 floor note",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-06-19T07:56:49Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "396b22e1312790e9de86278066cb3a087a8f849d",
"body": "- Reconcile drops+creates now execute as ONE transactional batch\n (set xact_abort on) so a definition change is atomic: no window where a\n replacement index or its uniqueness enforcement is missing, on any of\n the three reconcile surfaces.\n- drop_unmanaged_indexes is validated in validate_indexes\n[…]\nbbers\n them; snapshot with clustered index rejects default as_columnstore;\n invalid drop_unmanaged_indexes fails on first build.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "fix: review findings - atomic reconcile, early validation, dead rule",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-06-19T07:56:30Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "dc7384f3d7f6885c60eace4948a485bfed8a6d9d",
"body": "Create macro: per-column DESC, ]] identifier escaping, WHERE clause for\nfiltered indexes, and a full WITH assembly (data_compression, fillfactor,\npad_index, ignore_dup_key, optimize_for_sequential_key, sort_in_tempdb,\nplus build_options passthrough). Describe macro: descending key columns,\nfilter_de\n[…]\nfunctional fixture: the engine forbids\nIGNORE_DUP_KEY on filtered indexes, so ignore_dup_key x where now fails\nfast at parse time.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "feat: emit full option surface in create-index macro; richer describe",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-06-19T07:56:30Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "1dbe6edb074cae46438d98d6a9f9587990f41b3a",
"body": "online, maxdop, resumable, max_duration, allow_row_locks,\nallow_page_locks, statistics_norecompute, statistics_incremental and\ncompression_delay flow through to the WITH clause. Excluded from the name\nhash and from equality: they affect how an index is built, not what it is,\nso toggling them must never trigger a drop/recreate on reconcile. Unknown\nkeys fail validation with the allowed list.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "feat: build_options passthrough for CREATE INDEX build-time options",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-06-19T07:56:30Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "8af3951a926c2cad19ae55c1ec9bb9e83ab58990",
"body": "New fields: per-column direction ({'column': n, 'desc': true} entries,\nnormalized into descending_columns), where (filtered indexes, nonclustered\nand columnstore), fillfactor/pad_index, ignore_dup_key (unique rowstore),\noptimize_for_sequential_key (rowstore, 2019+), and columnstore /\ncolumnstore_arc\n[…]\npressible in config rather\nthan falling back to post-hooks, keeping definitions machine-readable for\nthe planned prebuilt feature.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "feat: full definition-option coverage for the indexes config",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-06-19T07:56:30Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "c21022ce1e222578db45829bc6b2fc906e09ce02",
"body": "dbt fires anonymous-usage telemetry and a PyPI version check on every\ninvocation; under the test harness that is one to three in-process\nrun_dbt() calls per functional test. On sandboxed or offline networks\n(devcontainers, some CI runners) those requests stall with variable\ntimeouts - measured 21-95\n[…]\n which\ninflated the functional suite from ~17s to ~96s per test. Even with a\nworking network they are wasted cycles in a test run.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "chore: disable dbt telemetry and version check in test env",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-06-19T07:56:30Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "c358d4c0892a4ea7afad940d9f1d5741989d7f07",
"body": "Coverage baseline on relation_configs (99%, single defensive re-raise\nuncovered) exposed that dbtClassMixin/mashumaro silently replaces any\nfrom_dict defined in the class body with a generated method - our\nnormalization override was dead code, so data_compression: PAGE/NONE\n(uppercase) failed valida\n[…]\nzing. Normalization now\nhappens in parse(), the raw-config entry point, and the dead override is\nremoved with an explanatory note.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "chore: add pytest-cov; fix dead from_dict override found by coverage",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-06-19T07:56:30Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "da44288833fd1873878f72766d51929d30564e3a",
"body": "adapter.validate_indexes rejects more than one clustered entry and a\nclustered rowstore entry combined with as_columnstore=true (the default),\nreplacing the opaque engine error 'Cannot create more than one clustered\nindex' with an actionable message. Called from a new\nsqlserver__create_indexes overr\n[…]\nindexes.\nas_columnstore is only weighed for materializations that honor it\n(table/incremental/snapshot) - seeds never build a CCI.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "feat: cross-config index validation",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-06-19T07:56:30Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "7f1c3a65427f4a8c43d5881d2a1ca8a2971166ce",
"body": "New macros: sqlserver__describe_indexes (sys.indexes + STRING_AGG key/\ninclude columns, compression, constraint flags; SQL Server 2017+),\nsqlserver__get_drop_index_sql, and sqlserver__reconcile_indexes, which\ndiffs existing indexes against the indexes config via\nadapter.index_changes and applies dro\n[…]\nde_config now\nemits JSON-compatible types so reconcile creates can round-trip through\nparse_index (latent bug in the original PR).\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "feat: index reconciliation on persistent-table paths",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-06-19T07:56:30Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "31b0622cfb9b953251c1d160f08465e914d817f4",
"body": "index_config_changes() computes drops-before-creates from describe rows vs\nexpected configs using name-set arithmetic (deterministic names make name\nequality <=> definition equality). Hard exclusions in every mode:\nconstraint-backing indexes and legacy post-hook (clustered_/nonclustered_)\nnames. dro\n[…]\npace from aggregated\ncolumn lists, parses NULL/empty includes to empty sets, coerces unique to\nbool, and carries data_compression.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "feat: index reconciliation diff engine",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-06-19T07:56:30Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "8fe7aae4fcfc172cb7b104cb940a0b5f2fc61d38",
"body": "data_compression (none|row|page, rowstore only) participates in the\ndefinition hash and equality, so changing it produces a new name and a\nrebuild on reconcile; 'none' normalizes to absent so it hashes like the\nengine default. sort_in_tempdb is a build-time option: excluded from hash\nand equality (n\n[…]\nindex) so\ntoggling it never triggers drop/recreate. Both render into a WITH clause\non CREATE INDEX; both rejected for columnstore.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "feat: data_compression and sort_in_tempdb index config options",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-06-19T07:56:30Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "513b8ccbe5f1d99192448d809aaeca39301866da",
"body": "sqlserver__get_create_index_sql now guards with IF NOT EXISTS (names are\ndeterministic full-definition hashes, so an existing index with the same\nname is already the desired index) and bracket-quotes the index name, key\ncolumns and INCLUDE columns so reserved-word column names work. Adds a\nreserved-word functional test and consolidates the name/definition\nstability assertions into one two-build test.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "feat: idempotent create-index macro with bracket quoting",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-06-19T07:56:30Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "f182231361d924d6a9215cc9eacfc6e658da2d60",
"body": "render() now hashes the full index definition (ordered columns, sorted\nincluded columns, relation identity, unique, type) under a dbt_idx_ prefix.\nSQL Server index names are per-table scoped, so the Postgres rename\ncollision (dbt-core#1945) the timestamp guarded against cannot occur here;\ndeterminism is required so name equality <=> definition equality for\nreconciliation. Also removes the leftover debug print.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "feat: deterministic dbt_idx_ index names, drop timestamp salt",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-06-19T07:56:30Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "76f8f920e5ce99bd58560a1599d90238f8d65e58",
"body": "test_table_index_names_stable_across_runs is xfail(strict): timestamp-hashed\nindex names regenerate on every rebuild, which blocks name-based\nreconciliation. test_table_definitions_stable_across_runs pins that the\ndefinition set does not accumulate today (table rebuilds are always fresh).\n\nCo-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>",
"is_bot": false,
"headline": "test: characterize index name churn across table rebuilds",
"author_name": "Ben Knight",
"author_login": "Benjamin-Knight",
"committed_at": "2026-06-19T07:56:30Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "866c3b1ef477bd2607f19ca2b40084006dbbcdc3",
"body": "…tests for index configs",
"is_bot": false,
"headline": "fixed typing for python >=3.8, optimized with inmutables, added unit …",
"author_name": "Axell Padilla",
"author_login": "axellpadilla",
"committed_at": "2026-06-19T07:56:30Z",
"body_truncated": false,
"is_coding_agent": false
}
],
"releases_count": 65,
"commits_last_year": 257,
"latest_release_at": "2026-07-27T04:16:44Z",
"latest_release_tag": "v1.11.0rc1",
"releases_from_tags": false,
"days_since_last_push": 0,
"active_weeks_last_year": 19,
"days_since_latest_release": 0,
"mean_days_between_releases": 46.6
},
"community": {
"has_readme": true,
"has_license": true,
"has_description": true,
"has_contributing": true,
"health_percentage": 62,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": false
},
"ecosystem": {
"packages": [
{
"name": "dbt-sqlserver",
"exists": true,
"license": "MIT",
"keywords": [
"Development Status :: 5 - Production/Stable",
"License :: OSI Approved :: MIT License",
"Operating System :: MacOS :: MacOS X",
"Operating System :: Microsoft :: Windows",
"Operating System :: POSIX :: Linux",
"Programming Language :: Python :: 3.10",
"Programming Language :: Python :: 3.11",
"Programming Language :: Python :: 3.12",
"Programming Language :: Python :: 3.13"
],
"ecosystem": "pypi",
"matches_repo": true,
"registry_url": "https://pypi.org/project/dbt-sqlserver/",
"is_deprecated": false,
"latest_version": "1.10.1",
"repository_url": "https://github.com/dbt-msft/dbt-sqlserver",
"versions_count": 71,
"total_downloads": null,
"dependents_count": null,
"deprecation_note": null,
"maintainers_count": null,
"monthly_downloads": 172366,
"first_published_at": "2019-07-16T06:35:47.551567Z",
"latest_published_at": "2026-07-23T04:13:20.245864Z",
"latest_version_yanked": null,
"days_since_latest_publish": 4
}
]
},
"popularity": {
"forks": 113,
"stars": 252,
"watchers": 9,
"fork_history": {
"days": [
{
"date": "2019-07-07",
"count": 1
},
{
"date": "2019-10-16",
"count": 1
},
{
"date": "2020-01-30",
"count": 1
},
{
"date": "2020-03-20",
"count": 1
},
{
"date": "2020-06-04",
"count": 1
},
{
"date": "2020-06-12",
"count": 1
},
{
"date": "2020-06-15",
"count": 1
},
{
"date": "2020-07-02",
"count": 1
},
{
"date": "2020-07-07",
"count": 1
},
{
"date": "2020-07-30",
"count": 1
},
{
"date": "2020-08-04",
"count": 1
},
{
"date": "2020-08-12",
"count": 1
},
{
"date": "2020-08-22",
"count": 1
},
{
"date": "2020-11-13",
"count": 1
},
{
"date": "2020-12-29",
"count": 1
},
{
"date": "2021-01-17",
"count": 1
},
{
"date": "2021-01-19",
"count": 1
},
{
"date": "2021-02-02",
"count": 1
},
{
"date": "2021-02-14",
"count": 1
},
{
"date": "2021-02-16",
"count": 2
},
{
"date": "2021-02-21",
"count": 1
},
{
"date": "2021-07-15",
"count": 1
},
{
"date": "2021-08-02",
"count": 1
},
{
"date": "2021-10-08",
"count": 1
},
{
"date": "2021-10-14",
"count": 1
},
{
"date": "2021-10-20",
"count": 1
},
{
"date": "2021-12-18",
"count": 1
},
{
"date": "2021-12-22",
"count": 1
},
{
"date": "2022-01-24",
"count": 1
},
{
"date": "2022-01-27",
"count": 1
},
{
"date": "2022-02-07",
"count": 1
},
{
"date": "2022-02-09",
"count": 1
},
{
"date": "2022-02-25",
"count": 1
},
{
"date": "2022-04-13",
"count": 1
},
{
"date": "2022-04-15",
"count": 1
},
{
"date": "2022-04-17",
"count": 1
},
{
"date": "2022-04-28",
"count": 1
},
{
"date": "2022-06-02",
"count": 1
},
{
"date": "2022-06-17",
"count": 1
},
{
"date": "2022-06-23",
"count": 1
},
{
"date": "2022-08-11",
"count": 1
},
{
"date": "2022-09-07",
"count": 1
},
{
"date": "2022-09-14",
"count": 1
},
{
"date": "2022-09-19",
"count": 1
},
{
"date": "2022-09-25",
"count": 1
},
{
"date": "2022-11-30",
"count": 1
},
{
"date": "2022-12-20",
"count": 1
},
{
"date": "2023-01-20",
"count": 1
},
{
"date": "2023-02-23",
"count": 1
},
{
"date": "2023-02-26",
"count": 1
},
{
"date": "2023-03-08",
"count": 1
},
{
"date": "2023-03-27",
"count": 1
},
{
"date": "2023-04-22",
"count": 1
},
{
"date": "2023-04-29",
"count": 1
},
{
"date": "2023-05-26",
"count": 1
},
{
"date": "2023-06-15",
"count": 1
},
{
"date": "2023-08-17",
"count": 1
},
{
"date": "2023-08-21",
"count": 2
},
{
"date": "2023-09-05",
"count": 1
},
{
"date": "2023-09-11",
"count": 1
},
{
"date": "2023-10-19",
"count": 1
},
{
"date": "2023-10-20",
"count": 1
},
{
"date": "2023-10-24",
"count": 1
},
{
"date": "2023-11-02",
"count": 1
},
{
"date": "2023-11-28",
"count": 1
},
{
"date": "2023-12-15",
"count": 1
},
{
"date": "2023-12-17",
"count": 1
},
{
"date": "2024-01-31",
"count": 1
},
{
"date": "2024-02-15",
"count": 2
},
{
"date": "2024-02-20",
"count": 1
},
{
"date": "2024-02-27",
"count": 1
},
{
"date": "2024-03-08",
"count": 1
},
{
"date": "2024-03-17",
"count": 1
},
{
"date": "2024-05-08",
"count": 1
},
{
"date": "2024-05-20",
"count": 1
},
{
"date": "2024-06-24",
"count": 1
},
{
"date": "2024-07-15",
"count": 1
},
{
"date": "2024-09-12",
"count": 1
},
{
"date": "2024-10-05",
"count": 1
},
{
"date": "2024-10-24",
"count": 1
},
{
"date": "2024-10-28",
"count": 1
},
{
"date": "2024-11-05",
"count": 1
},
{
"date": "2024-12-31",
"count": 1
},
{
"date": "2025-01-24",
"count": 1
},
{
"date": "2025-02-11",
"count": 2
},
{
"date": "2025-03-14",
"count": 1
},
{
"date": "2025-03-31",
"count": 1
},
{
"date": "2025-04-07",
"count": 1
},
{
"date": "2025-07-12",
"count": 1
},
{
"date": "2025-08-13",
"count": 1
},
{
"date": "2025-10-02",
"count": 1
},
{
"date": "2025-11-05",
"count": 1
},
{
"date": "2025-12-23",
"count": 1
},
{
"date": "2026-01-21",
"count": 1
},
{
"date": "2026-02-19",
"count": 1
},
{
"date": "2026-03-04",
"count": 1
},
{
"date": "2026-03-12",
"count": 1
},
{
"date": "2026-03-18",
"count": 1
},
{
"date": "2026-04-02",
"count": 1
},
{
"date": "2026-05-14",
"count": 2
},
{
"date": "2026-06-05",
"count": 1
},
{
"date": "2026-06-12",
"count": 1
},
{
"date": "2026-07-20",
"count": 1
},
{
"date": "2026-07-21",
"count": 1
}
],
"complete": true,
"collected": 109,
"total_forks": 113
},
"star_history": null,
"open_issues_and_prs": 30
},
"ai_readiness": {
"has_nix": false,
"example_dirs": [],
"has_llms_txt": false,
"has_dockerfile": true,
"has_mcp_signal": false,
"bootstrap_files": [
"Makefile"
],
"api_schema_files": [],
"has_devcontainer": true,
"typecheck_configs": [
"dbt/adapters/sqlserver/py.typed"
],
"toolchain_manifests": [],
"largest_source_bytes": 67873,
"source_files_sampled": 99,
"oversized_source_files": 1,
"agent_instruction_files": [],
"agent_instruction_max_bytes": null
},
"dependencies": {
"manifests": [
"pyproject.toml"
],
"advisories": {
"error": null,
"scope": "published_package",
"source": "osv",
"findings": [],
"collected": true,
"malicious": [],
"truncated": false,
"by_severity": {},
"advisory_count": 0,
"affected_count": 0,
"assessed_count": 57,
"malicious_count": 0,
"assessed_package": "pypi:dbt-sqlserver@1.10.1",
"unassessed_count": 0,
"direct_affected_count": 0
},
"ecosystems": [
"pypi"
],
"dependencies": [
{
"name": "dbt-core",
"manifest": "pyproject.toml",
"ecosystem": "pypi",
"version_constraint": ">=1.11.0,<2.0"
},
{
"name": "dbt-common",
"manifest": "pyproject.toml",
"ecosystem": "pypi",
"version_constraint": ">=1.22.0,<2.0"
},
{
"name": "dbt-adapters",
"manifest": "pyproject.toml",
"ecosystem": "pypi",
"version_constraint": ">=1.24.1,<2.0"
},
{
"name": "pyodbc",
"manifest": "pyproject.toml",
"ecosystem": "pypi",
"version_constraint": ">=5.2.0"
}
],
"all_dependencies": {
"error": null,
"source": "github-sbom",
"packages": [
{
"name": "dbt-adapters",
"direct": true,
"version": null,
"ecosystem": "pypi"
},
{
"name": "dbt-adapters",
"direct": true,
"version": "1.24.1",
"ecosystem": "pypi"
},
{
"name": "dbt-common",
"direct": true,
"version": null,
"ecosystem": "pypi"
},
{
"name": "dbt-common",
"direct": true,
"version": "1.38.0",
"ecosystem": "pypi"
},
{
"name": "dbt-core",
"direct": true,
"version": null,
"ecosystem": "pypi"
},
{
"name": "dbt-core",
"direct": true,
"version": "1.11.12",
"ecosystem": "pypi"
},
{
"name": "pyodbc",
"direct": true,
"version": null,
"ecosystem": "pypi"
},
{
"name": "pyodbc",
"direct": true,
"version": "5.3.0",
"ecosystem": "pypi"
},
{
"name": "agate",
"direct": false,
"version": "1.9.1",
"ecosystem": "pypi"
},
{
"name": "annotated-types",
"direct": false,
"version": "0.7.0",
"ecosystem": "pypi"
},
{
"name": "ast-serialize",
"direct": false,
"version": "0.5.0",
"ecosystem": "pypi"
},
{
"name": "asttokens",
"direct": false,
"version": "3.0.1",
"ecosystem": "pypi"
},
{
"name": "attrs",
"direct": false,
"version": "26.1.0",
"ecosystem": "pypi"
},
{
"name": "azure-core",
"direct": false,
"version": "1.41.0",
"ecosystem": "pypi"
},
{
"name": "azure-identity",
"direct": false,
"version": null,
"ecosystem": "pypi"
},
{
"name": "azure-identity",
"direct": false,
"version": "1.25.3",
"ecosystem": "pypi"
},
{
"name": "babel",
"direct": false,
"version": "2.18.0",
"ecosystem": "pypi"
},
{
"name": "backports-tarfile",
"direct": false,
"version": "1.2.0",
"ecosystem": "pypi"
},
{
"name": "build",
"direct": false,
"version": "1.5.0",
"ecosystem": "pypi"
},
{
"name": "bump2version",
"direct": false,
"version": "1.0.1",
"ecosystem": "pypi"
},
{
"name": "bumpversion",
"direct": false,
"version": "0.6.0",
"ecosystem": "pypi"
},
{
"name": "cachetools",
"direct": false,
"version": "7.1.3",
"ecosystem": "pypi"
},
{
"name": "certifi",
"direct": false,
"version": "2026.4.22",
"ecosystem": "pypi"
},
{
"name": "cffi",
"direct": false,
"version": "2.0.0",
"ecosystem": "pypi"
},
{
"name": "cfgv",
"direct": false,
"version": "3.5.0",
"ecosystem": "pypi"
},
{
"name": "charset-normalizer",
"direct": false,
"version": "3.4.7",
"ecosystem": "pypi"
},
{
"name": "click",
"direct": false,
"version": "8.4.0",
"ecosystem": "pypi"
},
{
"name": "colorama",
"direct": false,
"version": "0.4.6",
"ecosystem": "pypi"
},
{
"name": "coverage",
"direct": false,
"version": "7.14.1",
"ecosystem": "pypi"
},
{
"name": "cryptography",
"direct": false,
"version": "48.0.0",
"ecosystem": "pypi"
},
{
"name": "daff",
"direct": false,
"version": "1.4.2",
"ecosystem": "pypi"
},
{
"name": "dbt-extractor",
"direct": false,
"version": "0.6.0",
"ecosystem": "pypi"
},
{
"name": "dbt-protos",
"direct": false,
"version": "1.0.498",
"ecosystem": "pypi"
},
{
"name": "dbt-semantic-interfaces",
"direct": false,
"version": "0.9.0",
"ecosystem": "pypi"
},
{
"name": "dbt-tests-adapter",
"direct": false,
"version": null,
"ecosystem": "pypi"
},
{
"name": "dbt-tests-adapter",
"direct": false,
"version": "1.20.0",
"ecosystem": "pypi"
},
{
"name": "decorator",
"direct": false,
"version": "5.3.1",
"ecosystem": "pypi"
},
{
"name": "deepdiff",
"direct": false,
"version": "8.6.2",
"ecosystem": "pypi"
},
{
"name": "distlib",
"direct": false,
"version": "0.4.0",
"ecosystem": "pypi"
},
{
"name": "docutils",
"direct": false,
"version": "0.22.4",
"ecosystem": "pypi"
},
{
"name": "execnet",
"direct": false,
"version": "2.1.2",
"ecosystem": "pypi"
},
{
"name": "executing",
"direct": false,
"version": "2.2.1",
"ecosystem": "pypi"
},
{
"name": "filelock",
"direct": false,
"version": "3.29.0",
"ecosystem": "pypi"
},
{
"name": "flaky",
"direct": false,
"version": "3.8.1",
"ecosystem": "pypi"
},
{
"name": "freezegun",
"direct": false,
"version": "1.4.0",
"ecosystem": "pypi"
},
{
"name": "freezegun",
"direct": false,
"version": "1.5.5",
"ecosystem": "pypi"
},
{
"name": "id",
"direct": false,
"version": "1.6.1",
"ecosystem": "pypi"
},
{
"name": "identify",
"direct": false,
"version": "2.6.19",
"ecosystem": "pypi"
},
{
"name": "idna",
"direct": false,
"version": "3.15",
"ecosystem": "pypi"
},
{
"name": "importlib-metadata",
"direct": false,
"version": "8.9.0",
"ecosystem": "pypi"
},
{
"name": "iniconfig",
"direct": false,
"version": "2.3.0",
"ecosystem": "pypi"
},
{
"name": "ipdb",
"direct": false,
"version": "0.13.13",
"ecosystem": "pypi"
},
{
"name": "ipython",
"direct": false,
"version": "9.13.0",
"ecosystem": "pypi"
},
{
"name": "ipython-pygments-lexers",
"direct": false,
"version": "1.1.1",
"ecosystem": "pypi"
},
{
"name": "isodate",
"direct": false,
"version": "0.7.2",
"ecosystem": "pypi"
},
{
"name": "jaraco-classes",
"direct": false,
"version": "3.4.0",
"ecosystem": "pypi"
},
{
"name": "jaraco-context",
"direct": false,
"version": "6.1.2",
"ecosystem": "pypi"
},
{
"name": "jaraco-functools",
"direct": false,
"version": "4.5.0",
"ecosystem": "pypi"
},
{
"name": "jedi",
"direct": false,
"version": "0.20.0",
"ecosystem": "pypi"
},
{
"name": "jeepney",
"direct": false,
"version": "0.9.0",
"ecosystem": "pypi"
},
{
"name": "jinja2",
"direct": false,
"version": "3.1.6",
"ecosystem": "pypi"
},
{
"name": "jsonschema",
"direct": false,
"version": "4.26.0",
"ecosystem": "pypi"
},
{
"name": "jsonschema-specifications",
"direct": false,
"version": "2025.9.1",
"ecosystem": "pypi"
},
{
"name": "keyring",
"direct": false,
"version": "25.7.0",
"ecosystem": "pypi"
},
{
"name": "leather",
"direct": false,
"version": "0.4.1",
"ecosystem": "pypi"
},
{
"name": "librt",
"direct": false,
"version": "0.11.0",
"ecosystem": "pypi"
},
{
"name": "markdown-it-py",
"direct": false,
"version": "4.2.0",
"ecosystem": "pypi"
},
{
"name": "markupsafe",
"direct": false,
"version": "3.0.3",
"ecosystem": "pypi"
},
{
"name": "mashumaro",
"direct": false,
"version": "3.14",
"ecosystem": "pypi"
},
{
"name": "matplotlib-inline",
"direct": false,
"version": "0.2.2",
"ecosystem": "pypi"
},
{
"name": "mdurl",
"direct": false,
"version": "0.1.2",
"ecosystem": "pypi"
},
{
"name": "more-itertools",
"direct": false,
"version": "10.8.0",
"ecosystem": "pypi"
},
{
"name": "msal",
"direct": false,
"version": "1.36.0",
"ecosystem": "pypi"
},
{
"name": "msal-extensions",
"direct": false,
"version": "1.3.1",
"ecosystem": "pypi"
},
{
"name": "msgpack",
"direct": false,
"version": "1.1.2",
"ecosystem": "pypi"
},
{
"name": "mssql-python",
"direct": false,
"version": "1.7.1",
"ecosystem": "pypi"
},
{
"name": "mypy",
"direct": false,
"version": "1.11.2",
"ecosystem": "pypi"
},
{
"name": "mypy",
"direct": false,
"version": "2.1.0",
"ecosystem": "pypi"
},
{
"name": "mypy-extensions",
"direct": false,
"version": "1.1.0",
"ecosystem": "pypi"
},
{
"name": "networkx",
"direct": false,
"version": "3.6.1",
"ecosystem": "pypi"
},
{
"name": "nh3",
"direct": false,
"version": "0.3.5",
"ecosystem": "pypi"
},
{
"name": "nodeenv",
"direct": false,
"version": "1.10.0",
"ecosystem": "pypi"
},
{
"name": "orderly-set",
"direct": false,
"version": "5.5.0",
"ecosystem": "pypi"
},
{
"name": "packaging",
"direct": false,
"version": "26.2",
"ecosystem": "pypi"
},
{
"name": "parsedatetime",
"direct": false,
"version": "2.6",
"ecosystem": "pypi"
},
{
"name": "parso",
"direct": false,
"version": "0.8.7",
"ecosystem": "pypi"
},
{
"name": "pathspec",
"direct": false,
"version": "0.12.1",
"ecosystem": "pypi"
},
{
"name": "pexpect",
"direct": false,
"version": "4.9.0",
"ecosystem": "pypi"
},
{
"name": "platformdirs",
"direct": false,
"version": "4.9.6",
"ecosystem": "pypi"
},
{
"name": "pluggy",
"direct": false,
"version": "1.6.0",
"ecosystem": "pypi"
},
{
"name": "pre-commit",
"direct": false,
"version": "4.6.0",
"ecosystem": "pypi"
},
{
"name": "prompt-toolkit",
"direct": false,
"version": "3.0.52",
"ecosystem": "pypi"
},
{
"name": "protobuf",
"direct": false,
"version": "6.33.6",
"ecosystem": "pypi"
},
{
"name": "psutil",
"direct": false,
"version": "7.2.2",
"ecosystem": "pypi"
},
{
"name": "ptyprocess",
"direct": false,
"version": "0.7.0",
"ecosystem": "pypi"
},
{
"name": "pure-eval",
"direct": false,
"version": "0.2.3",
"ecosystem": "pypi"
},
{
"name": "pycparser",
"direct": false,
"version": "3.0",
"ecosystem": "pypi"
},
{
"name": "pydantic",
"direct": false,
"version": "2.13.4",
"ecosystem": "pypi"
},
{
"name": "pydantic-core",
"direct": false,
"version": "2.46.4",
"ecosystem": "pypi"
},
{
"name": "pygments",
"direct": false,
"version": "2.20.0",
"ecosystem": "pypi"
},
{
"name": "pyjwt",
"direct": false,
"version": "2.12.1",
"ecosystem": "pypi"
},
{
"name": "pyproject-api",
"direct": false,
"version": "1.10.0",
"ecosystem": "pypi"
},
{
"name": "pyproject-hooks",
"direct": false,
"version": "1.2.0",
"ecosystem": "pypi"
},
{
"name": "pytest",
"direct": false,
"version": "9.0.3",
"ecosystem": "pypi"
},
{
"name": "pytest-cov",
"direct": false,
"version": "7.1.0",
"ecosystem": "pypi"
},
{
"name": "pytest-csv",
"direct": false,
"version": "3.0.0",
"ecosystem": "pypi"
},
{
"name": "pytest-dotenv",
"direct": false,
"version": "0.5.2",
"ecosystem": "pypi"
},
{
"name": "pytest-xdist",
"direct": false,
"version": "3.8.0",
"ecosystem": "pypi"
},
{
"name": "python-dateutil",
"direct": false,
"version": "2.9.0.post0",
"ecosystem": "pypi"
},
{
"name": "python-discovery",
"direct": false,
"version": "1.3.1",
"ecosystem": "pypi"
},
{
"name": "python-dotenv",
"direct": false,
"version": "1.2.2",
"ecosystem": "pypi"
},
{
"name": "python-slugify",
"direct": false,
"version": "8.0.4",
"ecosystem": "pypi"
},
{
"name": "pytimeparse",
"direct": false,
"version": "1.1.8",
"ecosystem": "pypi"
},
{
"name": "pytz",
"direct": false,
"version": "2026.2",
"ecosystem": "pypi"
},
{
"name": "pywin32-ctypes",
"direct": false,
"version": "0.2.3",
"ecosystem": "pypi"
},
{
"name": "pyyaml",
"direct": false,
"version": "6.0.3",
"ecosystem": "pypi"
},
{
"name": "readme-renderer",
"direct": false,
"version": "44.0",
"ecosystem": "pypi"
},
{
"name": "referencing",
"direct": false,
"version": "0.37.0",
"ecosystem": "pypi"
},
{
"name": "requests",
"direct": false,
"version": "2.34.2",
"ecosystem": "pypi"
},
{
"name": "requests-toolbelt",
"direct": false,
"version": "1.0.0",
"ecosystem": "pypi"
},
{
"name": "rfc3986",
"direct": false,
"version": "2.0.0",
"ecosystem": "pypi"
},
{
"name": "rich",
"direct": false,
"version": "15.0.0",
"ecosystem": "pypi"
},
{
"name": "rpds-py",
"direct": false,
"version": "0.30.0",
"ecosystem": "pypi"
},
{
"name": "ruff",
"direct": false,
"version": "0.15.13",
"ecosystem": "pypi"
},
{
"name": "secretstorage",
"direct": false,
"version": "3.5.0",
"ecosystem": "pypi"
},
{
"name": "setuptools",
"direct": false,
"version": null,
"ecosystem": "pypi"
},
{
"name": "six",
"direct": false,
"version": "1.17.0",
"ecosystem": "pypi"
},
{
"name": "snowplow-tracker",
"direct": false,
"version": "1.1.0",
"ecosystem": "pypi"
},
{
"name": "sqlparse",
"direct": false,
"version": "0.5.5",
"ecosystem": "pypi"
},
{
"name": "stack-data",
"direct": false,
"version": "0.6.3",
"ecosystem": "pypi"
},
{
"name": "text-unidecode",
"direct": false,
"version": "1.3",
"ecosystem": "pypi"
},
{
"name": "tomli",
"direct": false,
"version": "2.4.1",
"ecosystem": "pypi"
},
{
"name": "tomli-w",
"direct": false,
"version": "1.2.0",
"ecosystem": "pypi"
},
{
"name": "tox",
"direct": false,
"version": null,
"ecosystem": "pypi"
},
{
"name": "tox",
"direct": false,
"version": "4.54.0",
"ecosystem": "pypi"
},
{
"name": "traitlets",
"direct": false,
"version": "5.15.0",
"ecosystem": "pypi"
},
{
"name": "twine",
"direct": false,
"version": "6.2.0",
"ecosystem": "pypi"
},
{
"name": "typing-extensions",
"direct": false,
"version": "4.15.0",
"ecosystem": "pypi"
},
{
"name": "typing-inspection",
"direct": false,
"version": "0.4.2",
"ecosystem": "pypi"
},
{
"name": "tzdata",
"direct": false,
"version": "2026.2",
"ecosystem": "pypi"
},
{
"name": "urllib3",
"direct": false,
"version": "2.7.0",
"ecosystem": "pypi"
},
{
"name": "virtualenv",
"direct": false,
"version": "21.3.3",
"ecosystem": "pypi"
},
{
"name": "wcwidth",
"direct": false,
"version": "0.7.0",
"ecosystem": "pypi"
},
{
"name": "zipp",
"direct": false,
"version": "4.1.0",
"ecosystem": "pypi"
}
],
"collected": true,
"truncated": false,
"total_count": 144,
"direct_count": 8,
"indirect_count": 136
}
},
"maintainership": {
"issues": {
"open_prs": 12,
"merged_prs": 287,
"open_issues": 18,
"closed_ratio": 0.935,
"closed_issues": 259,
"closed_unmerged_prs": 135
},
"bus_factor": 2,
"bot_contributors": 2,
"top_contributors": [
{
"type": "User",
"login": "sdebruyn",
"commits": 429,
"avatar_url": "https://avatars.githubusercontent.com/u/963413?v=4"
},
{
"type": "User",
"login": "dataders",
"commits": 271,
"avatar_url": "https://avatars.githubusercontent.com/u/8158673?v=4"
},
{
"type": "User",
"login": "mikaelene",
"commits": 147,
"avatar_url": "https://avatars.githubusercontent.com/u/13303653?v=4"
},
{
"type": "User",
"login": "axellpadilla",
"commits": 146,
"avatar_url": "https://avatars.githubusercontent.com/u/68310020?v=4"
},
{
"type": "User",
"login": "JCZuurmond",
"commits": 110,
"avatar_url": "https://avatars.githubusercontent.com/u/5946784?v=4"
},
{
"type": "User",
"login": "cody-scott",
"commits": 96,
"avatar_url": "https://avatars.githubusercontent.com/u/13374836?v=4"
},
{
"type": "User",
"login": "Benjamin-Knight",
"commits": 90,
"avatar_url": "https://avatars.githubusercontent.com/u/125356332?v=4"
},
{
"type": "User",
"login": "joshmarkovic",
"commits": 36,
"avatar_url": "https://avatars.githubusercontent.com/u/52184130?v=4"
},
{
"type": "User",
"login": "schlich",
"commits": 21,
"avatar_url": "https://avatars.githubusercontent.com/u/21191435?v=4"
},
{
"type": "User",
"login": "l-j",
"commits": 7,
"avatar_url": "https://avatars.githubusercontent.com/u/2611145?v=4"
}
],
"contributors_sampled": 34,
"top_contributor_share": 0.307
},
"quality_signals": {
"has_ci": true,
"has_tests": true,
"ci_workflows": [
"integration-tests-sqlserver.yml",
"publish-docker.yml",
"release-version.yml",
"unit-tests.yml"
],
"has_docs_dir": false,
"linter_configs": [],
"has_editorconfig": false,
"has_linter_config": true,
"has_precommit_config": true
},
"security_signals": {
"lockfiles": [
"uv.lock"
],
"scorecard": {
"checks": [
{
"name": "Binary-Artifacts",
"score": 10,
"reason": "no binaries found in the repo",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#binary-artifacts"
},
{
"name": "Branch-Protection",
"score": 1,
"reason": "branch protection is not maximal on development and all release branches",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
},
{
"name": "CI-Tests",
"score": 10,
"reason": "12 out of 12 merged PRs checked by a CI test -- score normalized to 10",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#ci-tests"
},
{
"name": "CII-Best-Practices",
"score": 0,
"reason": "no effort to earn an OpenSSF best practices badge detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#cii-best-practices"
},
{
"name": "Code-Review",
"score": 5,
"reason": "Found 6/12 approved changesets -- score normalized to 5",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
},
{
"name": "Contributors",
"score": 10,
"reason": "project has 10 contributing companies or organizations",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
},
{
"name": "Dangerous-Workflow",
"score": 10,
"reason": "no dangerous workflow patterns detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
},
{
"name": "Dependency-Update-Tool",
"score": 10,
"reason": "update tool detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dependency-update-tool"
},
{
"name": "Fuzzing",
"score": 0,
"reason": "project is not fuzzed",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#fuzzing"
},
{
"name": "License",
"score": 10,
"reason": "license file detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#license"
},
{
"name": "Maintained",
"score": 10,
"reason": "30 commit(s) and 17 issue activity found in the last 90 days -- score normalized to 10",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#maintained"
},
{
"name": "Packaging",
"score": 10,
"reason": "packaging workflow detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#packaging"
},
{
"name": "Pinned-Dependencies",
"score": 0,
"reason": "dependency not pinned by hash detected -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
},
{
"name": "SAST",
"score": 0,
"reason": "SAST tool is not run on all commits -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#sast"
},
{
"name": "Security-Policy",
"score": 0,
"reason": "security policy file not detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#security-policy"
},
{
"name": "Signed-Releases",
"score": null,
"reason": "no releases found",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#signed-releases"
},
{
"name": "Token-Permissions",
"score": 0,
"reason": "detected GitHub workflow tokens with excessive permissions",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
},
{
"name": "Vulnerabilities",
"score": 3,
"reason": "7 existing vulnerabilities detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
}
],
"commit": "d36d1bf634ff213eb480cb5e2e4578108f3d818a",
"ran_at": "2026-07-27T04:18:41Z",
"aggregate_score": 5.3,
"scorecard_version": "v5.5.0"
},
"has_codeql_workflow": false,
"has_security_policy": false,
"has_dependabot_config": true
},
"contribution_flow": {
"collected": true,
"ci_last_run_at": "2026-07-27T04:17:31Z",
"oldest_open_prs": [
{
"number": 435,
"created_at": "2023-08-17T20:05:53Z",
"last_comment_at": "2026-05-31T02:50:37Z",
"last_comment_author": "axellpadilla"
},
{
"number": 617,
"created_at": "2025-07-14T17:24:29Z",
"last_comment_at": "2025-07-14T17:29:42Z",
"last_comment_author": "LuisMunozVillarreal"
},
{
"number": 633,
"created_at": "2026-02-16T18:14:25Z",
"last_comment_at": "2026-04-13T06:41:33Z",
"last_comment_author": "komjera"
},
{
"number": 643,
"created_at": "2026-05-14T08:09:28Z",
"last_comment_at": "2026-05-14T08:20:24Z",
"last_comment_author": "Benjamin-Knight"
},
{
"number": 713,
"created_at": "2026-06-16T04:54:44Z",
"last_comment_at": "2026-07-15T18:51:22Z",
"last_comment_author": "joshmarkovic"
},
{
"number": 715,
"created_at": "2026-06-17T01:03:22Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 717,
"created_at": "2026-06-20T04:05:15Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 738,
"created_at": "2026-07-09T03:22:54Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 740,
"created_at": "2026-07-13T20:47:54Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 751,
"created_at": "2026-07-20T10:30:13Z",
"last_comment_at": "2026-07-25T08:51:45Z",
"last_comment_author": "mopthe"
},
{
"number": 756,
"created_at": "2026-07-23T03:53:58Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 768,
"created_at": "2026-07-27T03:59:29Z",
"last_comment_at": null,
"last_comment_author": null
}
],
"last_merged_pr_at": "2026-07-27T03:52:15Z",
"ci_last_conclusion": "SUCCESS",
"oldest_open_issues": [
{
"number": 91,
"created_at": "2021-01-26T18:39:53Z",
"last_comment_at": "2026-06-23T20:21:45Z",
"last_comment_author": "joshmarkovic"
},
{
"number": 166,
"created_at": "2021-10-14T18:27:00Z",
"last_comment_at": "2026-06-23T20:35:41Z",
"last_comment_author": "joshmarkovic"
},
{
"number": 247,
"created_at": "2022-06-05T16:41:38Z",
"last_comment_at": "2026-06-23T20:17:29Z",
"last_comment_author": "joshmarkovic"
},
{
"number": 398,
"created_at": "2023-05-21T20:43:35Z",
"last_comment_at": "2026-06-23T20:41:45Z",
"last_comment_author": "joshmarkovic"
},
{
"number": 409,
"created_at": "2023-05-27T18:09:14Z",
"last_comment_at": "2026-07-22T14:17:01Z",
"last_comment_author": "mopthe"
},
{
"number": 424,
"created_at": "2023-07-18T20:17:33Z",
"last_comment_at": "2023-08-17T19:22:16Z",
"last_comment_author": "raginjason"
},
{
"number": 426,
"created_at": "2023-07-19T04:34:35Z",
"last_comment_at": "2026-06-23T20:15:33Z",
"last_comment_author": "joshmarkovic"
},
{
"number": 507,
"created_at": "2024-07-01T13:02:22Z",
"last_comment_at": "2026-06-23T20:43:00Z",
"last_comment_author": "joshmarkovic"
},
{
"number": 562,
"created_at": "2024-09-20T16:18:52Z",
"last_comment_at": "2024-10-04T20:00:50Z",
"last_comment_author": "cody-scott"
},
{
"number": 578,
"created_at": "2024-11-01T15:51:34Z",
"last_comment_at": "2025-02-10T15:10:04Z",
"last_comment_author": "cody-scott"
},
{
"number": 579,
"created_at": "2024-11-13T09:21:10Z",
"last_comment_at": "2025-05-01T16:26:00Z",
"last_comment_author": "TWDickson"
},
{
"number": 599,
"created_at": "2025-02-21T20:00:49Z",
"last_comment_at": "2025-02-25T14:33:41Z",
"last_comment_author": "jb8628"
},
{
"number": 601,
"created_at": "2025-03-19T16:44:02Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 632,
"created_at": "2026-02-11T18:07:03Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 662,
"created_at": "2026-05-16T22:56:31Z",
"last_comment_at": "2026-05-17T09:31:27Z",
"last_comment_author": "mopthe"
},
{
"number": 703,
"created_at": "2026-06-09T06:59:17Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 712,
"created_at": "2026-06-15T16:40:52Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 764,
"created_at": "2026-07-26T21:49:01Z",
"last_comment_at": "2026-07-26T21:54:04Z",
"last_comment_author": "axellpadilla"
}
]
}
},
"config": {
"disabled_metrics": [],
"disabled_categories": [],
"disabled_components": {}
},
"source": {
"url": "https://github.com/dbt-msft/dbt-sqlserver",
"host": "github.com",
"name": "dbt-sqlserver",
"owner": "dbt-msft"
},
"metrics": {
"overall": {
"key": "overall",
"band": "good",
"name": "Overall health",
"note": null,
"notes": [],
"value": 74,
"inputs": {
"security": 62,
"vitality": 83,
"community": 71,
"governance": 74,
"engineering": 76
},
"components": []
},
"categories": [
{
"key": "vitality",
"band": "good",
"name": "Vitality",
"value": 83,
"weight": 0.22,
"metrics": [
{
"key": "development_activity",
"band": "good",
"name": "Development activity",
"note": null,
"notes": [],
"value": 77,
"inputs": {
"commits_last_year": 257,
"human_commit_share": 0.96,
"days_since_last_push": 0,
"active_weeks_last_year": 19
},
"components": [
{
"key": "push_recency",
"name": "Push recency",
"detail": "last push 0 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "push_recency",
"params": {
"days": 0
}
}
],
"max_points": 36
},
{
"key": "commit_cadence",
"name": "Commit cadence",
"detail": "19/52 weeks with commits",
"points": 13.2,
"status": "partial",
"details": [
{
"code": "commit_cadence_weeks",
"params": {
"weeks": 19
}
}
],
"max_points": 36
},
{
"key": "commit_volume",
"name": "Commit volume",
"detail": "257 commits in the last year",
"points": 18,
"status": "met",
"details": [
{
"code": "commits_last_year",
"params": {
"count": 257
}
}
],
"max_points": 18
},
{
"key": "openssf_scorecard_maintained",
"name": "OpenSSF Scorecard: Maintained",
"detail": "30 commit(s) and 17 issue activity found in the last 90 days -- score normalized to 10",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
},
{
"key": "release_discipline",
"band": "excellent",
"name": "Release discipline",
"note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"openssf_scorecard_signed_releases"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 92,
"inputs": {
"releases_count": 65,
"latest_release_tag": "v1.11.0rc1",
"releases_from_tags": false,
"days_since_latest_release": 0,
"mean_days_between_releases": 46.6
},
"components": [
{
"key": "ships_releases",
"name": "Ships releases",
"detail": "65 releases published",
"points": 27,
"status": "met",
"details": [
{
"code": "releases_published",
"params": {
"count": 65
}
}
],
"max_points": 27
},
{
"key": "release_recency",
"name": "Release recency",
"detail": "latest release 0 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "release_recency",
"params": {
"days": 0
}
}
],
"max_points": 36
},
{
"key": "release_cadence",
"name": "Release cadence",
"detail": "a release every ~46.6 days",
"points": 19.8,
"status": "partial",
"details": [
{
"code": "release_cadence",
"params": {
"gap": 46.6
}
}
],
"max_points": 27
},
{
"key": "openssf_scorecard_signed_releases",
"name": "OpenSSF Scorecard: Signed-Releases",
"detail": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 10
}
]
},
{
"key": "abandonment",
"band": "excellent",
"name": "Abandonment",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"cap": null,
"state": "maintained",
"guards": [],
"signals": [],
"red_flag": false,
"multiplier_pct": 100,
"declared_reason": null,
"unverified_reason": null,
"unanswered_open_prs": null,
"unanswered_open_issues": null,
"days_since_last_merged_pr": null,
"days_since_last_human_commit": 0,
"days_since_last_human_commit_is_floor": false
},
"components": [
{
"key": "project_is_still_maintained",
"name": "Project is still maintained",
"detail": "last human commit 0 days ago",
"points": 100,
"status": "met",
"details": [
{
"code": "abandonment_maintained",
"params": {
"days": 0
}
}
],
"max_points": 100
}
]
}
],
"description": "Is the project alive — is code being written and are releases shipping?"
},
{
"key": "community",
"band": "good",
"name": "Community & Adoption",
"value": 71,
"weight": 0.18,
"metrics": [
{
"key": "popularity",
"band": "moderate",
"name": "Popularity & adoption",
"note": null,
"notes": [],
"value": 61,
"inputs": {
"forks": 113,
"stars": 252,
"watchers": 9,
"growth_state": "unverified",
"growth_factor_pct": 100,
"growth_unverified_reason": "no_history"
},
"components": [
{
"key": "stars",
"name": "Stars",
"detail": "252 stars",
"points": 38.9,
"status": "partial",
"details": [
{
"code": "stars",
"params": {
"count": 252
}
}
],
"max_points": 60
},
{
"key": "forks",
"name": "Forks",
"detail": "113 forks",
"points": 17.1,
"status": "partial",
"details": [
{
"code": "forks",
"params": {
"count": 113
}
}
],
"max_points": 25
},
{
"key": "watchers",
"name": "Watchers",
"detail": "9 watchers",
"points": 5,
"status": "partial",
"details": [
{
"code": "watchers",
"params": {
"count": 9
}
}
],
"max_points": 15
}
]
},
{
"key": "community_health",
"band": "good",
"name": "Community health",
"note": null,
"notes": [],
"value": 70,
"inputs": {
"has_readme": true,
"has_license": true,
"has_contributing": true,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": false
},
"components": [
{
"key": "readme",
"name": "README",
"detail": null,
"points": 22.5,
"status": "met",
"details": [],
"max_points": 22.5
},
{
"key": "license",
"name": "License",
"detail": "recognized license (MIT)",
"points": 22.5,
"status": "met",
"details": [
{
"code": "license_standard",
"params": {}
},
{
"code": "license_spdx",
"params": {
"spdx": "MIT"
}
}
],
"max_points": 22.5
},
{
"key": "contributing_guide",
"name": "CONTRIBUTING guide",
"detail": null,
"points": 18,
"status": "met",
"details": [],
"max_points": 18
},
{
"key": "code_of_conduct",
"name": "Code of conduct",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 13.5
},
{
"key": "issue_template",
"name": "Issue template",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.2
},
{
"key": "pr_template",
"name": "PR template",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 6.3
}
]
},
{
"key": "ecosystem_adoption",
"band": "excellent",
"name": "Ecosystem adoption (downloads)",
"note": "Excluded from scoring (no data or not applicable): Registry dependents. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"registry_dependents"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 87,
"inputs": {
"packages": [
"dbt-sqlserver"
],
"dependents": null,
"ecosystems": "pypi",
"total_downloads": null,
"monthly_downloads": 172366
},
"components": [
{
"key": "monthly_downloads",
"name": "Monthly downloads",
"detail": "172,366 downloads/month across pypi",
"points": 69.8,
"status": "partial",
"details": [
{
"code": "downloads_monthly",
"params": {
"count": 172366,
"ecosystems": "pypi"
}
}
],
"max_points": 80
},
{
"key": "registry_dependents",
"name": "Registry dependents",
"detail": "not reported by this ecosystem",
"points": 0,
"status": "excluded",
"details": [
{
"code": "not_reported_by_this_ecosystem",
"params": {}
}
],
"max_points": 20
}
]
}
],
"description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
},
{
"key": "governance",
"band": "good",
"name": "Sustainability & Governance",
"value": 74,
"weight": 0.24,
"metrics": [
{
"key": "maintainer_resilience",
"band": "moderate",
"name": "Maintainer resilience (bus factor)",
"note": null,
"notes": [],
"value": 64,
"inputs": {
"bus_factor": 2,
"contributors_sampled": 34,
"top_contributor_share": 0.307
},
"components": [
{
"key": "bus_factor",
"name": "Bus factor",
"detail": "2 contributor(s) cover half of all commits",
"points": 25.2,
"status": "partial",
"details": [
{
"code": "bus_factor",
"params": {
"count": 2
}
}
],
"max_points": 54
},
{
"key": "commit_distribution",
"name": "Commit distribution",
"detail": "top contributor authored 31% of commits",
"points": 15.6,
"status": "partial",
"details": [
{
"code": "top_contributor_share",
"params": {
"share": 31
}
}
],
"max_points": 22.5
},
{
"key": "contributor_breadth",
"name": "Contributor breadth",
"detail": "34 contributors",
"points": 13.5,
"status": "met",
"details": [
{
"code": "contributors_sampled",
"params": {
"count": 34
}
}
],
"max_points": 13.5
},
{
"key": "openssf_scorecard_contributors",
"name": "OpenSSF Scorecard: Contributors",
"detail": "project has 10 contributing companies or organizations",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
},
{
"key": "responsiveness",
"band": "good",
"name": "Issue & PR responsiveness",
"note": null,
"notes": [],
"value": 77,
"inputs": {
"merged_prs": 287,
"open_issues": 18,
"closed_issues": 259,
"issue_closed_ratio": 0.935,
"closed_unmerged_prs": 135
},
"components": [
{
"key": "issue_resolution",
"name": "Issue resolution",
"detail": "94% of issues closed",
"points": 43.7,
"status": "partial",
"details": [
{
"code": "issues_closed_share",
"params": {
"share": 94
}
}
],
"max_points": 46.75
},
{
"key": "pr_acceptance",
"name": "PR acceptance",
"detail": "287/422 decided PRs merged",
"points": 26,
"status": "partial",
"details": [
{
"code": "decided_prs_merged",
"params": {
"merged": 287,
"decided": 422
}
}
],
"max_points": 38.25
},
{
"key": "openssf_scorecard_code_review",
"name": "OpenSSF Scorecard: Code-Review",
"detail": "Found 6/12 approved changesets -- score normalized to 5",
"points": 7.5,
"status": "partial",
"details": [],
"max_points": 15
}
]
},
{
"key": "stewardship",
"band": "moderate",
"name": "Ownership & stewardship",
"note": null,
"notes": [],
"value": 61,
"inputs": {
"followers": 47,
"owner_type": "Organization",
"is_verified": null,
"owner_login": "dbt-msft",
"public_repos": 9,
"account_age_days": 2092
},
"components": [
{
"key": "ownership_backing",
"name": "Ownership backing",
"detail": "organization-owned",
"points": 30,
"status": "met",
"details": [
{
"code": "owner_organization",
"params": {}
}
],
"max_points": 30
},
{
"key": "verified_domain",
"name": "Verified domain",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 20
},
{
"key": "owner_reach",
"name": "Owner reach",
"detail": "47 followers of dbt-msft",
"points": 12.1,
"status": "partial",
"details": [
{
"code": "owner_followers",
"params": {
"count": 47,
"login": "dbt-msft"
}
}
],
"max_points": 25
},
{
"key": "track_record",
"name": "Track record",
"detail": "9 public repos, account ~5 yr old",
"points": 18.7,
"status": "partial",
"details": [
{
"code": "public_repos",
"params": {
"count": 9
}
},
{
"code": "account_age_years",
"params": {
"years": 5
}
}
],
"max_points": 25
}
]
},
{
"key": "package_maintenance",
"band": "excellent",
"name": "Package maintenance",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"packages": [
"dbt-sqlserver"
],
"ecosystems": "pypi",
"any_deprecated": false,
"min_days_since_publish": 4
},
"components": [
{
"key": "published_resolvable",
"name": "Published & resolvable",
"detail": "1 package(s) on pypi",
"points": 25,
"status": "met",
"details": [
{
"code": "packages_published",
"params": {
"count": 1,
"ecosystems": "pypi"
}
}
],
"max_points": 25
},
{
"key": "publish_recency",
"name": "Publish recency",
"detail": "latest publish 4 days ago",
"points": 35,
"status": "met",
"details": [
{
"code": "publish_recency",
"params": {
"days": 4
}
}
],
"max_points": 35
},
{
"key": "version_history",
"name": "Version history",
"detail": "71 published versions",
"points": 20,
"status": "met",
"details": [
{
"code": "published_versions",
"params": {
"count": 71
}
}
],
"max_points": 20
},
{
"key": "not_deprecated",
"name": "Not deprecated",
"detail": "active, not deprecated or yanked",
"points": 20,
"status": "met",
"details": [
{
"code": "package_not_deprecated",
"params": {}
}
],
"max_points": 20
}
]
}
],
"description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
},
{
"key": "engineering",
"band": "good",
"name": "Engineering Quality",
"value": 76,
"weight": 0.2,
"metrics": [
{
"key": "engineering_practices",
"band": "excellent",
"name": "Engineering practices",
"note": null,
"notes": [],
"value": 94,
"inputs": {
"has_ci": true,
"has_tests": true,
"has_editorconfig": false,
"has_linter_config": true,
"has_precommit_config": true
},
"components": [
{
"key": "ci_workflows",
"name": "CI workflows",
"detail": "4 workflow(s)",
"points": 24,
"status": "met",
"details": [
{
"code": "ci_workflows",
"params": {
"count": 4
}
}
],
"max_points": 24
},
{
"key": "tests_present",
"name": "Tests present",
"detail": null,
"points": 24,
"status": "met",
"details": [],
"max_points": 24
},
{
"key": "linter_config",
"name": "Linter config",
"detail": null,
"points": 16,
"status": "met",
"details": [],
"max_points": 16
},
{
"key": "pre_commit_hooks",
"name": "Pre-commit hooks",
"detail": null,
"points": 9.6,
"status": "met",
"details": [],
"max_points": 9.6
},
{
"key": "editorconfig",
"name": ".editorconfig",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 6.4
},
{
"key": "openssf_scorecard_ci_tests",
"name": "OpenSSF Scorecard: CI-Tests",
"detail": "12 out of 12 merged PRs checked by a CI test -- score normalized to 10",
"points": 20,
"status": "met",
"details": [],
"max_points": 20
}
]
},
{
"key": "documentation",
"band": "moderate",
"name": "Documentation",
"note": null,
"notes": [],
"value": 50,
"inputs": {
"topics": [
"dbt-sqlserver",
"sql-server",
"azure-sql",
"azure-sql-db",
"transact-sql",
"tsql",
"microsoft",
"microsoft-sql-server",
"dbt",
"mssql",
"t-sql",
"data-engineering",
"analytics-engineering",
"sql"
],
"has_wiki": false,
"homepage": null,
"has_readme": true,
"has_docs_dir": false,
"has_description": true
},
"components": [
{
"key": "readme",
"name": "README",
"detail": null,
"points": 30,
"status": "met",
"details": [],
"max_points": 30
},
{
"key": "documentation_directory",
"name": "Documentation directory",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 25
},
{
"key": "documentation_homepage_site",
"name": "Documentation / homepage site",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
},
{
"key": "repository_description",
"name": "Repository description",
"detail": null,
"points": 10,
"status": "met",
"details": [],
"max_points": 10
},
{
"key": "topics",
"name": "Topics",
"detail": "14 topics",
"points": 10,
"status": "met",
"details": [
{
"code": "topics_count",
"params": {
"count": 14
}
}
],
"max_points": 10
},
{
"key": "wiki",
"name": "Wiki",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
}
],
"description": "Are baseline engineering and documentation practices in place?"
},
{
"key": "security",
"band": "moderate",
"name": "Security",
"value": 62,
"weight": 0.16,
"metrics": [
{
"key": "security_posture",
"band": "moderate",
"name": "Security posture",
"note": "Excluded from scoring (no data or not applicable): Signed-Releases. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"signed_releases"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 53,
"inputs": {
"source": "openssf_scorecard",
"checks_evaluated": 17,
"scorecard_version": "v5.5.0",
"checks_inconclusive": 1,
"scorecard_aggregate": 5.3
},
"components": [
{
"key": "binary_artifacts",
"name": "Binary-Artifacts",
"detail": "no binaries found in the repo",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
},
{
"key": "branch_protection",
"name": "Branch-Protection",
"detail": "branch protection is not maximal on development and all release branches",
"points": 0.8,
"status": "partial",
"details": [],
"max_points": 7.5
},
{
"key": "ci_tests",
"name": "CI-Tests",
"detail": "12 out of 12 merged PRs checked by a CI test -- score normalized to 10",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "cii_best_practices",
"name": "CII-Best-Practices",
"detail": "no effort to earn an OpenSSF best practices badge detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 2.5
},
{
"key": "code_review",
"name": "Code-Review",
"detail": "Found 6/12 approved changesets -- score normalized to 5",
"points": 3.8,
"status": "partial",
"details": [],
"max_points": 7.5
},
{
"key": "contributors",
"name": "Contributors",
"detail": "project has 10 contributing companies or organizations",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "dangerous_workflow",
"name": "Dangerous-Workflow",
"detail": "no dangerous workflow patterns detected",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
},
{
"key": "dependency_update_tool",
"name": "Dependency-Update-Tool",
"detail": "update tool detected",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
},
{
"key": "fuzzing",
"name": "Fuzzing",
"detail": "project is not fuzzed",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "license",
"name": "License",
"detail": "license file detected",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "maintained",
"name": "Maintained",
"detail": "30 commit(s) and 17 issue activity found in the last 90 days -- score normalized to 10",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
},
{
"key": "packaging",
"name": "Packaging",
"detail": "packaging workflow detected",
"points": 5,
"status": "met",
"details": [],
"max_points": 5
},
{
"key": "pinned_dependencies",
"name": "Pinned-Dependencies",
"detail": "dependency not pinned by hash detected -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "sast",
"name": "SAST",
"detail": "SAST tool is not run on all commits -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "security_policy",
"name": "Security-Policy",
"detail": "security policy file not detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "signed_releases",
"name": "Signed-Releases",
"detail": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 7.5
},
{
"key": "token_permissions",
"name": "Token-Permissions",
"detail": "detected GitHub workflow tokens with excessive permissions",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "vulnerabilities",
"name": "Vulnerabilities",
"detail": "7 existing vulnerabilities detected",
"points": 2.2,
"status": "partial",
"details": [],
"max_points": 7.5
}
]
},
{
"key": "dependency_advisories",
"band": "excellent",
"name": "Dependency advisories",
"note": "Excluded from scoring (no data or not applicable): No advisories left outstanding. Remaining weights renormalized. Matched the pypi:dbt-sqlserver@1.10.1 runtime dependency closure — what installing the published package pulls in — 57 packages. Reachability is not analyzed.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"no_advisories_left_outstanding"
]
}
},
{
"code": "weights_renormalized",
"params": {}
},
{
"code": "advisories_scope_published",
"params": {
"package": "pypi:dbt-sqlserver@1.10.1",
"assessed": 57
}
},
{
"code": "advisories_reachability",
"params": {}
}
],
"value": 100,
"inputs": {
"source": "osv",
"advisories": 0,
"affected_packages": 0,
"assessed_packages": 57,
"unassessed_packages": 0,
"affected_by_severity": "none",
"direct_affected_packages": 0
},
"components": [
{
"key": "direct_dependencies_free_of_known_advisories",
"name": "Direct dependencies free of known advisories",
"detail": "no direct dependency carries a known advisory",
"points": 35,
"status": "met",
"details": [
{
"code": "no_direct_advisories",
"params": {}
}
],
"max_points": 35
},
{
"key": "indirect_dependencies_free_of_known_advisories",
"name": "Indirect dependencies free of known advisories",
"detail": "no indirect dependency carries a known advisory",
"points": 25,
"status": "met",
"details": [
{
"code": "no_indirect_advisories",
"params": {}
}
],
"max_points": 25
},
{
"key": "no_advisories_left_outstanding",
"name": "No advisories left outstanding",
"detail": "no advisory carries a publication date",
"points": 0,
"status": "excluded",
"details": [
{
"code": "advisories_no_publication_date",
"params": {}
}
],
"max_points": 40
}
]
},
{
"key": "malicious_dependencies",
"band": "excellent",
"name": "Malicious dependencies",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"source": "osv",
"meaning": "reported as a malicious package by the OpenSSF corpus; the remedy is removal or moving off the compromised name, never an upgrade of the same artifact. Versions the registry has since pulled are listed but not scored",
"packages": [],
"red_flag": false,
"assessed_packages": 57,
"malicious_packages": 0,
"direct_malicious_packages": 0,
"withdrawn_malicious_packages": 0,
"installable_malicious_packages": 0
},
"components": [
{
"key": "no_dependency_reported_as_a_malicious_package",
"name": "No dependency reported as a malicious package",
"detail": "no dependency is reported as a malicious package",
"points": 100,
"status": "met",
"details": [
{
"code": "no_malicious_dependencies",
"params": {}
}
],
"max_points": 100
}
]
},
{
"key": "high_risk_jurisdiction_exposure",
"band": "excellent",
"name": "High-Risk Jurisdiction Exposure",
"note": "Only high-confidence self-published location evidence affects this multiplier. Ambiguous matches are review-only; country evidence is not proof of nationality, citizenship, legal registration, malicious intent, or sanctions status.",
"notes": [
{
"code": "jurisdiction_evidence_limits",
"params": {}
}
],
"value": 100,
"inputs": {
"meaning": "self-published location evidence; not nationality or citizenship",
"red_flag": false,
"exposures": [],
"policy_countries": [
"Russia",
"Iran",
"North Korea"
],
"review_only_matches": 0,
"assessed_self_published_locations": 8
},
"components": [
{
"key": "policy_exposure_multiplier",
"name": "Policy exposure multiplier",
"detail": "no confirmed policy-scope location match",
"points": 100,
"status": "met",
"details": [
{
"code": "jurisdiction_no_match",
"params": {}
}
],
"max_points": 100
}
]
}
],
"description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
},
{
"key": "ai_readiness",
"band": "good",
"name": "AI Readiness",
"value": 71,
"weight": 0,
"metrics": [
{
"key": "ai_agent_context",
"band": "at_risk",
"name": "Agent context & guidance",
"note": null,
"notes": [],
"value": 40,
"inputs": {
"has_llms_txt": false,
"legible_history_share": 0.833,
"agent_instruction_files": [],
"agent_instruction_max_bytes": null
},
"components": [
{
"key": "agent_instructions",
"name": "Agent instructions",
"detail": "no CLAUDE.md / AGENTS.md / editor rules",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_agent_instructions",
"params": {}
}
],
"max_points": 45
},
{
"key": "machine_readable_docs_llms_txt",
"name": "Machine-readable docs (llms.txt)",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
},
{
"key": "legible_commit_history",
"name": "Legible commit history",
"detail": "80 of 96 human commits state their intent (structured subject or explanatory body)",
"points": 40,
"status": "met",
"details": [
{
"code": "legible_history",
"params": {
"legible": 80,
"sampled": 96
}
}
],
"max_points": 40
}
]
},
{
"key": "ai_verify_loop",
"band": "excellent",
"name": "Verify loop (build / test / typecheck)",
"note": null,
"notes": [],
"value": 90,
"inputs": {
"has_nix": false,
"has_tests": true,
"lockfiles": [
"uv.lock"
],
"has_dockerfile": true,
"typed_language": false,
"bootstrap_files": [
"Makefile"
],
"has_devcontainer": true,
"has_linter_config": true,
"typecheck_configs": [
"dbt/adapters/sqlserver/py.typed"
],
"agent_commit_share": 0.25,
"toolchain_manifests": [],
"dependency_bot_commit_share": 0.01
},
"components": [
{
"key": "one_command_bootstrap",
"name": "One-command bootstrap",
"detail": "Makefile",
"points": 18,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "Makefile"
}
}
],
"max_points": 18
},
{
"key": "automated_tests",
"name": "Automated tests",
"detail": null,
"points": 22,
"status": "met",
"details": [],
"max_points": 22
},
{
"key": "lint_format_config",
"name": "Lint / format config",
"detail": null,
"points": 11,
"status": "met",
"details": [],
"max_points": 11
},
{
"key": "static_type_checking",
"name": "Static type checking",
"detail": "dbt/adapters/sqlserver/py.typed",
"points": 11,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "dbt/adapters/sqlserver/py.typed"
}
}
],
"max_points": 11
},
{
"key": "reproducible_environment",
"name": "Reproducible environment",
"detail": "devcontainer, Dockerfile, lockfile",
"points": 10,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "devcontainer, Dockerfile, lockfile"
}
}
],
"max_points": 10
},
{
"key": "demonstrated_agent_practice",
"name": "Demonstrated agent practice",
"detail": "25 of the last 100 commits agent-authored or agent-credited",
"points": 10,
"status": "met",
"details": [
{
"code": "agent_authored_commits",
"params": {
"count": 25,
"sampled": 100
}
}
],
"max_points": 10
},
{
"key": "automated_maintenance",
"name": "Automated maintenance",
"detail": "1 of the last 100 commits are automated dependency updates",
"points": 8,
"status": "met",
"details": [
{
"code": "dependency_bot_commits",
"params": {
"count": 1,
"sampled": 100
}
}
],
"max_points": 8
},
{
"key": "openssf_scorecard_pinned_dependencies",
"name": "OpenSSF Scorecard: Pinned-Dependencies",
"detail": "dependency not pinned by hash detected -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
},
{
"key": "ai_code_legibility",
"band": "good",
"name": "Code legibility for models",
"note": null,
"notes": [],
"value": 81,
"inputs": {
"primary_language": "Python",
"largest_source_bytes": 67873,
"source_files_sampled": 99,
"oversized_source_files": 1
},
"components": [
{
"key": "type_checkable_code",
"name": "Type-checkable code",
"detail": "Python with type-check config (dbt/adapters/sqlserver/py.typed)",
"points": 27,
"status": "partial",
"details": [
{
"code": "typecheck_config_language",
"params": {
"files": "dbt/adapters/sqlserver/py.typed",
"language": "Python"
}
}
],
"max_points": 45
},
{
"key": "manageable_file_sizes",
"name": "Manageable file sizes",
"detail": "1/99 source files over 60KB",
"points": 54.4,
"status": "partial",
"details": [
{
"code": "oversized_source_files",
"params": {
"kb": 60,
"sampled": 99,
"oversized": 1
}
}
],
"max_points": 55
}
]
}
],
"description": "How well is the repo equipped to be developed and maintained with AI coding agents? An independent, experimental badge — weight 0.0, so it is surfaced on its own and does not affect the overall health score."
}
],
"metrics_version": "1.13.0"
},
"warnings": [
"Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token"
],
"report_type": "repository",
"generated_at": "2026-07-27T04:19:08.731693Z",
"schema_version": "0.27.0",
"badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/d/dbt-msft/dbt-sqlserver.svg",
"full_name": "dbt-msft/dbt-sqlserver",
"license_state": "standard",
"license_spdx": "MIT"
}