I need to schedule a automatic topic refresh for weekly basis. I did through the below command but still it is running daily. Anything missed here?
aws quicksight create-topic-refresh-schedule --aws-account-id XXXX --topic-id XXXX --dataset-arn XXXX --refresh-schedule IsEnabled=true,BasedOnSpiceSchedule=true,StartingAt=“2023-06-12T12:15:00Z”,RepeatAt=“Monday”,TopicScheduleType=“WEEKLY” --profile stg
Do you now have two refresh schedules?
Do you need to delete the daily one?
@Max ,
No, I have only one refresh schedule and I need to schedule it for weekly once. I am using the below command.
aws quicksight create-topic-refresh-schedule --aws-account-id XXXX --topic-id XXXX --dataset-arn XXXX --refresh-schedule IsEnabled=true,BasedOnSpiceSchedule=true,StartingAt=“2023-06-12T12:15:00Z”,RepeatAt=“Monday”,TopicScheduleType=“WEEKLY” --profile stg
But it is running daily even though I configured for weekly. Also i have described and attached in the previous post.
Can you show me a screen shot of what it looks like in the AWS quicksight console?
I scheduled for Saturday(10-06-2023) initially on weekly refresh, but it got ran for the below schedules
This is shown when i click the below highlighted button
Note: The dataset refresh of this topic is configured daily
Hi @Sharmili - Can you update the parameter BasedOnSpiceSchedule to false. As per document
A Boolean value that controls whether to schedule runs at the same schedule that is specified in SPICE dataset.
Link - create_topic_refresh_schedule - Boto3 1.26.151 documentation
Please do a poc and see whether it is working for you not.
Regards - Sanjeeb
Hi @Sharmili - Can you please raise a ticket to AWS Customer support team to help you on this as Q topic is fairly new for all of us. To raise the ticket, please follow the link - Creating support cases and case management - AWS Support
Regards - Sanjeeb
Hi @Sharmili,
Topic refresh schedules for SPICE datasets can be set to run on SPICE refresh schedule only. The BasedOnSpiceSchedule boolean overrides other settings when true. (I have submitted a ticket for updating the help doc to state this explicitly - Internal ticket link )
It is good to have the topic refresh in sync with the SPICE dataset so that it is able to give you suggestions based on the latest data. If you have an edge case wherein you absolutely don’t want to Q topic to refresh daily even though the dataset is getting refreshed daily, a potential workaround is to create a child dataset from the SPICE dataset, leave this child dataset in Direct Query mode, create a topic using this child dataset and define a weekly refresh schedule therein.
(Again, our recommendation is to have the topic refresh in sync with the dataset and above suggestion is only to help you in case you have a valid edge case)
Regards,
Arun Santhosh
