Setup dataset IncrementalRefresh LookbackWindow in cloudformation

Q&A
,
1

Hi team,

I want to Setup dataset IncrementalRefresh LookbackWindow in cloudformation when creating dataset.

I find documents about this. But I don’t know how to use it in my cloudformation. Could you please share a sample usage in cloudformation?

And if this is a available config to setup IncrementalRefresh LookbackWindow?

Best Regards,

Archie

2

Hi @Archie1,

While I do not have an exact sample of something that’s deployed and operational, it may look something along the lines of this:

{
“Resources”: {
“MyQuickSightDataset”: {
“Type”: “AWS::QuickSight::DataSet”,
“Properties”: {
“AwsAccountId”: { “Ref”: “AWS::AccountId” },
“DataSetId”: “my-dataset-id”,
“Name”: “My Dataset with Incremental Refresh”,
“ImportMode”: “SPICE”,
“PhysicalTableMap”: {
“sourceTable”: {
“RelationalTable”: {
“DataSourceArn”: “arn:aws:quicksight:us-east-1:123456789012:datasource/my-datasource”,
“Schema”: “public”,
“Name”: “my_table”,
“InputColumns”: [
{ “Name”: “event_time”, “Type”: “DATETIME” },
{ “Name”: “user_id”, “Type”: “STRING” },
{ “Name”: “metric_value”, “Type”: “INTEGER” }
]
}
}
},
“IncrementalRefresh”: {
“LookbackWindow”: {
“ColumnName”: “event_time”,
“Size”: 3,
“SizeUnit”: “DAY”
}
}
}
}
}
}
3

Thank you! I’ll give it a try.

4

I just realized that I was using the documentation in the wrong way. I was able to find the correct usage from the dataset page.