RefreshSchedule cannot be created as expected

Question & Answer
, , ,
1

I want to create a RefreshSchedule with updates scheduled at 00:00 daily.
Deployment by CloudFomation is successful, but when I check the schedule from the management console, there is an error.

CloudFormation Yaml:

QuickSightDataSetRefresh:
  Type: AWS::QuickSight::RefreshSchedule
  Properties: 
    AwsAccountId: !Ref AWS::AccountId
    DataSetId: example-set
    Schedule:
      RefreshType: FULL_REFRESH
      ScheduleFrequency:
        Interval: DAILY
        TimeOfTheDay: '00:00'
      ScheduleId: example-set

Error:

スクリーンショット 2023-10-13 8.38.03
スクリーンショット 2023-10-13 8.38.032794×1506 260 KB

Do I need to set StartAfterDateTime if I want to set the same result as cron(0 15 * * * ? *)?

2

hi @ss49919201

yes, would you be able to set StartAfterDateTime with YYYY-MM-DDTHH:MM:SS format for the timing that refresh scheduled can be started?

kind regards,
Wakana

3

Hi @Wakana
Thanks to reply!
I could understand that the StartAfterDateTime setting is required.

I would like to see CreateRefreshSchedule generate an error and fail the call if a past date is entered for StartAfterDateTime.
It would be great if you could add it to the feature request!

4

hi @ss49919201

when refresh schedule is created first time, StartAfterDataTime field requires to have future datetime, as QS can’t schedule based on the past datetime. but once it is created, the schedule runs at 12am on daily basis from the StartAfterDateTime you specified. would there be some other issues you are facing ?

kind regards,
Wakana

5

Hi @Wakana

when refresh schedule is created first time, StartAfterDataTime field requires to have future datetime

Yes, I understand that.
I think the problem is that when I run CreateRefreshSchedule, it allows past dates.

6

Hello @ss49919201 !

I can mark this as a feature request!