Intelligence · Component · warehouse-query-adapter
Authenticated warehouse query adapter
What it does
Submits and polls Adhoc SQL jobs, resolves account roles, downloads full results and normalizes datasets for table/JSON/CSV output.
Core pattern
Authorized query submission and polling + normalized result tables
- Input
- Authorized SQL request
- Output
- Rows, columns, job status and result metadata
Key parameters
| Name | Type | Default | Values |
|---|---|---|---|
| operation | string | submit | submit · poll · download · execute |
| query | string | — | — |
| values | — | — | — |
| engine | — | — | — |
| role | — | — | — |
Maturity and limits
Reusable AdhocClient, typed configuration, full-result download and CLI implementation are present. Phase 2: source paths and implementation inspected statically; tests and external integrations were not executed. Maturity rates repository implementation, not a verified production deployment.
Internal network and warehouse permissions; config with credentials present; arbitrary SQL is not restricted to reads by the adapter; optional TLS bypass exists.
1 sentence citing source paths or vendor names omitted for publication.
Used in pipelines
Industry tags
- Travel & hotelsSource-supported industry
For work involving destinations, room rates and bookings, use authorized query submission and polling followed by normalized result tables.
- Logistics & supply chainTransferable use
For weekly review of warehouse orders and delivery lead times, use authorized query submission and polling followed by normalized result tables.
Skills pack
Contract scaffold and deterministic mock
Download · 11KBSHA-256 4ca7e41c0b58fa227d82cb6bb5c239c3592480261f87df7db51b154db448192a
Related components
-
Announcement event studies
Events aligned with historical values + windowed outcome analysis
Working 1 pipeline -
Campaign and holiday evidence enrichment
Changes aligned with calendar candidates + source review queue
Working 1 pipeline -
Audited curation and database publishing pipeline
Human merge and override decisions + controlled data sync
Working 1 pipeline -
Dashboard table extraction
Authorized dashboard table extraction + scope and source metadata
Working 1 pipeline