I tried to connect MongoDB and Quicksight using CDATA Connect Cloud. I successfully created the data source and was able to get the data from MongoDb to Quicksight, but when I try to make visuals, I’m getting this error.
When I click on Show Details, this is what i get:
Hello @maitreya10, when you saved your dataset into QuickSight, did you set it to Direct Query or SPICE? If you are using Direct Query, it may take to long to query the data directly from the database causing this error. Try editing the dataset to store in SPICE so it is immediately accesible by QuickSight to see if this fixes the error.
When you save and publish the dataset with SPICE, check the refresh time on the dataset to ensure it has finished running before testing in an analysis. Let me know if this helps!
@DylanM Thanks, this did work, but when I have high amounts of data and don’t want to purchase SPICE storage, how can I achieve the same?
QuickSight visual timeout is 2 minutes. If your backend cannot complete executing the query within 2 minutes, then the visual will timeout.
Possibly optimize how much of data is retrieved by using filters. If it still is timing out, then reduce the amount of data or aggregate to a higher granularity if possible. Else look at your mongodb configuration if it can be upgraded .
Kind regards,
Koushik
