Public record
Software health reportschema 0.27.0 · metrics 1.13.0 · 2026-07-29 17:15 UTC

GoogleCloudPlatform / professional-services-data-validator

Utility to compare data between homogeneous or heterogeneous environments to ensure source and target tables match

PythonApache-2.0★ 516 stars⑂ 166 forkssince Apr 2020View on GitHub ↗

GoogleCloudPlatform/professional-services-data-validator holds a health index of 80 out of 100, placing it in the Good band. It scores highest on Vitality (94/100) and lowest on AI Readiness (50/100). It was last updated today. 2 contributors account for most of its recent work.

80
overall / 100
Good

Software health index

Metrics are grouped into weighted categories on one standardized 1–100 scale. Overall starts as their weighted mean; when public evidence triggers the High-Risk Jurisdiction Policy, the rating is adjusted and receives an At risk ceiling of 49. AI Readiness sits outside the overall score.

80
Excellent85-100Exemplary; meets essentially all checked criteria
Good70-84Healthy; minor gaps
Moderate50-69Acceptable with notable gaps; review recommended
At risk30-49Significant weaknesses; adoption warrants caution
Critical1-29Severe problems (abandoned, single-maintainer, no hygiene)
VitalityCommunity &AdoptionSustainability &GovernanceEngineeringQualitySecurityAI Readiness

Score profile

Each axis is a category. The shape matters more than the average — a healthy subject fills the whole shape, while a spike-and-crater profile means strength in one dimension is masking risk in another.

Ownership

21,384 followers1,498 public repossince Nov 2012

This repository is backed by an organization — shared, accountable stewardship that can outlive any single maintainer.

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publish
PyPIgoogle-pso-data-validator8.8.210,612621 day ago

Metrics by category

Vitality

Is the project alive — is code being written and are releases shipping?

94Excellent · 22% of overall
How it's scored
36/36Push recency — last push 0 days ago
26.3/36Commit cadence — 38/52 weeks with commits
18/18Commit volume — 103 commits in the last year
10/10OpenSSF Scorecard: Maintained — 26 commit(s) and 25 issue activity found in the last 90 days -- score normalized to 10
Inputs used
commits_last_year103
human_commit_share0.86
days_since_last_push0
active_weeks_last_year38

Release discipline

100Excellent
How it's scored
27/27Ships releases — 70 releases published
36/36Release recency — latest release 1 days ago
27/27Release cadence — a release every ~21.8 days
0/10OpenSSF Scorecard: Signed-Releases — no data
Inputs used
releases_count70
latest_release_tagv8.8.2
releases_from_tagsno
days_since_latest_release1
mean_days_between_releases21.8
Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.

Community & Adoption

Does the project have users, downloads, attention, and a welcoming setup for contributors?

78Good · 18% of overall
How it's scored
44/60Stars — 516 stars
18.5/25Forks — 166 forks
9/15Watchers — 42 watchers
Inputs used
forks166
stars516
watchers42
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history

Community health

92Excellent
How it's scored
22.5/22.5README
22.5/22.5License — recognized license (Apache-2.0)
18/18CONTRIBUTING guide
13.5/13.5Code of conduct
0/7.2Issue template
6.3/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
has_contributingyes
has_issue_templateno
has_code_of_conductyes
has_pull_request_templateyes
How it's scored
53.7/80Monthly downloads — 10,612 downloads/month across pypi
0/20Registry dependents — not reported by this ecosystem
Inputs used
packagesgoogle-pso-data-validator
dependents
ecosystemspypi
total_downloads
monthly_downloads10,612
Excluded from scoring (no data or not applicable): Registry dependents. Remaining weights renormalized.

Sustainability & Governance

Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?

81Good · 24% of overall
How it's scored
25.2/54Bus factor — 2 contributor(s) cover half of all commits
13.1/22.5Commit distribution — top contributor authored 42% of commits
13.5/13.5Contributor breadth — 56 contributors
10/10OpenSSF Scorecard: Contributors — project has 7 contributing companies or organizations
Inputs used
bus_factor2
contributors_sampled56
top_contributor_share0.417
How it's scored
39.9/46.8Issue resolution — 85% of issues closed
33.9/38.3PR acceptance — 723/816 decided PRs merged
15/15OpenSSF Scorecard: Code-Review — all changesets reviewed
Inputs used
merged_prs723
open_issues142
closed_issues825
issue_closed_ratio0.853
closed_unmerged_prs93
How it's scored
30/30Ownership backing — organization-owned
0/20Verified domain
25/25Owner reach — 21,384 followers of GoogleCloudPlatform
25/25Track record — 1,498 public repos, account ~13 yr old
Inputs used
followers21,384
owner_typeOrganization
is_verified
owner_loginGoogleCloudPlatform
public_repos1,498
account_age_days5,003
How it's scored
25/25Published & resolvable — 1 package(s) on pypi
35/35Publish recency — latest publish 1 days ago
20/20Version history — 62 published versions
20/20Not deprecated — active, not deprecated or yanked
Inputs used
packagesgoogle-pso-data-validator
ecosystemspypi
any_deprecatedno
min_days_since_publish1

Engineering Quality

Are baseline engineering and documentation practices in place?

66Moderate · 20% of overall
How it's scored
0/24CI workflows
24/24Tests present
16/16Linter config — .flake8
0/9.6Pre-commit hooks
0/6.4.editorconfig
20/20OpenSSF Scorecard: CI-Tests — 30 out of 30 merged PRs checked by a CI test -- score normalized to 10
Inputs used
has_cino
has_testsyes
has_editorconfigno
has_linter_configyes
has_precommit_configno
How it's scored
30/30README
25/25Documentation directory
0/15Documentation / homepage site
10/10Repository description
0/10Topics
10/10Wiki
Inputs used
topics
has_wikiyes
homepage
has_readmeyes
has_docs_diryes
has_descriptionyes

Security

Are visible security and supply-chain practices strong, without unresolved high-risk jurisdiction exposure?

77Good · 16% of overall
How it's scored
7.5/7.5Binary-Artifacts — no binaries found in the repo
0/7.5Branch-Protection — no data
2.5/2.5CI-Tests — 30 out of 30 merged PRs checked by a CI test -- score normalized to 10
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
7.5/7.5Code-Review — all changesets reviewed
2.5/2.5Contributors — project has 7 contributing companies or organizations
0/10Dangerous-Workflow — no data
7.5/7.5Dependency-Update-Tool — update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5License — license file detected
7.5/7.5Maintained — 26 commit(s) and 25 issue activity found in the last 90 days -- score normalized to 10
0/5Packaging — no data
0/5Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
4.5/5SAST — SAST tool is not run on all commits -- score normalized to 9
5/5Security-Policy — security policy file detected
0/7.5Signed-Releases — no data
0/7.5Token-Permissions — no data
6.8/7.5Vulnerabilities — 1 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated13
scorecard_versionv5.5.0
checks_inconclusive5
scorecard_aggregate8
Excluded from scoring (no data or not applicable): branch_protection, dangerous_workflow, packaging, signed_releases, token_permissions. Remaining weights renormalized.
How it's scored
7/35Direct dependencies free of known advisories — 1 affected: ibis-framework 5.1.0 (critical)
25/25Indirect dependencies free of known advisories — no indirect dependency carries a known advisory
32/40No advisories left outstanding — 1 advisory-carrying package(s) unaddressed past 90 days; oldest published 984 days ago
Inputs used
sourceosv
advisories1
affected_packages1
assessed_packages88
unassessed_packages0
affected_by_severitycritical 1
direct_affected_packages1
Matched the pypi:google-pso-data-validator@8.8.2 runtime dependency closure — what installing the published package pulls in — 88 packages. Reachability is not analyzed.

AI Readiness

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.

50Moderate · 0% of overall
How it's scored
0/45Agent instructions — no CLAUDE.md / AGENTS.md / editor rules
0/15Machine-readable docs (llms.txt)
40/40Legible commit history — 86 of 86 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtno
legible_history_share1
agent_instruction_files
agent_instruction_max_bytes
How it's scored
18/18One-command bootstrap — noxfile.py
22/22Automated tests
11/11Lint / format config — .flake8
0/11Static type checking
10/10Reproducible environment — Dockerfile
0/10Demonstrated agent practice — no agent-authored commits among the last 100
0/8Automated maintenance — no automated dependency updates observed
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Inputs used
has_nixno
has_testsyes
lockfiles
has_dockerfileyes
typed_languageno
bootstrap_filesnoxfile.py
has_devcontainerno
has_linter_configyes
typecheck_configs
agent_commit_share0
toolchain_manifests
dependency_bot_commit_share0
How it's scored
0/45Type-checkable code — Python without a type-check config
52.9/55Manageable file sizes — 4/105 source files over 60KB
Inputs used
primary_languagePython
largest_source_bytes69,773
source_files_sampled105
oversized_source_files4
How it's scored
0/40API schema (OpenAPI/GraphQL/proto)
0/20MCP server
40/40Runnable examples — samples
Inputs used
example_dirssamples
has_mcp_signalno
api_schema_files

Key facts

516GitHub stars
56contributors
103commits, last 12 months
0days since last push
70releases
2bus factor
142open issues
PyPIpackage ecosystems

Data collection warnings

  • Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token

More detail

Star and fork history 0 ★ / 166 ⇿
0Stars
166Forks
62Releases

When each star and fork was added, collected from GitHub and bucketed by day. Cumulative growth sits directly above the daily additions it is made of, so the two read against each other: steady organic accretion looks nothing like an abrupt, short-lived burst. Where that difference is measurable, it is reported as growth authenticity.

0408012016020016442021-062024-012026-07
Major 7Minor 41Patch 14

Each point covers 5 days.

OpenSSF Scorecard 8.0 / 10
8.0aggregate

Independent, tool-agnostic security assessment from the open-source OpenSSF Scorecard. Each check rewards a security practice, not a specific vendor's tool. Checks Scorecard could not determine are marked n/a and excluded from the security score (never counted as zero).Scorecard v5.5.0 · 2026-07-29 17:15 UTC

10Binary-Artifactsno binaries found in the repo
n/aBranch-Protectioninternal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md
10CI-Tests30 out of 30 merged PRs checked by a CI test -- score normalized to 10
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
10Code-Reviewall changesets reviewed
10Contributorsproject has 7 contributing companies or organizations
n/aDangerous-Workflowno workflows found
10Dependency-Update-Toolupdate tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
10Maintained26 commit(s) and 25 issue activity found in the last 90 days -- score normalized to 10
n/aPackagingpackaging workflow not detected
0Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 0
9SASTSAST tool is not run on all commits -- score normalized to 9
10Security-Policysecurity policy file detected
n/aSigned-Releasesno releases found
n/aToken-PermissionsNo tokens found
9Vulnerabilities1 existing vulnerabilities detected
All dependencies 32

Full resolved dependency set from the GitHub dependency graph: 0 direct and 32 indirect (transitive) packages. The transitive closure is complete when the repository commits a lockfile.

RegistryPackageVersionRelation
PyPI0indirect
PyPI1indirect
PyPI3indirect
PyPIblack26.5.1indirect
PyPIflake8indirect
PyPIflaskindirect
PyPIfreezegunindirect
PyPIfsspecindirect
PyPIgoogle-api-python-clientindirect
PyPIgoogle-cloud-bigqueryindirect
PyPIgoogle-cloud-bigquery-storageindirect
PyPIgoogle-cloud-secret-managerindirect
PyPIgoogle-cloud-spannerindirect
PyPIgoogle-cloud-storageindirect
PyPIgoogle-pso-data-validatorindirect
PyPIibis-framework7.1.0indirect
PyPIimpylaindirect
PyPIjellyfishindirect
PyPIpandasindirect
PyPIparsyindirect
PyPIpsycopg2-binaryindirect
PyPIpyarrowindirect
PyPIpydata-google-authindirect
PyPIpyfakefsindirect
PyPIpymysqlindirect
PyPIpytestindirect
PyPIpytest-covindirect
PyPIpytest-rerunfailuresindirect
PyPIpytest-timeoutindirect
PyPIpyyamlindirect
PyPIsqlalchemyindirect
PyPItabulateindirect
Dependency advisories 1

Installing pypi:google-pso-data-validator@8.8.2 pulls in 88 packages, direct and transitive: 1 carry known advisories, of which 1 are direct dependencies.

PackageVersionRelationSeverityAdvisoriesFixed in
ibis-framework5.1.0directcritical17.1.0

An advisory means the version recorded in the dependency graph falls inside an advisory’s affected range. Reachability is not analysed, and the graph includes development and test pins — a finding may concern tooling rather than shipped software.

