Project Atlas AetherDev project hub
Atlas project maintenance

mssql_query_to_google_sheet

Rust CLI helper that executes SQL Server queries through ODBC and writes results into configured Google Sheet ranges.

Internal-only entry. Do not publish externally without review.
Type
Field Tool
Lifecycle
Maintenance
Last touched
2026-03-26
Visibility
Internal

Purpose

Provide a reusable SQL-to-Sheets transfer helper for BOUSD reporting pipelines.

Current state

Implementation is clear and operationally useful; Atlas classifies it as maintenance helper infrastructure rather than a standalone business workflow. Cross-repo evidence currently shows active extract families more often invoking `mssql_to_csv` or `mssql_query_to_csv`, with no strong direct runtime references to this binary in active scheduler examples. Current scheduler evidence does not show active invocation: no `mssql_query_to_google_sheet` task entries appear in the `saw-01` Task Scheduler artifact, and no direct path references appear in `aether/docs/cron-example.txt`.

Next step

Close lifecycle status explicitly: either document concrete production workflows that still call this binary (host/scheduler/manual trigger plus operator ownership), or mark it as helper-only/dormant with preferred successors (`mssql_to_csv` / `mssql_query_to_csv` + `google-sheet-download`).

Interfaces

Inputs
  • ODBC SQL query result set
  • config.toml sections for database/query/google
Outputs
  • CSV query output
  • Google Sheet value-range update

Reality to Action trace

Reality Ingestion

Contributes in this stage.

Canonical Storage

Not in scope.

Automation Engines

Not in scope.

Human Interfaces

Contributes in this stage.

Operational Adoption

Not in scope.

Core workflow

TBD. Document the 5-10 steps that define the core workflow.

Artifacts

  • config.toml
  • sql/*.sql
  • CSV output files

Operational notes

Constraints and scars

  • ODBC environment setup is a frequent runtime friction point.
  • Destination sheet ranges must stay aligned with query output schema.

Reliability posture

Config-driven and deterministic, but explicit retry and notification logic are limited.

Observability

  • CLI stdout/stderr
  • CSV artifacts

Security and privacy

Contains credentialed database and sheet access paths. Keep secrets out of source and restrict artifact access.

Dependencies

Upstream
  • SQL Server ODBC DSN
  • Google Sheets API credentials
Downstream
  • Spreadsheet-driven dashboards and reporting workflows

Ownership

Owners

Josh Barton

Users

Technology Services

mssql_query_to_google_sheet

Where It Fits

This project appears repeatedly as a helper component behind larger extract/report workflows.

Validation Needed

  • Concrete production job list using this binary (script path, scheduler/manual trigger, host, technical operator, business owner if applicable).
  • If no active jobs are evidenced, confirm helper-only/dormant posture and preferred successors (mssql_to_csv / mssql_query_to_csv + google-sheet-download patterns) in the Lifecycle Decision Queue.