# Desk log NMD-ADE-20260822

**Status:** First-party InfiniSynapse desk log (sanitized composite; not a customer extract)  
**Page:** https://infinisynapse.com/en/blog/analyze-database-without-etl  
**Run ID:** `NMD-ADE-20260822`  
**Date:** 2026-08-22 (Saturday)  
**Operator:** InfiniSynapse Data Team  
**Attestor:** William Zhu, InfiniSynapse cofounder ([GitHub @allwefantasy](https://github.com/allwefantasy))  
**Contact for contradictions:** zhuhl@infinisynapse.com

## What this file is

A downloadable record of opening an ETL-first copy ticket versus authorizing a live Postgres store as the source. It is **not** a named-logo customer case, a vendor bake-off, or a PostgreSQL / Snowflake / OWASP experiment.

## Four-step method (reproducible)

1. Create a SELECT-only role. Confirm grants. Prefer a replica if the primary is busy.
2. Authorize host, port, and the role. Recall tables. Bind a note if a name is wrong.
3. Ask one goal: Q2 refund rate by channel, paid orders as the denominator, exclude test accounts.
4. Inspect SQL, filters, and the join. Re-ask after the note is corrected.

## Source and goal

| Field | Value |
|---|---|
| Sources | Read-only Postgres; 14 order-related tables; ~2.1 million paid-order rows |
| Standing goal | Q2 refund rate by channel, paid orders as denominator, exclude test accounts |
| Contrast | ETL-first ticket vs live connect |

## Results

| Retrieval state | Read-only role authorized | Channel note bound | SQL + filter inspectable |
|---|---|---|---|
| ETL-first ticket | 0 | 0 | 0 |
| Live connect | 1 | 1 | 1 |

Wall-clock for the successful live rerun: 10 minutes (warehouse time excluded). The clock started when the operator opened the standing goal and ended when the authorized role, the bound note, and the inspectable SQL sat side by side.

## What you may cite

- Artifact counts 0/0/0 → 1/1/1, 14 tables + ~2.1M paid-order rows on this run, ~10 min wall-clock, run ID

## What you may not claim

- Customer uplift %, a faster warehouse, official EEAT score, named-logo case, or that PostgreSQL / Snowflake / OWASP / DataCite / W3C / ISO / Gartner / WAIC scored this run

## Independent context (not this run)

- [PostgreSQL Privileges](https://www.postgresql.org/docs/current/ddl-priv.html) (retrieved 2026-08-29)
- [PostgreSQL GRANT](https://www.postgresql.org/docs/current/sql-grant.html) (retrieved 2026-08-29)
- [MariaDB GRANT](https://mariadb.com/kb/en/grant/) (retrieved 2026-08-29)
- [Snowflake warehouses](https://docs.snowflake.com/en/user-guide/warehouses-overview) (retrieved 2026-08-29)
- [Amazon Redshift Database Developer Guide](https://docs.aws.amazon.com/redshift/latest/dg/welcome.html) (retrieved 2026-08-29)
- [OWASP Top 10 for LLM Applications](https://owasp.org/www-project-top-10-for-large-language-model-applications/) (retrieved 2026-08-29)
- [ISO/IEC 9075](https://www.iso.org/standard/76583.html) (retrieved 2026-08-29)
- [W3C DCAT](https://www.w3.org/TR/vocab-dcat-3/) (retrieved 2026-08-29)
- [DataCite](https://datacite.org/) (retrieved 2026-08-29)
- First-party homepage recognition only (self-described; not independently verified here): [2026 WAIC Future Tech OPC Excellence Award](https://infinisynapse.com/#recognition)

## Machine-readable aggregate

- [aggregate-NMD-ADE-20260822.csv](./aggregate-NMD-ADE-20260822.csv)
- [verify-NMD-ADE-20260822.py](./verify-NMD-ADE-20260822.py)