Creating dataset (in direct query mode) on aurora postgresql db view is a feasible solution for my project. But while accessing the dataset in dashboard, the data retrieval is taking some time based on data volume and throwing error. Any suggestion please

Question & Answer
2

Hi,

I looks that your query has some issues and taking too much time to retrieve data.
You can check you joins are proper or not.

Direct query work perfect on small tables like dimensions.
On fact tables you need to use the SPICE, SPICE is cost effective. :slight_smile:

regards,
Naveed Ali

2 Likes