I’m building a Quick Suite app (sort center volume forecasting tool) and need the ability to programmatically query/ingest data from a QuickSight dataset directly into my app logic — not just embed dashboard visuals. Something like the below:
-
Connect to a QuickSight dataset (by dataset ID or name)
-
Query or fetch data from that dataset (ideally with filtering/aggregation support)
-
Receive structured data (rows/columns as JSON) that I can use in my app logic
Why This Matters
-
Embedding visuals is great for static reporting, but I’m building an interactive operational tool that needs to transform, combine, and reason over raw data
-
My dataset refreshes in near-real-time, and I want my app to reflect that freshness
-
Without this, I’d have to duplicate the data pipeline outside of QuickSight, or ask my DE team to standup a REST API endpoint for these datasets.. which defeats the purpose of having datasets already defined in quick
Use Case
-
operations volume-forecasting app with aggregation / filtering capabilities
-
Needs real time data (I have what I need in 4 distinct datasets already live in Quick)
-
App applies AI-driven forecasting and correction scalars on top of the raw data
-
Custom heatmap and drill-down views that can’t be achieved with standard dashboard visuals alone
Is this something that exists and I am just unaware? Or is there a way to accomplish the same in Quick Apps.
Thank you!
Hi @pattscot,
Welcome to the Amazon Quick Community! It is not currently possible to connect to a dataset through a parameter like a dataset ID. I would recommend querying your 4 underlying data sources directly via SQL, which will allow you to obtain the real-time data you need for aggregations and your specific use cases like custom heatmaps and drill-down views. Note that parameters and filters in the Quick Sight dataset editor apply only within Quick Sight itself and are not accessible to external app logic, so filtering and aggregation will need to be handled in your SQL queries directly.
Please feel free to let me know if this answered your question fully and/or if you have any other questions!
Please clarify if you can - Does the Quick Apps feature allow me to access data directly from the datasets? I don’t need to create a quicksight dashboard, but I want to build an interactive app that is fed by a dataset already available (I made it) in quick. Wouldn’t querying / aggregating in advance still lead me to the same problem with how I can feed data to the application I am creating?
Or another question - what type of inputs will Quick apps accept for (near) real time data, and if its only API is their a workaround to get me close until I can stand an endpoint up?
Hi @pattscot,
Apologies, as I misunderstood your question in my previous response. This should definitely be achievable within the Quick Apps UI. You can connect the 4 datasets that you want to incorporate into a Space, and then from there you can ask the Apps chat agent to format and retrieve data to accomplish the use case you mentioned.
Here is some documentation that goes a little further in depth regarding Apps. Please let me know if this helped and if you have any other specific questions!