Raw JSON report machine-readable
{
  "data": {
    "repo": {
      "topics": [],
      "is_fork": false,
      "size_kb": 3655,
      "has_wiki": true,
      "homepage": null,
      "languages": {
        "HCL": 2694,
        "TSQL": 55894,
        "Shell": 7332,
        "Python": 1255126
      },
      "pushed_at": "2026-07-29T17:13:08Z",
      "created_at": "2020-04-10T21:18:19Z",
      "owner_type": "Organization",
      "updated_at": "2026-07-28T20:03:26Z",
      "description": "Utility to compare data between homogeneous or heterogeneous environments to ensure source and target tables match",
      "is_archived": false,
      "is_disabled": false,
      "license_spdx": "Apache-2.0",
      "default_branch": "develop",
      "license_spdx_raw": "Apache-2.0",
      "primary_language": "Python",
      "significant_languages": [
        "Python"
      ]
    },
    "owner": {
      "blog": "https://cloud.google.com",
      "name": "Google Cloud Platform",
      "type": "Organization",
      "login": "GoogleCloudPlatform",
      "company": null,
      "location": null,
      "followers": 21384,
      "avatar_url": "https://avatars.githubusercontent.com/u/2810941?v=4",
      "created_at": "2012-11-16T04:52:17Z",
      "is_verified": null,
      "public_repos": 1498,
      "account_age_days": 5003
    },
    "license": {
      "state": "standard",
      "spdx_id": "Apache-2.0",
      "raw_spdx": "Apache-2.0",
      "file_present": true,
      "scorecard_found": true,
      "profile_has_license": true
    },
    "activity": {
      "releases": [
        {
          "tag": "v8.8.2",
          "kind": "patch",
          "published_at": "2026-07-28T11:13:44Z"
        },
        {
          "tag": "v8.8.1",
          "kind": "patch",
          "published_at": "2026-07-20T09:45:37Z"
        },
        {
          "tag": "v8.8.0",
          "kind": "minor",
          "published_at": "2026-06-18T12:51:05Z"
        },
        {
          "tag": "v8.7.1",
          "kind": "patch",
          "published_at": "2026-05-22T09:07:05Z"
        },
        {
          "tag": "v8.7.0",
          "kind": "minor",
          "published_at": "2026-04-20T15:07:46Z"
        },
        {
          "tag": "v8.6.0",
          "kind": "minor",
          "published_at": "2026-04-13T19:50:34Z"
        },
        {
          "tag": "v8.5.2",
          "kind": "patch",
          "published_at": "2026-02-26T17:34:50Z"
        },
        {
          "tag": "v8.5.1",
          "kind": "patch",
          "published_at": "2026-02-24T16:02:09Z"
        },
        {
          "tag": "v8.5.0",
          "kind": "minor",
          "published_at": "2026-02-06T13:41:43Z"
        },
        {
          "tag": "v8.4.0",
          "kind": "minor",
          "published_at": "2026-01-13T16:26:25Z"
        },
        {
          "tag": "v8.3.0",
          "kind": "minor",
          "published_at": "2025-11-13T14:57:13Z"
        },
        {
          "tag": "v8.2.0",
          "kind": "minor",
          "published_at": "2025-09-23T17:14:56Z"
        },
        {
          "tag": "v8.1.1",
          "kind": "patch",
          "published_at": "2025-08-09T09:51:01Z"
        },
        {
          "tag": "v8.1.0",
          "kind": "minor",
          "published_at": "2025-08-07T10:42:14Z"
        },
        {
          "tag": "v8.0.0",
          "kind": "major",
          "published_at": "2025-07-30T15:16:15Z"
        },
        {
          "tag": "v7.7.0",
          "kind": "minor",
          "published_at": "2025-05-21T15:16:33Z"
        },
        {
          "tag": "v7.6.1",
          "kind": "patch",
          "published_at": "2025-05-06T13:30:38Z"
        },
        {
          "tag": "v7.6.0",
          "kind": "minor",
          "published_at": "2025-04-17T22:12:52Z"
        },
        {
          "tag": "v7.5.2",
          "kind": "patch",
          "published_at": "2025-04-02T12:00:59Z"
        },
        {
          "tag": "v7.5.1",
          "kind": "patch",
          "published_at": "2025-03-31T13:12:09Z"
        },
        {
          "tag": "v7.5.0",
          "kind": "minor",
          "published_at": "2025-03-26T13:12:38Z"
        },
        {
          "tag": "v7.4.0",
          "kind": "minor",
          "published_at": "2025-03-05T16:50:52Z"
        },
        {
          "tag": "v7.3.0",
          "kind": "minor",
          "published_at": "2025-02-26T09:54:49Z"
        },
        {
          "tag": "v7.2.0",
          "kind": "minor",
          "published_at": "2025-02-05T09:50:21Z"
        },
        {
          "tag": "v7.1.0",
          "kind": "minor",
          "published_at": "2025-01-10T10:57:58Z"
        },
        {
          "tag": "v7.0.0",
          "kind": "major",
          "published_at": "2024-12-18T15:24:01Z"
        },
        {
          "tag": "v6.4.0",
          "kind": "minor",
          "published_at": "2024-11-13T12:01:21Z"
        },
        {
          "tag": "v6.3.0",
          "kind": "minor",
          "published_at": "2024-10-24T09:44:24Z"
        },
        {
          "tag": "v6.2.0",
          "kind": "minor",
          "published_at": "2024-09-27T23:30:37Z"
        },
        {
          "tag": "v6.1.0",
          "kind": "minor",
          "published_at": "2024-08-28T12:52:15Z"
        },
        {
          "tag": "v6.0.0",
          "kind": "major",
          "published_at": "2024-08-07T18:05:42Z"
        },
        {
          "tag": "v5.1.1",
          "kind": "patch",
          "published_at": "2024-06-13T09:22:05Z"
        },
        {
          "tag": "v5.1.0",
          "kind": "minor",
          "published_at": "2024-06-11T17:19:15Z"
        },
        {
          "tag": "v5.0.0",
          "kind": "major",
          "published_at": "2024-05-21T18:10:02Z"
        },
        {
          "tag": "v4.5.0",
          "kind": "minor",
          "published_at": "2024-03-18T19:55:03Z"
        },
        {
          "tag": "v4.4.0",
          "kind": "minor",
          "published_at": "2024-02-23T18:16:20Z"
        },
        {
          "tag": "v4.3.0",
          "kind": "minor",
          "published_at": "2023-11-29T18:12:35Z"
        },
        {
          "tag": "v4.2.0",
          "kind": "minor",
          "published_at": "2023-10-03T20:28:55Z"
        },
        {
          "tag": "v4.1.0",
          "kind": "minor",
          "published_at": "2023-08-18T12:39:59Z"
        },
        {
          "tag": "v4.0.0",
          "kind": "major",
          "published_at": "2023-08-02T18:25:48Z"
        },
        {
          "tag": "v3.2.0",
          "kind": "minor",
          "published_at": "2023-06-02T16:18:35Z"
        },
        {
          "tag": "v3.1.0",
          "kind": "minor",
          "published_at": "2023-04-24T05:20:43Z"
        },
        {
          "tag": "v3.0.0",
          "kind": "major",
          "published_at": "2023-03-30T17:28:06Z"
        },
        {
          "tag": "v2.9.0",
          "kind": "minor",
          "published_at": "2023-02-16T20:56:21Z"
        },
        {
          "tag": "v2.8.0",
          "kind": "minor",
          "published_at": "2023-01-19T20:28:38Z"
        },
        {
          "tag": "v2.7.0",
          "kind": "minor",
          "published_at": "2023-01-07T18:06:01Z"
        },
        {
          "tag": "v2.6.0",
          "kind": "minor",
          "published_at": "2022-11-30T21:23:47Z"
        },
        {
          "tag": "v2.5.0",
          "kind": "minor",
          "published_at": "2022-10-18T21:31:39Z"
        },
        {
          "tag": "v2.4.0",
          "kind": "minor",
          "published_at": "2022-10-06T20:25:19Z"
        },
        {
          "tag": "v2.3.0",
          "kind": "minor",
          "published_at": "2022-09-15T15:15:01Z"
        },
        {
          "tag": "v2.2.0",
          "kind": "minor",
          "published_at": "2022-08-29T22:27:25Z"
        },
        {
          "tag": "v2.1.0",
          "kind": "minor",
          "published_at": "2022-07-14T20:51:34Z"
        },
        {
          "tag": "v2.0.1",
          "kind": "patch",
          "published_at": "2022-06-11T12:24:15Z"
        },
        {
          "tag": "v2.0.0",
          "kind": "major",
          "published_at": "2022-05-27T14:52:57Z"
        },
        {
          "tag": "v1.7.2",
          "kind": "patch",
          "published_at": "2022-05-13T00:46:31Z"
        },
        {
          "tag": "v1.7.1",
          "kind": "patch",
          "published_at": "2022-04-14T19:23:32Z"
        },
        {
          "tag": "v1.7.0",
          "kind": "minor",
          "published_at": "2022-03-23T13:30:24Z"
        },
        {
          "tag": "v1.6.0",
          "kind": "minor",
          "published_at": "2021-12-01T22:12:16Z"
        },
        {
          "tag": "v1.5.0",
          "kind": "minor",
          "published_at": "2021-10-19T16:34:14Z"
        },
        {
          "tag": "v1.4.0",
          "kind": "minor",
          "published_at": "2021-10-06T00:43:06Z"
        },
        {
          "tag": "v1.3.2",
          "kind": "patch",
          "published_at": "2021-06-29T16:18:36Z"
        },
        {
          "tag": "v1.3.1",
          "kind": "patch",
          "published_at": "2021-06-28T22:26:24Z"
        },
        {
          "tag": "v1.3.0",
          "kind": "minor",
          "published_at": "2021-06-28T18:04:26Z"
        },
        {
          "tag": "v1.2.0",
          "kind": "minor",
          "published_at": "2021-06-08T18:16:46Z"
        },
        {
          "tag": "1.1.7",
          "kind": "patch",
          "published_at": "2021-03-19T18:28:02Z"
        },
        {
          "tag": "1.1.5",
          "kind": "patch",
          "published_at": "2021-03-01T18:28:18Z"
        },
        {
          "tag": "1.1.2",
          "kind": "patch",
          "published_at": "2020-11-17T20:25:05Z"
        },
        {
          "tag": "1.1.0",
          "kind": "minor",
          "published_at": "2020-10-21T18:36:37Z"
        },
        {
          "tag": "1.0",
          "kind": "other",
          "published_at": "2020-10-06T22:11:36Z"
        },
        {
          "tag": "0.1.0",
          "kind": "minor",
          "published_at": "2020-07-17T18:29:21Z"
        }
      ],
      "recent_commits": [
        {
          "oid": "121b9db2c6c1a9af3cb92b9ac5a625a72db6e324",
          "body": "* chore: modernize DVT to upgrade ibis-framework to 7.1.0\n\n* Working Postgres and SQL Server implementations\n\n* Bigquery integration tests pass\n\n* Oracle tests pass, some tests involving Postgres don't pass, because Postgres was not available to JetSki\n\n* Linted\n\n* Special build for testing\n\n* Remov\n[…]\n@gmail.com>\nCo-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>\nCo-authored-by: sundar-mudupalli-work <106282841+sundar-mudupalli-work@users.noreply.github.com>",
          "is_bot": false,
          "headline": "chore: modernize DVT to upgrade ibis-framework to 7.1.0 (#1745)",
          "author_name": "Mike Hilton",
          "author_login": "renzokuken",
          "committed_at": "2026-07-28T20:01:14Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "2efd0bee5cb24caeb1e7672e714c584a8072edce",
          "body": "Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>\nCo-authored-by: Neil Johnson <neiljohnson@google.com>",
          "is_bot": true,
          "headline": "chore(develop): release 8.8.2 (#1793)",
          "author_name": "release-please[bot]",
          "author_login": "release-please[bot]",
          "committed_at": "2026-07-28T11:13:33Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "54b7555dc598271af954276519b343a340e00d1c",
          "body": "* feat: Table name indicator in DataValidation exceptions\n\n* chore: reformat",
          "is_bot": false,
          "headline": "chore: Table name indicator in DataValidation exceptions (#1786)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-07-28T09:39:01Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "901916735a6f1c837ff942cd42d4074066ac365d",
          "body": "…792)\n\n* fix: Ensure padded char PK detection works for upper case columns",
          "is_bot": false,
          "headline": "fix: Ensure padded char PK detection works for upper case columns (#1…",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-07-28T08:48:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b4eb1cbc36eab1ae6229c0c24d147aed1e95bb11",
          "body": "* test: Add test for dvt_int_overflow on SQL Server\n\n* test: Add test for dvt_int_overflow on Sybase\n\n* fix: Fix SQL Server overflow on SUM(INT)\n\n* fix: Fix Sybase overflow on SUM(INT)",
          "is_bot": false,
          "headline": "fix: Fix SQL Server overflow on SUM(INT) (#1790)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-07-28T07:12:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "78658ab718ca021e8a280f1a4c649a8c39ab834e",
          "body": "* fix: SQL Server tinyiny type detection\n\n* Linted\n\n* test: Remove test workarounds since reinstating link to sql_server datatypes.py\n\n---------\n\nCo-authored-by: Sundar Mudupalli <mudupalli@google.com>",
          "is_bot": false,
          "headline": "fix: SQL Server tinyint type detection (#1784)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-07-28T07:09:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c723ef1cdd5da3fcbb441ae21e248e985fe8a6bf",
          "body": "Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(develop): release 8.8.1 (#1783)",
          "author_name": "release-please[bot]",
          "author_login": "release-please[bot]",
          "committed_at": "2026-07-20T09:45:26Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b3ce0ba1444e8ad0d659e31e0a4740b6147d4755",
          "body": "* test: Add SQL Server fixed char pk tests\n\n* fix: SQL Server padded char columns are detected correctly\n\n* chore: Temporarily disable Snowflake testing",
          "is_bot": false,
          "headline": "fix: SQL Server padded char columns are detected correctly (#1779)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-07-20T08:05:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b0d2fae534f9a5d029d16b6c9cae00d96fe53ebd",
          "body": "* fix: Better message when all columns are pks for -comp-fields\n\n* docs: Limitation when all columns are pks for -comp-fields\n\n* chore: reformat",
          "is_bot": false,
          "headline": "fix: Better message when all columns are pks for -comp-fields (#1780)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-07-16T10:03:02Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "42be1e515aec61a9c3a4f2c2ce9f85fbfd307946",
          "body": "* docs: Add SQL Server AVG limitation\n\n* fix: Fix SQL Server avg for integer columns\n\n* chore: Temporarily disable Snowflake testing",
          "is_bot": false,
          "headline": "fix: Fix SQL Server avg for integer columns (#1782)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-07-16T08:47:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2b3f61f49d96deb9e6b5f700778f84aa43c78d0b",
          "body": "…es (#1775)\n\n* fix: Incorrect concat of Dataframes when broken up into multiple slices\n\n* chore: Log summary into for non-row validations\n\n* test: Tests support custom connection config JSON string\n\n* chore: Reformat\n\n* chore: Remove unused test code\n\n* chore: Temporarily disable Snowflake testing",
          "is_bot": false,
          "headline": "fix: Incorrect concat of Dataframes when broken up into multiple slic…",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-07-16T07:49:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "634a07a41710f2acc3a4b667516047dc44032709",
          "body": null,
          "is_bot": false,
          "headline": "docs: Update internal throughput test case (#1770)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-07-16T07:47:06Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "82ebdb3d5d2420436e6ccb9684d1b55e1ff60066",
          "body": "Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(develop): release 8.8.0 (#1751)",
          "author_name": "release-please[bot]",
          "author_login": "release-please[bot]",
          "committed_at": "2026-06-18T12:50:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d3bba8d2e48861f3bb3e2cd58f4d29bd7cbe8a7f",
          "body": "* fix: Use UTC for naive timestamp epoch conversion\n\n* fix: Refactor import of clients to avoid circular imports\n\nMoved the import of clients to within the function to avoid circular imports and reduce heavy weight loading in the utility module.\n\n* test: Cover pre-1970 timezone-aware epoch\n\n---------\n\nCo-authored-by: Neil Johnson <neiljohnson@google.com>",
          "is_bot": false,
          "headline": "fix: Use UTC for naive timestamp epoch conversion (#1761)",
          "author_name": "Kannappan Sirchabesan",
          "author_login": "hashkanna",
          "committed_at": "2026-06-18T09:34:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0c52e8e40bffb4c600ea21a72c69662de46f87cd",
          "body": null,
          "is_bot": false,
          "headline": "fix: Workaround for ibm_db_sa ForeignKeyConstraint exception (#1756)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-06-18T07:38:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "326770c4219b40a6a68d474ade11f756ef1f6694",
          "body": "…l ip for all Cloud SQL databases (#1748)\n\n* Gemini response to prompt 'follow the instructions in upgrade_sql.md to create script for me to review and run'\n\n* Able to run Gemini generated scripts with changes; Updated cloudbuild.yaml to reference new SQL instances; Updated install_cloud_proxy to in\n[…]\nthrow a warning with SQL Server 2025\n\n* Updated Cloudbuild.yaml to use new servers and a new version of cloud_sql_proxy\n\n* Lint fix\n\n* Updated file name and removed references to PROJECT_ID and BUCKET",
          "is_bot": false,
          "headline": "chore: Update versions of MySQL, SQL Server to latest and use interna…",
          "author_name": "sundar-mudupalli-work",
          "author_login": "sundar-mudupalli-work",
          "committed_at": "2026-06-12T15:23:41Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "8a7944e40ccf6a33099fb0b8bd47c90f1aff4132",
          "body": "* fix: YAML deserialization fix\n\n* chore: Reformat",
          "is_bot": false,
          "headline": "fix: YAML deserialization fix (#1752)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-06-12T09:10:42Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "765560ea3077194db156764a92c00ea101f9c33a",
          "body": null,
          "is_bot": false,
          "headline": "chore: Update black to most recent version (#1741)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-06-10T09:41:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6fcfef1e9c90f5b84f21f16864190eaffa094153",
          "body": "* test: Re-org tests by type, schema, column, row, query\n\n* test: Add tests for Oracle mixed case tables\n\n* docs: Add limitation for Oracle mixed case tables",
          "is_bot": false,
          "headline": "test: Add tests for Oracle mixed case tables (#1734)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-06-10T07:37:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f5e9f79983da6ad046f1aa0ca5b3d12a5a4150ff",
          "body": "… (#1742)\n\n* chore: Design doc\n\n* feat: Add --config-dir/--config-dir-json to table validation commands\n\n* test: Used a mocked connection in BigQuery tests to remove dependency on internal project/bucket\n\n* fix: Move check for missing target columns above data type retrieval to avoid unhandled exceptions\n\n* docs: Add config file/dir design doc\n\n* feat: Add --config-dir/--config-dir-json to table validation commands",
          "is_bot": false,
          "headline": "feat: Add --config-dir/--config-dir-json to table validation commands…",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-06-09T19:45:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "af4d7e82f9baff3f9876cf518bd703519abfd92d",
          "body": "* chore: Update ibm-db package version for tests\n\n* chore: Reformat",
          "is_bot": false,
          "headline": "test: Update ibm-db package version for tests (#1749)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-06-09T17:49:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a09844dfe52a38b1bc7e6c8df746b121f1cbefaf",
          "body": "* fix: Fix extract epoch expression for Db2\n\n* test: Remove limit on ibm-db-sa in integration tests\n\n* chore: Reinstate comment",
          "is_bot": false,
          "headline": "fix: Fix extract epoch expression for Db2 (#1750)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-06-09T16:42:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5692a17ea1bb984805401e030ae584342a6a1059",
          "body": "* test: Remove LONG RAW Oracle test column\n\n* fix: Exclude Oracle LOB columns from row validation",
          "is_bot": false,
          "headline": "test: Remove LONG RAW Oracle test column (#1737)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-06-04T07:52:34Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b0d3275addb26b200b33ac793b6ef60400561bea",
          "body": "Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(develop): release 8.7.1 (#1735)",
          "author_name": "release-please[bot]",
          "author_login": "release-please[bot]",
          "committed_at": "2026-05-22T09:06:52Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "76d797dd1176bb8c2a1baeed5dde4639aa833b76",
          "body": "* fix: Remove source/target conn from JSON config file",
          "is_bot": false,
          "headline": "fix: Remove source/target conn from JSON config file (#1739)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-05-21T16:42:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b62e238bb63104588a471b3e1e56e6b1c09bae26",
          "body": "* fix: Review and update samples/cloud_run files\n\n* docs: Update Python version in sample Dockerfile\n\n* docs: Add sample Dockerfile with Oracle client commands\n\n* fix: Update data_validation/app.py to match samples/cloud_run/main.py\n\n* chore: Remove unused import",
          "is_bot": false,
          "headline": "fix: Review and update samples/cloud_run files (#1730)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-05-05T14:18:10Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e6ab13276f13d9b900834e5a72af745571b98b74",
          "body": "Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(develop): release 8.7.0 (#1731)",
          "author_name": "release-please[bot]",
          "author_login": "release-please[bot]",
          "committed_at": "2026-04-20T15:07:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "62cef8cfc42282993ebd909c8477d76defcac3bc",
          "body": "* feat: Prototype Db2 z/OS support\n\n* feat: Prototype Db2 z/OS support\n\n* feat: Move Impala/Hive functions to dedicated registry file\n\n* fix: Db2 GROUP BY support in column validation\n\n* feat: Prototype Db2 z/OS support\n\n* chore: Pandas deprecation warning\n\n* chore: Resolve Pandas FutureWarning\n\n* f\n[…]\nReformat\n\n* chore: Remove unused imports\n\n* feat: Add Db2 z/OS support\n\n* chore: PR comment\n\n---------\n\nCo-authored-by: sundar-mudupalli-work <106282841+sundar-mudupalli-work@users.noreply.github.com>",
          "is_bot": false,
          "headline": "feat: Add Db2 z/OS support (#1721)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-04-20T07:32:22Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "0c0c557ccc84d5d0e4e589d6fb5f8e1c3d36067f",
          "body": "* docs: Add missing doc entry for BigQuery --client-project-id option\n\n* docs: Fix broken links in Docker readme\n\n* docs: Fix incorrect curl commands in SQL Server Dockerfile\n\n* chore: Backout BigQuery doc changes\n\n---------\n\nCo-authored-by: sundar-mudupalli-work <106282841+sundar-mudupalli-work@users.noreply.github.com>",
          "is_bot": false,
          "headline": "docs: Documentation and samples updates (#1677)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-04-19T11:16:15Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c9ccb0c05830420cf561ec21dc0720b2d5c8e5d2",
          "body": "…(#1715)\n\n* fix: Modify BQ connection to use the correct project id for billing.\n\n* Linted\n\n* Updated unit testsfor billing_project_id parameter\n\n* Updates to mark Service Keys as deprecated\n\n* fix typo\n\n* chore: Sync storage api client options with BigQuery client options\n\n---------\n\nCo-authored-by: Neil Johnson <neiljohnson@google.com>",
          "is_bot": false,
          "headline": "fix: Modify BQ connection to use the correct project id for billing. …",
          "author_name": "sundar-mudupalli-work",
          "author_login": "sundar-mudupalli-work",
          "committed_at": "2026-04-18T00:00:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7f3139ccff8141a5fc862f8ca65a41ee015edaab",
          "body": "Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(develop): release 8.6.0 (#1689)",
          "author_name": "release-please[bot]",
          "author_login": "release-please[bot]",
          "committed_at": "2026-04-13T19:50:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e67dccfd27746567c05e56e1ffc8d2b095b575be",
          "body": "…E columns (#1723)\n\n* fix: Prevent scientific notation in row validation for Db2 REAL/DOUBLE columns\n\n* docs: Add general floating-point data limitation",
          "is_bot": false,
          "headline": "fix: Prevent scientific notation in row validation for Db2 REAL/DOUBL…",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-04-10T08:52:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "806e30b6c6a1415a8317030795b728dc8fd48e1c",
          "body": "…726)\n\n* test: Enable tests to reproduce null padded char issue\n\n* fix: Protect PostgreSQL padded chars length expression from NULLs",
          "is_bot": false,
          "headline": "fix: Protect PostgreSQL padded chars length expression from NULLs (#1…",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-04-09T19:45:02Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ff3573f2c9e293ec5bc243f4431e1863dab094ac",
          "body": "…727)",
          "is_bot": false,
          "headline": "fix: custom query row validation on Db2 loses precision and scale (#1…",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-04-09T19:41:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cc0b62f3e875b0c935e1f24cbbd7d0793f943706",
          "body": "* fix: Add raw datatype support for Db2 custom queries\n\n* chore: Fix merge\n\n* test: Add more custom-query tests for Db2\n\n* docs: Add implementation plan for third_party Backend result cache\n\n* docs: Add Db2 custom query limitation\n\n* chore: Add cache for metadata method in Db2 Backend\n\n* fix: Add checks for characters used in dvt_temp_object_name prefix\n\n* docs: Add Db2 custom query limitation\n\n* fix: Add argument type checking to cache_generator_results\n\n* test: Fix unit test",
          "is_bot": false,
          "headline": "fix: Add raw datatype support for Db2 custom queries (#1707)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-04-02T17:00:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "80305540e1c0605cea258175e27aafbf8076b66f",
          "body": "* test: Add 'connections add' tests\n\n* test: Disable Impala connection option test, see issue-1720",
          "is_bot": false,
          "headline": "test: Add 'connections add' tests (#1714)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-04-02T12:34:31Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "46632d52fb0592e9bfa1abbe653c04b798e1f670",
          "body": null,
          "is_bot": false,
          "headline": "test: Add tests for Oracle to PostgreSQL null values (#1719)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-04-02T07:48:17Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b9e6f27cfaa823b4af0e2fa71b8eabafb03cdc40",
          "body": "* fix: Add raw datatype support for Db2 custom queries\n\n* chore: Fix merge\n\n* fix: Add raw datatype support for Db2 custom queries\n\n* test: Add more custom-query tests for Db2\n\n* test: Add more custom-query tests for Db2\n\n* docs: Add implementation plan for third_party Backend result cache\n\n* docs: \n[…]\n changes included in cherry-pick\n\n* feat: added try finally block and temp object name\n\n* fix: fix broken circular import\n\n* chore: Reformat\n\n---------\n\nCo-authored-by: nj1973 <neiljohnson@google.com>",
          "is_bot": false,
          "headline": "feat: Add caching mechanism for Backend functions (#1711)",
          "author_name": "Neha Nene",
          "author_login": "nehanene15",
          "committed_at": "2026-04-01T19:17:56Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "2882d50ebe85ba1af2dadf3bac39a23df0d5159a",
          "body": "…dency (#1708)\n\nTests test_config_runner_2 and test_config_runner_4 were accessing real\nGCS buckets (gs://pso-kokoro-resources) via cli_tools.list_validations,\ncausing failures for external contributors without GCS credentials.\n\nThis change:\n- Mocks cli_tools.list_validations to return expected YAML file lists\n- Replaces GCS paths in test config with local paths\n\nFixes #1482",
          "is_bot": false,
          "headline": "fix: mock list_validations in config_runner tests to remove GCS depen…",
          "author_name": "Yasunori Morishima(盛島康徳)",
          "author_login": "yasumorishima",
          "committed_at": "2026-04-01T10:36:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "97e959c0bbe615103b89844b23f7c2a40a9bf8a1",
          "body": null,
          "is_bot": false,
          "headline": "fix: Replace typehints that are incompatible with Python 3.9 (#1704)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-03-19T16:24:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ec29feb752e41b850a3d3ef0df7def7a11756eff",
          "body": "* test: Standardize Db2 tests\n\n* chore: reformat",
          "is_bot": false,
          "headline": "test: Standardize Db2 tests (#1700)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-03-19T14:35:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "63c16a80aaad467046c71cdce7fef8e96c7bac23",
          "body": "* chore: Bump black version\n\n* chore: Reformat",
          "is_bot": false,
          "headline": "chore: Bump black version (#1694)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-03-16T09:35:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "752170b682ab23fb167e020b08e7a8d1bf2c5936",
          "body": "* fix: Force Db2 FOR BIT DATA columns to Ibis Binary\n\n* fix: Add ifnull token length for Db2 binary data types\n\n* test: Correct test columns for Db2 FOR BIT DATA columns\n\n* test: Add Db2 tests for FOR BIT DATA columns\n\n* chore: Fix merge\n\n* test: Fix Db2 test col_binary column\n\n* Update third_party/ibis/ibis_db2/__init__.py\n\nCo-authored-by: Cody Fincher <204685+cofin@users.noreply.github.com>\n\n---------\n\nCo-authored-by: Cody Fincher <204685+cofin@users.noreply.github.com>",
          "is_bot": false,
          "headline": "fix: Force Db2 FOR BIT DATA columns to Ibis Binary (#1690)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-03-13T10:07:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "da96a2f2031685c101a865f2fa713af6c3d88572",
          "body": "* test: Add varbinary columns to SQL Server testing",
          "is_bot": false,
          "headline": "test: Fix test data for SQL Server varbinary columns (#1686)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-03-11T18:22:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b0155eccb9d9258695b30f09483f02e48467120b",
          "body": "* fix: revert breaking redshift change\n\n* fix: get metadata from svv_all_columns table instead\n\n* feat: remove pessimistic handling to avoid too many sessions\n\n* feat: set isolation level to autocommit\n\n* feat: lint\n\n---------\n\nCo-authored-by: Neil Johnson <neiljohnson@google.com>",
          "is_bot": false,
          "headline": "feat: Reduce Redshift queries (#1687)",
          "author_name": "Neha Nene",
          "author_login": "nehanene15",
          "committed_at": "2026-03-06T14:59:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a9b537756c9312a2b572b8c3f1d799164ea54e0e",
          "body": "…bles (#1692)\n\n* feat: Add support for differing source/target schema names to find-tables",
          "is_bot": false,
          "headline": "feat: Add support for differing source/target schema names to find-ta…",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-03-05T17:57:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "04ad3a8551e8d55226c0b1de567dad9cd16d8e0b",
          "body": "* tests: Add tests for binary columns\n\n* fix: Skip Db2 BLOB columns in row validation due to data type limitations\n\n* fix: Fix casting of Db2 binary to string and vice versa\n\n* test: Add tests for binary columns\n\n* feat: Add Db2 binary types to supported types\n\n* docs: Document Db2 BLOB limitation\n\n* test: Remove cross pollination from issue-1655",
          "is_bot": false,
          "headline": "feat: Add Db2 binary types to supported types (#1679)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-02-27T17:19:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "03777269094daa992b526eed47abe92f50b2ff83",
          "body": "Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(develop): release 8.5.2 (#1685)",
          "author_name": "release-please[bot]",
          "author_login": "release-please[bot]",
          "committed_at": "2026-02-26T17:34:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "dc3b0a0250643983f4789ba8dcba4a3c0b3f0cdf",
          "body": "* fix: Ensure we use casefold column name in raw data type map\n\n* docs: Document SQL Server text length limitation\n\n* test: Add test for CamelCase primary key column",
          "is_bot": false,
          "headline": "fix: Ensure we use casefold column name in raw data type map (#1684)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-02-26T15:09:32Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b043071c0aa09c6722d7f7faf7ee7a2499c20ca0",
          "body": "…code path (#1658)\n\n* fix: Move global cast to string length limit of 3000 to Db2 specific code\n\n* chore: Fix Pandas 3 FutureWarning\n\n* test: Test workaround to enable Python 3.10 testing again",
          "is_bot": false,
          "headline": "fix: Move global cast to string length limit of 3000 to Db2 specific …",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-02-25T22:35:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "48f9ad0ad8f1459ba8f32cda54a5f56a87b1222a",
          "body": "Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(develop): release 8.5.1 (#1671)",
          "author_name": "release-please[bot]",
          "author_login": "release-please[bot]",
          "committed_at": "2026-02-24T16:01:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "db482e52fdc53cccc5a0d425b5f26f0a526196f8",
          "body": "* test: Change dvt_db2_types tests to compare with BigQuery instead of back to Db2\n\n* fix: Correct formatting of Db2 TIME columns for row validation\n\n* fix: Fix broken merge\n\n* chore: Fix merge conflict mistake",
          "is_bot": false,
          "headline": "fix: Correct formatting of Db2 TIME columns for row validation (#1665)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-02-24T11:47:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8efd4cf4616b722c0ddb16ca193f4351f1d424e6",
          "body": "* test: Add SQL Server CamelCase test table\n\n* test: Add SQL Server tests for CamelCase table/column names",
          "is_bot": false,
          "headline": "test: Add SQL Server tests for CamelCase table/column names (#1681)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-02-24T08:34:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e2dcf47e1bf55e73a61ba6b96b6b2d13b6148c2a",
          "body": "…1678)\n\n* fix: Fix formatting of decimal with scale>0 for Db2 row validation\n\n* fix: Shorter cast for float32 to string which is breaking new test",
          "is_bot": false,
          "headline": "fix: Fix formatting of decimal with scale>0 for Db2 row validation (#…",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-02-23T22:37:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b66538769a8bdc722b258d2dbf03eed22d3df653",
          "body": "* fix: revert breaking redshift change\n\n* fix: get metadata from svv_all_columns table instead",
          "is_bot": false,
          "headline": "fix: revert breaking redshift change (#1656)",
          "author_name": "Neha Nene",
          "author_login": "nehanene15",
          "committed_at": "2026-02-23T16:26:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "13c351231f44ed470081f04727ad8c83b05bb1f7",
          "body": "* test: Add test to highlight XML issue\n\n* fix: Remove unnecessary LENGTH before COUNTing values in column validation",
          "is_bot": false,
          "headline": "fix: Fix exceptions when validating Db2 XML columns (#1674)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-02-20T15:11:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "38841b6e0f88abf95bb29d789738478ef8c8b821",
          "body": "…acement token (#1641)\n\n* test: Add tests for Db2 char padded pks\n\n* fix: Fix char padded primary key trimming for Db2 LUW\n\n* fix: Trim default IfNull replacement token on Db2\n\n* chore: Pandas deprecation warning\n\n* chore: Resolve Pandas FutureWarning\n\n* fix: Trim default IfNull replacement token on\n[…]\nement token on Db2\n\n* chore: Add comment\n\n* chore: Reformat\n\n* fix: Trim default IfNull replacement token on Db2\n\n* chore: Remove changes that were instead moved to issue 1661\n\n* test: Fix merge issue",
          "is_bot": false,
          "headline": "fix: Db2 fixes for padded char identification and default IfNull repl…",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-02-12T08:18:35Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "bceec8cdea0162a973fe67ea6cfa4eb76e69b50e",
          "body": "…670)\n\n* fix: Accurate string length when casting numbers to string in Db2\n\n* chore: Switch to deprecated python-multi image",
          "is_bot": false,
          "headline": "fix: Accurate string length when casting numbers to string in Db2 (#1…",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-02-11T08:22:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2acbd8326a395273797af39f62821e87db68b2a8",
          "body": "Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(develop): release 8.5.0 (#1645)",
          "author_name": "release-please[bot]",
          "author_login": "release-please[bot]",
          "committed_at": "2026-02-06T13:41:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1654b2136b0ba0a25ad549586cc0af146ccbbb68",
          "body": "* feat: Add --use-random-row for custom-query row validations\n\n* chore: Change test Python to 3.11 to reflect python-multi versions\n\n* Update data_validation/cli_tools.py\n\nCo-authored-by: Cody Fincher <204685+cofin@users.noreply.github.com>\n\n---------\n\nCo-authored-by: Cody Fincher <204685+cofin@users.noreply.github.com>",
          "is_bot": false,
          "headline": "feat: Add --use-random-row for custom-query row validations (#1666)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-02-06T07:35:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "28c60255f3a63955e61c1b994fa9599412ca7c0f",
          "body": "* fix: Trim default IfNull replacement token on Db2",
          "is_bot": false,
          "headline": "fix: Trim default IfNull replacement token on Db2 (#1662)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-02-03T11:28:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "91ca7e7b39e5ae1b5993b1043c1a85212bbaa52e",
          "body": "* test: Customize dvt_large_decimals test table for Db2\n\n* test: Add dvt_large_decimals tests for Db2",
          "is_bot": false,
          "headline": "test: Add dvt_large_decimals tests for Db2 (#1654)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-01-28T18:47:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2cf6b9f684ef03ef7b61187cd9671b075d48bf3b",
          "body": "* fix: Fix strftime for Db2 LUW",
          "is_bot": false,
          "headline": "fix: Fix strftime for Db2 LUW (#1652)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-01-28T16:45:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e94f6addc6c5ea5639d8846268a27c40e18eecde",
          "body": "Adds optional fields of role and warehouse as **kwargs that the `ibis.snowflake.connect()` method supports. Needed for customer. Tested on Snowflake instance.\r\n\r\nCloses #1659 \r\n\r\n## Checklist\r\n\r\n- [x] I have followed the [`CONTRIBUTING` Guide](https://togithub.com/GoogleCloudPlatform/professional-se\n[…]\nalready checked locally that all unit tests and linting are passing (use the `tests/local_check.sh` script)\r\n- [x] I have manually executed end-to-end testing (E2E) with the affected databases/engines",
          "is_bot": false,
          "headline": "feat: support role and warehouse params (#1660)",
          "author_name": "Neha Nene",
          "author_login": "nehanene15",
          "committed_at": "2026-01-27T22:10:23Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "5cbc2545a6dfc26c70b38ee19a244c603c206db0",
          "body": "* fix: Db2 find-tables by schema test\n\n* fix: Db2 find-tables by schema fix",
          "is_bot": false,
          "headline": "fix: Db2 find-tables by schema fix (#1647)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-01-23T11:19:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3f2c3a79d41415afb46e1b0e65e896a8f97006a2",
          "body": null,
          "is_bot": false,
          "headline": "fix: add no schema binding for support for external schemas (#1651)",
          "author_name": "Neha Nene",
          "author_login": "nehanene15",
          "committed_at": "2026-01-21T14:44:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ad07c0738b0760900056eeb39b599b647ec7ff49",
          "body": "* test: Add Db2 specific data type test\n\n* fix: Add Db2 DECFLOAT support\n\n* test: Add more columns into Db2 row validation tests\n\n* chore: Move sa_format_hashbytes_db2 into Db2 registry file",
          "is_bot": false,
          "headline": "fix: Db2 DECFLOAT data type and add tests (#1644)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-01-16T09:11:40Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "33145f2698793388d64d9dd4b069f9aec9a600f1",
          "body": null,
          "is_bot": false,
          "headline": "fix: Db2 GROUP BY support in column validation (#1642)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-01-14T10:02:41Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5fac11807bd546fb63b914164b5dd68663cfd497",
          "body": "Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(develop): release 8.4.0 (#1625)",
          "author_name": "release-please[bot]",
          "author_login": "release-please[bot]",
          "committed_at": "2026-01-13T16:26:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7fef33018ccc3af02298d00414ec01b08817c00c",
          "body": "* feat: Add Sybase support\n\n* test: Add end to end generate-table-partitions test\n\n* test: Sybase dependencies\n\n* chore: Rename tmp_path test variable",
          "is_bot": false,
          "headline": "feat: Add Sybase support (#1614)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2026-01-13T11:13:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "bc879ff550344f0a4de45c0f3b31cf36dc839048",
          "body": "* chore: Migrate gsutil usage to gcloud storage\n\n* Update release_latest.sh",
          "is_bot": false,
          "headline": "chore: Migrate gsutil usage to gcloud storage (#1639)",
          "author_name": "gurusai-voleti",
          "author_login": "gurusai-voleti",
          "committed_at": "2026-01-05T14:49:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "687925f43f40300d59333050ef7ad8bf5ef1f013",
          "body": null,
          "is_bot": false,
          "headline": "fix: Ensure we use BigQuery data project when prefixing tables (#1637)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2025-12-22T14:44:32Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "543ad0dfe07c6db1a0b76bd37778370da0266a24",
          "body": "* docs: Add sample SQL Server Dockerfiles",
          "is_bot": false,
          "headline": "docs: Add sample SQL Server Dockerfiles (#1636)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2025-12-17T18:42:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "49ec473bf541a468aa400f5112875009c2b00a41",
          "body": "…632)\n\n* Fix: Quota project optional parameter was not working properly. A small fix was necessary on cleints.py\n\n* style: Reformat clients.py\n\n---------\n\nCo-authored-by: Neil Johnson <neiljohnson@google.com>",
          "is_bot": false,
          "headline": "fix: Small fix to BigQuery quota project parameter implementation (#1…",
          "author_name": "FelipeKalinoski",
          "author_login": "FelipeKalinoski",
          "committed_at": "2025-12-10T12:09:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5ef95cedcadaad70e833053271f8c852cda43b48",
          "body": "* chore: Remove version limit for pyarrow\n\n* test: Add unit tests on Alpine Linux",
          "is_bot": false,
          "headline": "chore: Remove version limit for pyarrow (#1628)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2025-12-05T18:43:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2cf331f7fe396e7046ee95a18165b98f093177ab",
          "body": "…e in a different project (#1622)\n\n* Execute a validation from a BigQuery project pointing to a table in a different project\n\n* Update consts.py\n\n* Update test__main.py\n\n* chore: Reformat cli_tools.py\n\n* chore: Reformat clients.py\n\n* chore: Reformat clients.py\n\n* Update clients.py\n\n* style(black): format clients.py and cli_tools.py\n\n* style: Update clients.py\n\n---------\n\nCo-authored-by: Neil Johnson <neiljohnson@google.com>",
          "is_bot": false,
          "headline": "feat: Execute a validation from a BigQuery project pointing to a tabl…",
          "author_name": "FelipeKalinoski",
          "author_login": "FelipeKalinoski",
          "committed_at": "2025-11-26T09:20:19Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "335b773a3f475c6bb5ac18205d8263e527cc1b0d",
          "body": "Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(develop): release 8.3.0 (#1605)",
          "author_name": "release-please[bot]",
          "author_login": "release-please[bot]",
          "committed_at": "2025-11-13T14:57:01Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ea803004942465ba170e53ec869f51a85d61f139",
          "body": "…#1619)\n\n* fix: Include dialect when compiling predicates in partition builder\n\n* chore: PR comment",
          "is_bot": false,
          "headline": "fix: Include dialect when compiling predicates in partition builder (…",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2025-11-13T08:41:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "73baad71e2b1d78f6b6055547a89d726f38ae314",
          "body": "* feat: Add MSSQL connection option --odbc-driver\n\n* feat: Support ODBC driver in --query arg",
          "is_bot": false,
          "headline": "feat: Support ODBC driver in --query arg (#1620)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2025-11-10T16:26:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "939240a5caabcebacdd87d48685eba5a7f358c97",
          "body": "* chore: Drop Python 3.8 support",
          "is_bot": false,
          "headline": "chore: Drop Python 3.8 support (#1621)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2025-11-07T07:44:10Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4a5c8e974471c8339e903a55f658a0e51d8f6367",
          "body": "* fix: Skip SQL Server image data type for column validations\n\n* test: Add SQL Server image column into tests\n\n* fix: Skip SQL Server image data type for row validations\n\n* chore: Reformat",
          "is_bot": false,
          "headline": "fix: Skip SQL Server columns of type image (#1606)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2025-10-31T09:24:06Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fb59817b523a9cd818e7075990127f58a4e6a494",
          "body": "* test: Added more unit test for some CLI options and some database connections\n\n* test: Add comprehensive unit tests for main module\n\n* fix: Removed unused repeated function and non exist database test  in unit tests in main and cli_tools\n\n* fix: Removed useless 15 functions in test_cli_tools and r\n[…]\nre: added newline at test_cli_tools\n\n* removing not needed decorators and etc.\n\n---------\n\nCo-authored-by: Helen Cristina <helensilva14@gmail.com>\nCo-authored-by: Neil Johnson <neiljohnson@google.com>",
          "is_bot": false,
          "headline": "test: Added more unit tests for CLI options (#1421)",
          "author_name": "Dysprosium",
          "author_login": "safe049",
          "committed_at": "2025-10-20T10:14:14Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "ef3df2e708e08a6d81551b421ce8fec93c469a5e",
          "body": "…iles (#1609)\n\n* fix: Prevent result handler credentials from being stored in config files\n\n* tests: Fix result handler tests\n\n* chore: Fix type hints\n\n* docs: Add extra result handler pre-req note\n\n* docs: Add extra BQ result handler detail to installation doc",
          "is_bot": false,
          "headline": "fix: Prevent result handler credentials from being stored in config f…",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2025-10-17T08:22:20Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b48d6668918d3c60ff700ab3ef2f61c636a18e13",
          "body": "…path (PSO_DV_CONN_HOME) (#1598)\n\n* fix: remove if cond in StateManager._get_connections_directory\n\n* tests: fix system test_state_manager.py\n\n---------\n\nCo-authored-by: Helen Silva <helensilva14@gmail.com>\nCo-authored-by: Neil Johnson <neiljohnson@google.com>",
          "is_bot": false,
          "headline": "fix: Remove implicit \"connections\" subdirectory from GCS connections …",
          "author_name": "jj.lee",
          "author_login": "jx2lee",
          "committed_at": "2025-10-13T13:52:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9b0ce24d68e77b1b6f2453daf5afdd88ed2e5a0a",
          "body": "…hing names (#1601)\n\n* fix: Lower case schema.table find-tables keys (if possible) when matching names\n\n---------\n\nCo-authored-by: Helen Silva <helensilva14@gmail.com>",
          "is_bot": false,
          "headline": "fix: Lower case schema.table find-tables keys (if possible) when matc…",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2025-10-09T08:37:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a4eb9b07a07da452153cfe109af6cda7f799f90a",
          "body": "* Fix Issue 1428\n\n* Linted",
          "is_bot": false,
          "headline": "feat: Improve generate-table-partitions for custom queries (#1604)",
          "author_name": "sundar-mudupalli-work",
          "author_login": "sundar-mudupalli-work",
          "committed_at": "2025-10-03T14:07:24Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "075c87c943e032a90b7e3fd7e2521618a919b80e",
          "body": "Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(develop): release 8.2.0 (#1570)",
          "author_name": "release-please[bot]",
          "author_login": "release-please[bot]",
          "committed_at": "2025-09-23T17:14:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9a96f3a6b1d4924ac4d9dbbd1a4f8aee8f1dbdea",
          "body": "…ons, Teradata (#1588)\n\n* Add renderer for time literals, Teradata\n\n* fix: Support Time data type as primary key for generate-table-partitions, Teradata\n\n---------\n\nCo-authored-by: Helen Silva <helensilva14@gmail.com>\nCo-authored-by: Neil Johnson <neiljohnson@google.com>",
          "is_bot": false,
          "headline": "fix: Support Time data type as primary key for generate-table-partiti…",
          "author_name": "sundar-mudupalli-work",
          "author_login": "sundar-mudupalli-work",
          "committed_at": "2025-09-22T16:43:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "353fee190abd13d7b88941d6540a340b6a084428",
          "body": "* feat: grouped-columns in custom query column\n\n* test: add unit test for grouped-columns\n\n* test: Add new option to BigQuery integration test\n\n* chore: Reformat\n\n* Update README.md\n\n---------\n\nCo-authored-by: Neil Johnson <neiljohnson@google.com>",
          "is_bot": false,
          "headline": "feat: Enable --grouped-columns for validate custom-query column (#1587)",
          "author_name": "jj.lee",
          "author_login": "jx2lee",
          "committed_at": "2025-09-22T13:58:26Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b0dfe13bd462785ec932c7f241a8dc7c12ea3414",
          "body": "* fix: Cast SQL Server len() expression to BIGINT\n\n* fix: Pin ibm-db<3.2.7 until we investigate exceptions\n\n* chore: Pin dependencies to enable tests to pass",
          "is_bot": false,
          "headline": "fix: Cast SQL Server len() expression to BIGINT (#1590)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2025-09-22T08:51:03Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b792941b7ebbecf830ba313ffb6328bd9acdbfdf",
          "body": "* fix: Fix formatting of big columns in row validations.\n\n* test: Add comparison fields test for SQL Server types",
          "is_bot": false,
          "headline": "fix: Fix formatting of bit columns in row validations (#1586)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2025-09-17T05:39:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b74c1716891f31a77fafb3815251cbea14bd3224",
          "body": "* test: Add integration tests for more SQL Server data types\n\n* fix: SQL Server string length returns character length not byte length.\n\n* test: Remove col_image from SQL Server integration tests\n\n* test: Change SQL Server data type testing to SQL Server to PostgreSQL\n\n* test: Switch SQL Server to P\n[…]\n-by: Helen Silva <helensilva14@gmail.com>\n\n* fix: SQL Server string length returns character length not byte length.\n\n* chore: Reformat\n\n---------\n\nCo-authored-by: Helen Silva <helensilva14@gmail.com>",
          "is_bot": false,
          "headline": "fix: SQL Server string length fixes (#1579)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2025-09-05T07:38:22Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "da7324a119abbb56115521f6bc29c8936743efad",
          "body": "* fix: Fix BigQuery byte length expression\n\n* chore: Fix type hints for Python 3.8",
          "is_bot": false,
          "headline": "fix: Fix BigQuery byte length expression (#1581)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2025-08-28T17:30:01Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "350099337734e765ae898e4cbc132d40df7a1024",
          "body": "* feat: type boolean in oracle\n\n* feat: Add Oracle native BOOLEAN to DVT ibis code\n\n* feat: Ensure cast of native Oracle bool to string results in lower case value\n\n* test: Add Oracle integration test table dvt_bool_native\n\n* test: Add Oracle integration test for dvt_bool_native\n\n* remove oracle_boo\n[…]\n* test: Fix native bool test in test_oracle.py\n\n* chore: Reformat datatypes.py\n\n---------\n\nCo-authored-by: Helen Cristina <helensilva14@gmail.com>\nCo-authored-by: Neil Johnson <neiljohnson@google.com>",
          "is_bot": false,
          "headline": "feat: add support for Oracle BOOLEAN (#1558)",
          "author_name": "jj.lee",
          "author_login": "jx2lee",
          "committed_at": "2025-08-26T10:53:42Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "59939ce9f9a7f913faeaa58a95e3782a91f61fd0",
          "body": "…lidator schema (#1575)",
          "is_bot": false,
          "headline": "test: Add DDL for PostgreSQL test tables and move them to pso_data_va…",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2025-08-26T08:27:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0335f33bb2787dafba83dcefb2d81c6dcd02d438",
          "body": "…ly (#1562)\n\n* docs: Document technique for running many table validation concurrently\n\n* docs: Tidy up readme files for Cloud Run Jobs samples\n\n* docs: Fix typo\n\n* docs: Document technique for running many table validation concurrently",
          "is_bot": false,
          "headline": "docs: Document technique for running many table validation concurrent…",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2025-08-12T16:17:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b9b46b4da2657e916ed1d7b4b37dcaf3f1167712",
          "body": "Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(develop): release 8.1.1 (#1569)",
          "author_name": "release-please[bot]",
          "author_login": "release-please[bot]",
          "committed_at": "2025-08-09T09:50:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0f1dd24a50fc68dbd39ef6ebbd75d8ca1fa50088",
          "body": null,
          "is_bot": false,
          "headline": "fix: Remove logging.error call when Db2 driver is missing (#1567)",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2025-08-08T19:54:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7e24026ce163630e172629b0ed7536b0b2b4b3db",
          "body": "Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>",
          "is_bot": true,
          "headline": "chore(develop): release 8.1.0 (#1565)",
          "author_name": "release-please[bot]",
          "author_login": "release-please[bot]",
          "committed_at": "2025-08-07T10:42:03Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "03eb513d4a34ead4f987c7264e537010c5065d17",
          "body": "…561)\n\n* feat: Reinstate support for SQLAlchemy url for Oracle connections\n\n* docs: Better docs for Oracle --url option",
          "is_bot": false,
          "headline": "feat: Reinstate support for SQLAlchemy url for Oracle connections (#1…",
          "author_name": "Neil Johnson",
          "author_login": "nj1973",
          "committed_at": "2025-08-07T07:47:40Z",
          "body_truncated": false,
          "is_coding_agent": false
        }
      ],
      "releases_count": 70,
      "commits_last_year": 103,
      "latest_release_at": "2026-07-28T11:13:44Z",
      "latest_release_tag": "v8.8.2",
      "releases_from_tags": false,
      "days_since_last_push": 0,
      "active_weeks_last_year": 38,
      "days_since_latest_release": 1,
      "mean_days_between_releases": 21.8
    },
    "community": {
      "has_readme": true,
      "has_license": true,
      "has_description": true,
      "has_contributing": true,
      "health_percentage": 87,
      "has_issue_template": false,
      "has_code_of_conduct": true,
      "has_pull_request_template": true
    },
    "ecosystem": {
      "packages": [
        {
          "name": "google-pso-data-validator",
          "exists": true,
          "license": null,
          "keywords": [
            "Development Status :: 4 - Beta",
            "License :: OSI Approved :: Apache Software License",
            "Operating System :: OS Independent",
            "Programming Language :: Python",
            "Programming Language :: Python :: 3.10",
            "Programming Language :: Python :: 3.11",
            "Programming Language :: Python :: 3.9"
          ],
          "ecosystem": "pypi",
          "matches_repo": null,
          "registry_url": "https://pypi.org/project/google-pso-data-validator/",
          "is_deprecated": false,
          "latest_version": "8.8.2",
          "repository_url": null,
          "versions_count": 62,
          "total_downloads": null,
          "dependents_count": null,
          "deprecation_note": null,
          "maintainers_count": null,
          "monthly_downloads": 10612,
          "first_published_at": "2021-06-08T18:26:11.606780Z",
          "latest_published_at": "2026-07-28T11:15:58.081037Z",
          "latest_version_yanked": null,
          "days_since_latest_publish": 1
        }
      ]
    },
    "popularity": {
      "forks": 166,
      "stars": 516,
      "watchers": 42,
      "fork_history": {
        "days": [
          {
            "date": "2021-06-23",
            "count": 1
          },
          {
            "date": "2021-06-30",
            "count": 1
          },
          {
            "date": "2021-07-23",
            "count": 1
          },
          {
            "date": "2021-07-28",
            "count": 1
          },
          {
            "date": "2021-08-19",
            "count": 1
          },
          {
            "date": "2021-08-20",
            "count": 1
          },
          {
            "date": "2021-08-23",
            "count": 1
          },
          {
            "date": "2021-09-23",
            "count": 1
          },
          {
            "date": "2021-09-27",
            "count": 1
          },
          {
            "date": "2021-10-20",
            "count": 1
          },
          {
            "date": "2021-10-26",
            "count": 1
          },
          {
            "date": "2021-12-08",
            "count": 1
          },
          {
            "date": "2021-12-20",
            "count": 1
          },
          {
            "date": "2021-12-30",
            "count": 1
          },
          {
            "date": "2022-01-15",
            "count": 1
          },
          {
            "date": "2022-02-01",
            "count": 1
          },
          {
            "date": "2022-02-03",
            "count": 1
          },
          {
            "date": "2022-02-24",
            "count": 1
          },
          {
            "date": "2022-02-27",
            "count": 1
          },
          {
            "date": "2022-02-28",
            "count": 1
          },
          {
            "date": "2022-03-15",
            "count": 1
          },
          {
            "date": "2022-03-22",
            "count": 1
          },
          {
            "date": "2022-03-24",
            "count": 1
          },
          {
            "date": "2022-03-28",
            "count": 1
          },
          {
            "date": "2022-03-30",
            "count": 2
          },
          {
            "date": "2022-04-01",
            "count": 2
          },
          {
            "date": "2022-04-04",
            "count": 2
          },
          {
            "date": "2022-04-05",
            "count": 2
          },
          {
            "date": "2022-04-14",
            "count": 1
          },
          {
            "date": "2022-04-24",
            "count": 1
          },
          {
            "date": "2022-05-17",
            "count": 1
          },
          {
            "date": "2022-05-22",
            "count": 1
          },
          {
            "date": "2022-06-07",
            "count": 1
          },
          {
            "date": "2022-06-09",
            "count": 2
          },
          {
            "date": "2022-06-13",
            "count": 1
          },
          {
            "date": "2022-06-16",
            "count": 1
          },
          {
            "date": "2022-06-23",
            "count": 1
          },
          {
            "date": "2022-06-25",
            "count": 1
          },
          {
            "date": "2022-06-27",
            "count": 1
          },
          {
            "date": "2022-06-30",
            "count": 1
          },
          {
            "date": "2022-07-13",
            "count": 1
          },
          {
            "date": "2022-08-08",
            "count": 1
          },
          {
            "date": "2022-08-10",
            "count": 1
          },
          {
            "date": "2022-08-15",
            "count": 1
          },
          {
            "date": "2022-08-23",
            "count": 1
          },
          {
            "date": "2022-08-26",
            "count": 1
          },
          {
            "date": "2022-09-26",
            "count": 1
          },
          {
            "date": "2022-10-06",
            "count": 1
          },
          {
            "date": "2022-10-24",
            "count": 1
          },
          {
            "date": "2022-11-11",
            "count": 1
          },
          {
            "date": "2022-12-01",
            "count": 1
          },
          {
            "date": "2022-12-08",
            "count": 1
          },
          {
            "date": "2022-12-14",
            "count": 1
          },
          {
            "date": "2022-12-29",
            "count": 1
          },
          {
            "date": "2023-01-04",
            "count": 1
          },
          {
            "date": "2023-01-31",
            "count": 2
          },
          {
            "date": "2023-02-07",
            "count": 1
          },
          {
            "date": "2023-02-12",
            "count": 1
          },
          {
            "date": "2023-02-13",
            "count": 1
          },
          {
            "date": "2023-02-16",
            "count": 1
          },
          {
            "date": "2023-02-17",
            "count": 1
          },
          {
            "date": "2023-02-21",
            "count": 1
          },
          {
            "date": "2023-02-28",
            "count": 1
          },
          {
            "date": "2023-03-28",
            "count": 1
          },
          {
            "date": "2023-04-04",
            "count": 1
          },
          {
            "date": "2023-04-06",
            "count": 1
          },
          {
            "date": "2023-04-07",
            "count": 1
          },
          {
            "date": "2023-06-09",
            "count": 1
          },
          {
            "date": "2023-06-25",
            "count": 1
          },
          {
            "date": "2023-07-12",
            "count": 1
          },
          {
            "date": "2023-07-25",
            "count": 1
          },
          {
            "date": "2023-08-15",
            "count": 1
          },
          {
            "date": "2023-08-30",
            "count": 1
          },
          {
            "date": "2023-09-01",
            "count": 1
          },
          {
            "date": "2023-09-17",
            "count": 1
          },
          {
            "date": "2023-10-13",
            "count": 1
          },
          {
            "date": "2023-11-17",
            "count": 1
          },
          {
            "date": "2023-12-20",
            "count": 1
          },
          {
            "date": "2024-01-18",
            "count": 1
          },
          {
            "date": "2024-01-24",
            "count": 1
          },
          {
            "date": "2024-02-02",
            "count": 1
          },
          {
            "date": "2024-02-05",
            "count": 1
          },
          {
            "date": "2024-02-15",
            "count": 1
          },
          {
            "date": "2024-03-04",
            "count": 1
          },
          {
            "date": "2024-03-05",
            "count": 1
          },
          {
            "date": "2024-03-13",
            "count": 1
          },
          {
            "date": "2024-03-24",
            "count": 1
          },
          {
            "date": "2024-05-01",
            "count": 1
          },
          {
            "date": "2024-05-22",
            "count": 1
          },
          {
            "date": "2024-07-13",
            "count": 1
          },
          {
            "date": "2024-08-08",
            "count": 1
          },
          {
            "date": "2024-09-06",
            "count": 1
          },
          {
            "date": "2024-09-09",
            "count": 1
          },
          {
            "date": "2024-09-12",
            "count": 1
          },
          {
            "date": "2024-09-25",
            "count": 1
          },
          {
            "date": "2024-10-02",
            "count": 1
          },
          {
            "date": "2024-10-09",
            "count": 1
          },
          {
            "date": "2024-10-25",
            "count": 1
          },
          {
            "date": "2024-10-29",
            "count": 1
          },
          {
            "date": "2024-11-14",
            "count": 1
          },
          {
            "date": "2025-01-10",
            "count": 1
          },
          {
            "date": "2025-01-15",
            "count": 1
          },
          {
            "date": "2025-01-23",
            "count": 1
          },
          {
            "date": "2025-01-28",
            "count": 1
          },
          {
            "date": "2025-02-02",
            "count": 1
          },
          {
            "date": "2025-03-10",
            "count": 1
          },
          {
            "date": "2025-03-17",
            "count": 1
          },
          {
            "date": "2025-03-23",
            "count": 1
          },
          {
            "date": "2025-04-01",
            "count": 1
          },
          {
            "date": "2025-04-25",
            "count": 1
          },
          {
            "date": "2025-04-30",
            "count": 1
          },
          {
            "date": "2025-05-02",
            "count": 1
          },
          {
            "date": "2025-05-10",
            "count": 1
          },
          {
            "date": "2025-05-12",
            "count": 1
          },
          {
            "date": "2025-05-17",
            "count": 1
          },
          {
            "date": "2025-06-03",
            "count": 1
          },
          {
            "date": "2025-06-05",
            "count": 1
          },
          {
            "date": "2025-06-28",
            "count": 1
          },
          {
            "date": "2025-07-04",
            "count": 1
          },
          {
            "date": "2025-07-26",
            "count": 1
          },
          {
            "date": "2025-08-09",
            "count": 1
          },
          {
            "date": "2025-08-12",
            "count": 1
          },
          {
            "date": "2025-08-20",
            "count": 1
          },
          {
            "date": "2025-09-11",
            "count": 1
          },
          {
            "date": "2025-09-16",
            "count": 1
          },
          {
            "date": "2025-10-03",
            "count": 1
          },
          {
            "date": "2025-10-16",
            "count": 2
          },
          {
            "date": "2025-10-21",
            "count": 1
          },
          {
            "date": "2025-10-23",
            "count": 3
          },
          {
            "date": "2025-10-29",
            "count": 1
          },
          {
            "date": "2025-11-07",
            "count": 1
          },
          {
            "date": "2025-11-13",
            "count": 1
          },
          {
            "date": "2025-11-30",
            "count": 1
          },
          {
            "date": "2025-12-16",
            "count": 1
          },
          {
            "date": "2025-12-18",
            "count": 1
          },
          {
            "date": "2025-12-27",
            "count": 1
          },
          {
            "date": "2026-01-02",
            "count": 1
          },
          {
            "date": "2026-02-17",
            "count": 1
          },
          {
            "date": "2026-02-26",
            "count": 1
          },
          {
            "date": "2026-02-27",
            "count": 1
          },
          {
            "date": "2026-03-21",
            "count": 1
          },
          {
            "date": "2026-03-22",
            "count": 1
          },
          {
            "date": "2026-04-07",
            "count": 1
          },
          {
            "date": "2026-04-14",
            "count": 1
          },
          {
            "date": "2026-04-24",
            "count": 1
          },
          {
            "date": "2026-05-06",
            "count": 1
          },
          {
            "date": "2026-05-14",
            "count": 1
          },
          {
            "date": "2026-05-24",
            "count": 1
          },
          {
            "date": "2026-06-01",
            "count": 1
          },
          {
            "date": "2026-06-02",
            "count": 2
          },
          {
            "date": "2026-06-18",
            "count": 1
          },
          {
            "date": "2026-07-12",
            "count": 1
          },
          {
            "date": "2026-07-16",
            "count": 1
          },
          {
            "date": "2026-07-28",
            "count": 1
          }
        ],
        "complete": true,
        "collected": 164,
        "total_forks": 166
      },
      "star_history": null,
      "open_issues_and_prs": 144
    },
    "ai_readiness": {
      "has_nix": false,
      "example_dirs": [
        "samples"
      ],
      "has_llms_txt": false,
      "has_dockerfile": true,
      "has_mcp_signal": false,
      "bootstrap_files": [
        "noxfile.py"
      ],
      "api_schema_files": [],
      "has_devcontainer": false,
      "typecheck_configs": [],
      "toolchain_manifests": [],
      "largest_source_bytes": 69773,
      "source_files_sampled": 105,
      "oversized_source_files": 4,
      "agent_instruction_files": [],
      "agent_instruction_max_bytes": null
    },
    "dependencies": {
      "manifests": [
        "setup.cfg",
        "setup.py"
      ],
      "advisories": {
        "error": null,
        "scope": "published_package",
        "source": "osv",
        "findings": [
          {
            "name": "ibis-framework",
            "direct": true,
            "version": "5.1.0",
            "severity": "critical",
            "ecosystem": "pypi",
            "cvss_score": null,
            "advisory_ids": [
              "GHSA-x563-6hqv-26mr"
            ],
            "fixed_version": "7.1.0",
            "advisory_count": 1,
            "oldest_advisory_days": 984
          }
        ],
        "collected": true,
        "malicious": [],
        "truncated": false,
        "by_severity": {
          "critical": 1
        },
        "advisory_count": 1,
        "affected_count": 1,
        "assessed_count": 88,
        "malicious_count": 0,
        "assessed_package": "pypi:google-pso-data-validator@8.8.2",
        "unassessed_count": 0,
        "direct_affected_count": 1
      },
      "ecosystems": [
        "pypi"
      ],
      "dependencies": [],
      "all_dependencies": {
        "error": null,
        "source": "github-sbom",
        "packages": [
          {
            "name": "0",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "1",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "3",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "black",
            "direct": false,
            "version": "26.5.1",
            "ecosystem": "pypi"
          },
          {
            "name": "flake8",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "flask",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "freezegun",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "fsspec",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "google-api-python-client",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "google-cloud-bigquery",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "google-cloud-bigquery-storage",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "google-cloud-secret-manager",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "google-cloud-spanner",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "google-cloud-storage",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "google-pso-data-validator",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "ibis-framework",
            "direct": false,
            "version": "7.1.0",
            "ecosystem": "pypi"
          },
          {
            "name": "impyla",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "jellyfish",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "pandas",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "parsy",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "psycopg2-binary",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "pyarrow",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "pydata-google-auth",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "pyfakefs",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "pymysql",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "pytest",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "pytest-cov",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "pytest-rerunfailures",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "pytest-timeout",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "pyyaml",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "sqlalchemy",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          },
          {
            "name": "tabulate",
            "direct": false,
            "version": null,
            "ecosystem": "pypi"
          }
        ],
        "collected": true,
        "truncated": false,
        "total_count": 32,
        "direct_count": 0,
        "indirect_count": 32
      }
    },
    "maintainership": {
      "issues": {
        "open_prs": 2,
        "merged_prs": 723,
        "open_issues": 142,
        "closed_ratio": 0.853,
        "closed_issues": 825,
        "closed_unmerged_prs": 93
      },
      "bus_factor": 2,
      "bot_contributors": 2,
      "top_contributors": [
        {
          "type": "User",
          "login": "dhercher",
          "commits": 447,
          "avatar_url": "https://avatars.githubusercontent.com/u/1823111?v=4"
        },
        {
          "type": "User",
          "login": "nj1973",
          "commits": 189,
          "avatar_url": "https://avatars.githubusercontent.com/u/1631013?v=4"
        },
        {
          "type": "User",
          "login": "nehanene15",
          "commits": 108,
          "avatar_url": "https://avatars.githubusercontent.com/u/25696756?v=4"
        },
        {
          "type": "User",
          "login": "tswast",
          "commits": 60,
          "avatar_url": "https://avatars.githubusercontent.com/u/247555?v=4"
        },
        {
          "type": "User",
          "login": "helensilva14",
          "commits": 47,
          "avatar_url": "https://avatars.githubusercontent.com/u/37883833?v=4"
        },
        {
          "type": "User",
          "login": "renzokuken",
          "commits": 33,
          "avatar_url": "https://avatars.githubusercontent.com/u/2968468?v=4"
        },
        {
          "type": "User",
          "login": "sundar-mudupalli-work",
          "commits": 27,
          "avatar_url": "https://avatars.githubusercontent.com/u/106282841?v=4"
        },
        {
          "type": "User",
          "login": "dhaval-d",
          "commits": 18,
          "avatar_url": "https://avatars.githubusercontent.com/u/25624651?v=4"
        },
        {
          "type": "User",
          "login": "piyushsarraf",
          "commits": 13,
          "avatar_url": "https://avatars.githubusercontent.com/u/47020544?v=4"
        },
        {
          "type": "User",
          "login": "dmedora",
          "commits": 9,
          "avatar_url": "https://avatars.githubusercontent.com/u/21352998?v=4"
        }
      ],
      "contributors_sampled": 56,
      "top_contributor_share": 0.417
    },
    "quality_signals": {
      "has_ci": false,
      "has_tests": true,
      "ci_workflows": [],
      "has_docs_dir": true,
      "linter_configs": [
        ".flake8"
      ],
      "has_editorconfig": false,
      "has_linter_config": true,
      "has_precommit_config": false
    },
    "security_signals": {
      "lockfiles": [],
      "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": null,
            "reason": "internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
          },
          {
            "name": "CI-Tests",
            "score": 10,
            "reason": "30 out of 30 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": 10,
            "reason": "all changesets reviewed",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
          },
          {
            "name": "Contributors",
            "score": 10,
            "reason": "project has 7 contributing companies or organizations",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
          },
          {
            "name": "Dangerous-Workflow",
            "score": null,
            "reason": "no workflows found",
            "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": "26 commit(s) and 25 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": null,
            "reason": "packaging workflow not 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": 9,
            "reason": "SAST tool is not run on all commits -- score normalized to 9",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#sast"
          },
          {
            "name": "Security-Policy",
            "score": 10,
            "reason": "security policy file 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": null,
            "reason": "No tokens found",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
          },
          {
            "name": "Vulnerabilities",
            "score": 9,
            "reason": "1 existing vulnerabilities detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
          }
        ],
        "commit": "121b9db2c6c1a9af3cb92b9ac5a625a72db6e324",
        "ran_at": "2026-07-29T17:15:18Z",
        "aggregate_score": 8,
        "scorecard_version": "v5.5.0"
      },
      "has_codeql_workflow": false,
      "has_security_policy": true,
      "has_dependabot_config": false
    },
    "contribution_flow": {
      "collected": true,
      "ci_last_run_at": "2026-07-28T20:01:56Z",
      "oldest_open_prs": [
        {
          "number": 1648,
          "created_at": "2026-01-16T18:52:36Z",
          "last_comment_at": "2026-01-16T18:53:45Z",
          "last_comment_author": "sundar-mudupalli-work"
        },
        {
          "number": 1744,
          "created_at": "2026-05-27T01:33:18Z",
          "last_comment_at": null,
          "last_comment_author": null
        }
      ],
      "last_merged_pr_at": "2026-07-28T20:01:15Z",
      "ci_last_conclusion": "SUCCESS",
      "oldest_open_issues": [
        {
          "number": 5,
          "created_at": "2020-04-28T21:48:38Z",
          "last_comment_at": "2021-01-08T18:22:04Z",
          "last_comment_author": "freedomofnet"
        },
        {
          "number": 86,
          "created_at": "2020-09-03T19:21:45Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 173,
          "created_at": "2021-01-05T23:20:45Z",
          "last_comment_at": "2022-06-14T18:08:34Z",
          "last_comment_author": "nehanene15"
        },
        {
          "number": 426,
          "created_at": "2022-04-07T18:31:31Z",
          "last_comment_at": "2022-04-07T20:27:26Z",
          "last_comment_author": "srikanthgaddam2"
        },
        {
          "number": 474,
          "created_at": "2022-05-10T16:43:55Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 497,
          "created_at": "2022-06-03T14:38:58Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 595,
          "created_at": "2022-09-29T17:50:38Z",
          "last_comment_at": "2024-12-18T16:08:31Z",
          "last_comment_author": "helensilva14"
        },
        {
          "number": 630,
          "created_at": "2022-11-05T20:24:08Z",
          "last_comment_at": "2024-01-29T20:11:50Z",
          "last_comment_author": "helensilva14"
        },
        {
          "number": 660,
          "created_at": "2023-01-13T16:16:45Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 696,
          "created_at": "2023-02-02T04:02:47Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 719,
          "created_at": "2023-02-10T19:04:09Z",
          "last_comment_at": "2023-11-09T18:37:10Z",
          "last_comment_author": "helensilva14"
        },
        {
          "number": 758,
          "created_at": "2023-03-02T16:55:31Z",
          "last_comment_at": "2024-12-12T00:08:21Z",
          "last_comment_author": "sundar-mudupalli-work"
        },
        {
          "number": 768,
          "created_at": "2023-03-12T05:32:47Z",
          "last_comment_at": "2024-06-04T22:10:56Z",
          "last_comment_author": "moizarafat"
        },
        {
          "number": 774,
          "created_at": "2023-03-14T15:03:47Z",
          "last_comment_at": "2026-07-29T08:52:40Z",
          "last_comment_author": "nj1973"
        },
        {
          "number": 775,
          "created_at": "2023-03-14T18:46:05Z",
          "last_comment_at": "2024-08-16T19:07:51Z",
          "last_comment_author": "viclinriv"
        },
        {
          "number": 794,
          "created_at": "2023-04-05T20:51:47Z",
          "last_comment_at": "2024-06-14T07:55:11Z",
          "last_comment_author": "nick-redfearn"
        },
        {
          "number": 848,
          "created_at": "2023-05-11T22:05:56Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 852,
          "created_at": "2023-05-11T22:21:31Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 854,
          "created_at": "2023-05-12T03:34:38Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 872,
          "created_at": "2023-05-26T16:40:27Z",
          "last_comment_at": null,
          "last_comment_author": null
        }
      ]
    }
  },
  "config": {
    "disabled_metrics": [],
    "disabled_categories": [],
    "disabled_components": {}
  },
  "source": {
    "url": "https://github.com/GoogleCloudPlatform/professional-services-data-validator",
    "host": "github.com",
    "name": "professional-services-data-validator",
    "owner": "GoogleCloudPlatform"
  },
  "metrics": {
    "overall": {
      "key": "overall",
      "band": "good",
      "name": "Overall health",
      "note": null,
      "notes": [],
      "value": 80,
      "inputs": {
        "security": 77,
        "vitality": 94,
        "community": 78,
        "governance": 81,
        "engineering": 66
      },
      "components": []
    },
    "categories": [
      {
        "key": "vitality",
        "band": "excellent",
        "name": "Vitality",
        "value": 94,
        "weight": 0.22,
        "metrics": [
          {
            "key": "development_activity",
            "band": "excellent",
            "name": "Development activity",
            "note": null,
            "notes": [],
            "value": 90,
            "inputs": {
              "commits_last_year": 103,
              "human_commit_share": 0.86,
              "days_since_last_push": 0,
              "active_weeks_last_year": 38
            },
            "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": "38/52 weeks with commits",
                "points": 26.3,
                "status": "partial",
                "details": [
                  {
                    "code": "commit_cadence_weeks",
                    "params": {
                      "weeks": 38
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_volume",
                "name": "Commit volume",
                "detail": "103 commits in the last year",
                "points": 18,
                "status": "met",
                "details": [
                  {
                    "code": "commits_last_year",
                    "params": {
                      "count": 103
                    }
                  }
                ],
                "max_points": 18
              },
              {
                "key": "openssf_scorecard_maintained",
                "name": "OpenSSF Scorecard: Maintained",
                "detail": "26 commit(s) and 25 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": 100,
            "inputs": {
              "releases_count": 70,
              "latest_release_tag": "v8.8.2",
              "releases_from_tags": false,
              "days_since_latest_release": 1,
              "mean_days_between_releases": 21.8
            },
            "components": [
              {
                "key": "ships_releases",
                "name": "Ships releases",
                "detail": "70 releases published",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "releases_published",
                    "params": {
                      "count": 70
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "release_recency",
                "name": "Release recency",
                "detail": "latest release 1 days ago",
                "points": 36,
                "status": "met",
                "details": [
                  {
                    "code": "release_recency",
                    "params": {
                      "days": 1
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "release_cadence",
                "name": "Release cadence",
                "detail": "a release every ~21.8 days",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "release_cadence",
                    "params": {
                      "gap": 21.8
                    }
                  }
                ],
                "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": 78,
        "weight": 0.18,
        "metrics": [
          {
            "key": "popularity",
            "band": "good",
            "name": "Popularity & adoption",
            "note": null,
            "notes": [],
            "value": 72,
            "inputs": {
              "forks": 166,
              "stars": 516,
              "watchers": 42,
              "growth_state": "unverified",
              "growth_factor_pct": 100,
              "growth_unverified_reason": "no_history"
            },
            "components": [
              {
                "key": "stars",
                "name": "Stars",
                "detail": "516 stars",
                "points": 44,
                "status": "partial",
                "details": [
                  {
                    "code": "stars",
                    "params": {
                      "count": 516
                    }
                  }
                ],
                "max_points": 60
              },
              {
                "key": "forks",
                "name": "Forks",
                "detail": "166 forks",
                "points": 18.5,
                "status": "partial",
                "details": [
                  {
                    "code": "forks",
                    "params": {
                      "count": 166
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "watchers",
                "name": "Watchers",
                "detail": "42 watchers",
                "points": 9,
                "status": "partial",
                "details": [
                  {
                    "code": "watchers",
                    "params": {
                      "count": 42
                    }
                  }
                ],
                "max_points": 15
              }
            ]
          },
          {
            "key": "community_health",
            "band": "excellent",
            "name": "Community health",
            "note": null,
            "notes": [],
            "value": 92,
            "inputs": {
              "has_readme": true,
              "has_license": true,
              "has_contributing": true,
              "has_issue_template": false,
              "has_code_of_conduct": true,
              "has_pull_request_template": true
            },
            "components": [
              {
                "key": "readme",
                "name": "README",
                "detail": null,
                "points": 22.5,
                "status": "met",
                "details": [],
                "max_points": 22.5
              },
              {
                "key": "license",
                "name": "License",
                "detail": "recognized license (Apache-2.0)",
                "points": 22.5,
                "status": "met",
                "details": [
                  {
                    "code": "license_standard",
                    "params": {}
                  },
                  {
                    "code": "license_spdx",
                    "params": {
                      "spdx": "Apache-2.0"
                    }
                  }
                ],
                "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": 13.5,
                "status": "met",
                "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": 6.3,
                "status": "met",
                "details": [],
                "max_points": 6.3
              }
            ]
          },
          {
            "key": "ecosystem_adoption",
            "band": "moderate",
            "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": 67,
            "inputs": {
              "packages": [
                "google-pso-data-validator"
              ],
              "dependents": null,
              "ecosystems": "pypi",
              "total_downloads": null,
              "monthly_downloads": 10612
            },
            "components": [
              {
                "key": "monthly_downloads",
                "name": "Monthly downloads",
                "detail": "10,612 downloads/month across pypi",
                "points": 53.7,
                "status": "partial",
                "details": [
                  {
                    "code": "downloads_monthly",
                    "params": {
                      "count": 10612,
                      "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": 81,
        "weight": 0.24,
        "metrics": [
          {
            "key": "maintainer_resilience",
            "band": "moderate",
            "name": "Maintainer resilience (bus factor)",
            "note": null,
            "notes": [],
            "value": 62,
            "inputs": {
              "bus_factor": 2,
              "contributors_sampled": 56,
              "top_contributor_share": 0.417
            },
            "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 42% of commits",
                "points": 13.1,
                "status": "partial",
                "details": [
                  {
                    "code": "top_contributor_share",
                    "params": {
                      "share": 42
                    }
                  }
                ],
                "max_points": 22.5
              },
              {
                "key": "contributor_breadth",
                "name": "Contributor breadth",
                "detail": "56 contributors",
                "points": 13.5,
                "status": "met",
                "details": [
                  {
                    "code": "contributors_sampled",
                    "params": {
                      "count": 56
                    }
                  }
                ],
                "max_points": 13.5
              },
              {
                "key": "openssf_scorecard_contributors",
                "name": "OpenSSF Scorecard: Contributors",
                "detail": "project has 7 contributing companies or organizations",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "responsiveness",
            "band": "excellent",
            "name": "Issue & PR responsiveness",
            "note": null,
            "notes": [],
            "value": 89,
            "inputs": {
              "merged_prs": 723,
              "open_issues": 142,
              "closed_issues": 825,
              "issue_closed_ratio": 0.853,
              "closed_unmerged_prs": 93
            },
            "components": [
              {
                "key": "issue_resolution",
                "name": "Issue resolution",
                "detail": "85% of issues closed",
                "points": 39.9,
                "status": "partial",
                "details": [
                  {
                    "code": "issues_closed_share",
                    "params": {
                      "share": 85
                    }
                  }
                ],
                "max_points": 46.75
              },
              {
                "key": "pr_acceptance",
                "name": "PR acceptance",
                "detail": "723/816 decided PRs merged",
                "points": 33.9,
                "status": "partial",
                "details": [
                  {
                    "code": "decided_prs_merged",
                    "params": {
                      "merged": 723,
                      "decided": 816
                    }
                  }
                ],
                "max_points": 38.25
              },
              {
                "key": "openssf_scorecard_code_review",
                "name": "OpenSSF Scorecard: Code-Review",
                "detail": "all changesets reviewed",
                "points": 15,
                "status": "met",
                "details": [],
                "max_points": 15
              }
            ]
          },
          {
            "key": "stewardship",
            "band": "good",
            "name": "Ownership & stewardship",
            "note": null,
            "notes": [],
            "value": 80,
            "inputs": {
              "followers": 21384,
              "owner_type": "Organization",
              "is_verified": null,
              "owner_login": "GoogleCloudPlatform",
              "public_repos": 1498,
              "account_age_days": 5003
            },
            "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": "21,384 followers of GoogleCloudPlatform",
                "points": 25,
                "status": "met",
                "details": [
                  {
                    "code": "owner_followers",
                    "params": {
                      "count": 21384,
                      "login": "GoogleCloudPlatform"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "track_record",
                "name": "Track record",
                "detail": "1498 public repos, account ~13 yr old",
                "points": 25,
                "status": "met",
                "details": [
                  {
                    "code": "public_repos",
                    "params": {
                      "count": 1498
                    }
                  },
                  {
                    "code": "account_age_years",
                    "params": {
                      "years": 13
                    }
                  }
                ],
                "max_points": 25
              }
            ]
          },
          {
            "key": "package_maintenance",
            "band": "excellent",
            "name": "Package maintenance",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "packages": [
                "google-pso-data-validator"
              ],
              "ecosystems": "pypi",
              "any_deprecated": false,
              "min_days_since_publish": 1
            },
            "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 1 days ago",
                "points": 35,
                "status": "met",
                "details": [
                  {
                    "code": "publish_recency",
                    "params": {
                      "days": 1
                    }
                  }
                ],
                "max_points": 35
              },
              {
                "key": "version_history",
                "name": "Version history",
                "detail": "62 published versions",
                "points": 20,
                "status": "met",
                "details": [
                  {
                    "code": "published_versions",
                    "params": {
                      "count": 62
                    }
                  }
                ],
                "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": "moderate",
        "name": "Engineering Quality",
        "value": 66,
        "weight": 0.2,
        "metrics": [
          {
            "key": "engineering_practices",
            "band": "moderate",
            "name": "Engineering practices",
            "note": null,
            "notes": [],
            "value": 60,
            "inputs": {
              "has_ci": false,
              "has_tests": true,
              "has_editorconfig": false,
              "has_linter_config": true,
              "has_precommit_config": false
            },
            "components": [
              {
                "key": "ci_workflows",
                "name": "CI workflows",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "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": ".flake8",
                "points": 16,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": ".flake8"
                    }
                  }
                ],
                "max_points": 16
              },
              {
                "key": "pre_commit_hooks",
                "name": "Pre-commit hooks",
                "detail": null,
                "points": 0,
                "status": "missed",
                "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": "30 out of 30 merged PRs checked by a CI test -- score normalized to 10",
                "points": 20,
                "status": "met",
                "details": [],
                "max_points": 20
              }
            ]
          },
          {
            "key": "documentation",
            "band": "good",
            "name": "Documentation",
            "note": null,
            "notes": [],
            "value": 75,
            "inputs": {
              "topics": [],
              "has_wiki": true,
              "homepage": null,
              "has_readme": true,
              "has_docs_dir": true,
              "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": 25,
                "status": "met",
                "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": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              },
              {
                "key": "wiki",
                "name": "Wiki",
                "detail": null,
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          }
        ],
        "description": "Are baseline engineering and documentation practices in place?"
      },
      {
        "key": "security",
        "band": "good",
        "name": "Security",
        "value": 77,
        "weight": 0.16,
        "metrics": [
          {
            "key": "security_posture",
            "band": "good",
            "name": "Security posture",
            "note": "Excluded from scoring (no data or not applicable): Branch-Protection, Dangerous-Workflow, Packaging, Signed-Releases, Token-Permissions. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "branch_protection",
                    "dangerous_workflow",
                    "packaging",
                    "signed_releases",
                    "token_permissions"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 80,
            "inputs": {
              "source": "openssf_scorecard",
              "checks_evaluated": 13,
              "scorecard_version": "v5.5.0",
              "checks_inconclusive": 5,
              "scorecard_aggregate": 8
            },
            "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": "internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 7.5
              },
              {
                "key": "ci_tests",
                "name": "CI-Tests",
                "detail": "30 out of 30 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": "all changesets reviewed",
                "points": 7.5,
                "status": "met",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "contributors",
                "name": "Contributors",
                "detail": "project has 7 contributing companies or organizations",
                "points": 2.5,
                "status": "met",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "dangerous_workflow",
                "name": "Dangerous-Workflow",
                "detail": "no workflows found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "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": "26 commit(s) and 25 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 not detected",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "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 9",
                "points": 4.5,
                "status": "partial",
                "details": [],
                "max_points": 5
              },
              {
                "key": "security_policy",
                "name": "Security-Policy",
                "detail": "security policy file detected",
                "points": 5,
                "status": "met",
                "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": "No tokens found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 7.5
              },
              {
                "key": "vulnerabilities",
                "name": "Vulnerabilities",
                "detail": "1 existing vulnerabilities detected",
                "points": 6.8,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              }
            ]
          },
          {
            "key": "dependency_advisories",
            "band": "moderate",
            "name": "Dependency advisories",
            "note": "Matched the pypi:google-pso-data-validator@8.8.2 runtime dependency closure — what installing the published package pulls in — 88 packages. Reachability is not analyzed.",
            "notes": [
              {
                "code": "advisories_scope_published",
                "params": {
                  "package": "pypi:google-pso-data-validator@8.8.2",
                  "assessed": 88
                }
              },
              {
                "code": "advisories_reachability",
                "params": {}
              }
            ],
            "value": 64,
            "inputs": {
              "source": "osv",
              "advisories": 1,
              "affected_packages": 1,
              "assessed_packages": 88,
              "unassessed_packages": 0,
              "affected_by_severity": "critical 1",
              "direct_affected_packages": 1
            },
            "components": [
              {
                "key": "direct_dependencies_free_of_known_advisories",
                "name": "Direct dependencies free of known advisories",
                "detail": "1 affected: ibis-framework 5.1.0 (critical)",
                "points": 7,
                "status": "partial",
                "details": [
                  {
                    "code": "advisories_affected",
                    "params": {
                      "count": 1,
                      "packages": "ibis-framework 5.1.0 (critical)"
                    }
                  }
                ],
                "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": "1 advisory-carrying package(s) unaddressed past 90 days; oldest published 984 days ago",
                "points": 32,
                "status": "partial",
                "details": [
                  {
                    "code": "advisories_stale",
                    "params": {
                      "days": 90,
                      "count": 1,
                      "oldest": 984
                    }
                  }
                ],
                "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": 88,
              "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": 5
            },
            "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": "moderate",
        "name": "AI Readiness",
        "value": 50,
        "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": 1,
              "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": "86 of 86 human commits state their intent (structured subject or explanatory body)",
                "points": 40,
                "status": "met",
                "details": [
                  {
                    "code": "legible_history",
                    "params": {
                      "legible": 86,
                      "sampled": 86
                    }
                  }
                ],
                "max_points": 40
              }
            ]
          },
          {
            "key": "ai_verify_loop",
            "band": "moderate",
            "name": "Verify loop (build / test / typecheck)",
            "note": null,
            "notes": [],
            "value": 61,
            "inputs": {
              "has_nix": false,
              "has_tests": true,
              "lockfiles": [],
              "has_dockerfile": true,
              "typed_language": false,
              "bootstrap_files": [
                "noxfile.py"
              ],
              "has_devcontainer": false,
              "has_linter_config": true,
              "typecheck_configs": [],
              "agent_commit_share": 0,
              "toolchain_manifests": [],
              "dependency_bot_commit_share": 0
            },
            "components": [
              {
                "key": "one_command_bootstrap",
                "name": "One-command bootstrap",
                "detail": "noxfile.py",
                "points": 18,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "noxfile.py"
                    }
                  }
                ],
                "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": ".flake8",
                "points": 11,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": ".flake8"
                    }
                  }
                ],
                "max_points": 11
              },
              {
                "key": "static_type_checking",
                "name": "Static type checking",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 11
              },
              {
                "key": "reproducible_environment",
                "name": "Reproducible environment",
                "detail": "Dockerfile",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "Dockerfile"
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "demonstrated_agent_practice",
                "name": "Demonstrated agent practice",
                "detail": "no agent-authored commits among the last 100",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_agent_authored_commits",
                    "params": {
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "automated_maintenance",
                "name": "Automated maintenance",
                "detail": "no automated dependency updates observed",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_dependency_automation",
                    "params": {}
                  }
                ],
                "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": "moderate",
            "name": "Code legibility for models",
            "note": null,
            "notes": [],
            "value": 53,
            "inputs": {
              "primary_language": "Python",
              "largest_source_bytes": 69773,
              "source_files_sampled": 105,
              "oversized_source_files": 4
            },
            "components": [
              {
                "key": "type_checkable_code",
                "name": "Type-checkable code",
                "detail": "Python without a type-check config",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_typecheck_config_language",
                    "params": {
                      "language": "Python"
                    }
                  }
                ],
                "max_points": 45
              },
              {
                "key": "manageable_file_sizes",
                "name": "Manageable file sizes",
                "detail": "4/105 source files over 60KB",
                "points": 52.9,
                "status": "partial",
                "details": [
                  {
                    "code": "oversized_source_files",
                    "params": {
                      "kb": 60,
                      "sampled": 105,
                      "oversized": 4
                    }
                  }
                ],
                "max_points": 55
              }
            ]
          },
          {
            "key": "ai_interfaces",
            "band": "at_risk",
            "name": "Machine-readable interfaces",
            "note": null,
            "notes": [],
            "value": 40,
            "inputs": {
              "example_dirs": [
                "samples"
              ],
              "has_mcp_signal": false,
              "api_schema_files": []
            },
            "components": [
              {
                "key": "api_schema_openapi_graphql_proto",
                "name": "API schema (OpenAPI/GraphQL/proto)",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 40
              },
              {
                "key": "mcp_server",
                "name": "MCP server",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 20
              },
              {
                "key": "runnable_examples",
                "name": "Runnable examples",
                "detail": "samples",
                "points": 40,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "samples"
                    }
                  }
                ],
                "max_points": 40
              }
            ]
          }
        ],
        "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-29T17:15:50.243871Z",
  "schema_version": "0.27.0",
  "badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/g/GoogleCloudPlatform/professional-services-data-validator.svg",
  "full_name": "GoogleCloudPlatform/professional-services-data-validator",
  "license_state": "standard",
  "license_spdx": "Apache-2.0"
}

Scores are signals, not warranties. They reflect publicly visible practices on GitHub — not a code audit, and not a security guarantee.

Missing data is excluded and weights renormalized, never scored as zero. Methodology is versioned and open: metrics v1.13.0, schema v0.27.0 — full methodology · metrics wiki.

How one result sits in the wider record: aggregate statisticsPyPI.