I have two spice datasets in a Q topic. When refresh of one dataset is in progress, I get the following error when I click on “Refresh now” for the second dataset-
“Something went wrong when updating topic metadata”
I don’t face this error when another dataset refresh is not in progress.
How can I refresh multiple datasets in a topic at the same time?
Hi @taliyan,
QuickSight does not allow two datasets within a topic to be updated at the same time. Since Q creates an index for a given topic, this limitation is in place to avoid conflicts between the two datasets and the overlying topic.
Let me know if I can assist with any additional questions!
Thank you for the clarification. I have one additional question- if the underlying spice datasets are scheduled for daily refresh, do we need to refresh the corresponding datasets in the topic as well? Will the topic pick up new data from spice dataset without a refresh schedule / manual refresh on topic?
Hi @taliyan,
If you have the underlying datasets set to refresh daily, you should not need to trigger a refresh in the topic as well if just dealing with updated data. If there is a change to fields (adding/removing), then you may need to update in the topic though.
Let me know if you have any additional questions!
Thanks Brett!
To understand it clearly, does Q not need a refresh to index the new strings in existing fields as a result of updated data?
Is there a recommendation for how often the index should be refreshed once the development of topic has been completed?
Hi @taliyan,
If you’ve updated your data outside of the topic, it should update within Q as well. I would suggest double checking though to make sure that is correct after you do this:
In regards to how often it should be refreshed; I would suggest after making a number of updates or before you’re getting ready to utilize would probably be the best scheduling practice.
Let me know if you have any additional questions!
Hi @taliyan,
It’s been awhile since we last heard from you so following up to see if you have any additional questions?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Thank you!
Hi @taliyan,
Since we haven’t heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
Thank you!
