SYSTEM Cited by 2 sources
Amazon QuickSight¶
Amazon QuickSight is AWS's managed business-intelligence + analytics
platform — interactive dashboards, the SPICE in-memory engine, ML
Insights, pixel-perfect reports, and embedded analytics via signed
URLs (GenerateEmbedUrlForRegisteredUser) or SDK inside customer
applications.
Architectural primitives¶
- SPICE (Super-fast, Parallel, In-memory Calculation Engine) — QuickSight's columnar in-memory cache. Frequently-accessed or aggregated datasets get loaded into SPICE for subsecond query response; datasets that need real-time freshness use direct-query mode against the source database. See concepts/spice-in-memory-caching. Incremental refresh schedules keep SPICE-cached datasets current without full reloads.
- VPC connectivity — QuickSight can connect privately to databases inside a customer VPC using a VPC connection that terminates inside the customer VPC; Aurora PostgreSQL / RDS databases behind private subnets are reachable without public exposure. Credentials are typically stored in Secrets Manager and fetched at refresh time.
- Row-level security — dataset-level RLS rules let a single dashboard be safe across many tenants / roles with different data-access rights. Per-viewer context is passed via the signed embed URL. See concepts/row-level-security.
- Pixel-perfect reports — formatted documents suitable for printing / regulatory compliance, alongside the interactive dashboard UI.
- Embedded analytics via
GenerateEmbedUrlForRegisteredUser— the canonical API for minting per-viewer, time-limited, signed embed URLs that the host application loads inside an iframe. See concepts/signed-embed-url and patterns/signed-embed-url-with-role-mapping.
Seen in¶
- sources/2026-04-01-aws-automate-safety-monitoring-with-computer-vision-and-generative-ai — embedded inside the React safety-monitoring web application via AppSync + Lambda resolvers. Safety managers + operations leaders use QuickSight dashboards to see which facility zones are violation hotspots, shift-to-shift trends, violation-type distribution, and cross-facility benchmarking. Paired with Redshift Spectrum for querying risk data directly in S3 without ETL movement.
- sources/2026-04-21-aws-oldcastle-infor-aurora-quicksight-real-time-analytics
— canonical wiki instance of the SPICE + VPC-connected-Aurora +
signed-embed-URL composition at production scale. Oldcastle
deploys 50+ complex dashboards in 8 months embedded inside
Infor OS via API Gateway + Lambda calling
GenerateEmbedUrlForRegisteredUser, with 100+ concurrent users, SPICE in-memory caching for hot aggregates, VPC connectivity to Aurora PostgreSQL using Secrets Manager for DB credentials, calculated fields + parameters + row-level security, and pixel-perfect reports alongside the interactive dashboards. Primary canonical source for concepts/spice-in-memory-caching, concepts/signed-embed-url, concepts/embedded-analytics, and patterns/signed-embed-url-with-role-mapping.