Passer au contenu

Real Time Data Ingestion

0

IHAC working on enabling real time Data ingestion on their S3 based Datalake with the objective of showing near-realtime data on QuickSight Dashboards. As of now, they are heavily relying on QuickSight SPICE engine for better Dashboard performance since direct Athena queries from QuickSight are not so performant. With Realtime data flowing into the Datalake, they need to refresh QuickSight SPICE datasets very frequently. However, they are hitting a limitation of 32 calls per 24 hours on CreateIngestion API to refresh Quicksight SPICE dataset. This is a serious blocker for them. Could you please suggest how can they overcome this limitation and move forward.. An error occurred (LimitExceededException) when calling the CreateIngestion operation (reached max retries: 2): Rate exceeded for CreateIngestion on this dataset. Please retry after 1304 minutes

AWS

demandé il y a 2 ans332 vues

1 réponse
0

Hi,

Since you are allowed to 32 full refreshes per day, you are probably using the Enterprise edition of QuickSight.

In that case, you can also use the incremental refresh (i.e. up to every 15 min) in order to refresh your SPICE data. Did you consider it?

See https://docs.aws.amazon.com/quicksight/latest/user/refreshing-imported-data.html#refresh-spice-data-incremental

Best,

Didier

EXPERT

répondu il y a 2 ans

  • Thanks for the recommendation Didier. Cx is looking for near real time data refresh. Incremental refresh may run with out limit exceptions but there is a 15 minute delay which is long time for this requirement.

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.