Live Data in Apps: Querying Governed Amazon QuickSight Datasets in Real‑Time
WebCrimp analysis and practical explanation. AI-assisted; reviewed before publication.
Quick Summary
Amazon Quick now lets AI‑built Quick Apps run live queries against governed QuickSight SPICE and Direct Query datasets, applying row‑ and column‑level security per viewer so the displayed numbers are always current and authorized.
What Happened?
The Live Data in Apps feature enables the Amazon Quick agent to discover approved datasets, generate the necessary SQL while building the app, and re‑execute that SQL each time a user opens the app. The query runs under the viewer’s identity, enforcing existing RLS and CLS rules, and requires per‑dataset consent on first use.
Why It Matters
Teams no longer need to manage static snapshots or manual data refreshes; they get up‑to‑date metrics instantly, while security and governance remain centralized in QuickSight, reducing the risk of exposing unauthorized data.
Who Can Use It?
Business · Sales · Data Analytics · Cloud · Finance · Marketing · Operations
How Can I Use This?
If you work in Business, Sales, Data Analytics, Cloud, Finance, Marketing, Operations
- Business analysts can create a live sales renewal tracker that shows quarterly renewals and projected revenue without writing SQL. Sales leaders can open the same app and see data filtered to their assigned regions, enabling quick deal‑review decisions. Data administrators rely on existing QuickSight security policies, knowing the app inherits RLS/CLS automatically. Knowledge workers in marketing or finance can add AI inference overlays to combine revenue data with strategy documents for richer insights.
AI Tip
If the agent does not surface a needed column, explicitly mention it in your prompt (e.g., “include the discount_rate column”) to ensure it is added to the generated query.
AI Trick
Ask the agent to add an AI‑powered summary overlay that evaluates deal viability based on revenue data and a linked product‑strategy document, then resize the overlay for better readability.
Example Workflow
- 1. Builder opens Amazon Quick Apps, describes the desired app in natural language. 2. Agent discovers relevant QuickSight datasets, proposes SQL, and asks for per‑dataset consent. 3. Builder approves, reviews a preview, iterates on features, then publishes the app. 4. Viewer opens the published app, gives one‑time consent per dataset, and sees live data filtered by their RLS/CLS permissions. Note: These steps should be verified against your organization’s specific Quick setup and permissions.
Copy This Prompt
Create an app that shows [metric] for [time period] broken down by [dimension] and allows [action] (e.g., send email, view details) when a record is selected.
Recommended Tools
- Amazon Quick
- Quick Apps
- Natural language prompt interface
- SQL query engine (SPICE/Direct Query)
Check official documentation, availability and pricing before using these suggestions.
Difficulty
Intermediate
Estimated Time Saved
Not measured; validate with your own workflow.
Source
AWS AI
Serve live, governed data in AI-built apps with Amazon Quick
Original publication date: 2026-10-01T19:49:06+00:00