Unable to deploy Timestream scheduled query when querying an empty table

[furrycatherder]

Name of the resource

AWS::Timestream::ScheduledQuery

Resource name

No response

Description

Attempting to deploy a ScheduledQuery that queries an empty table results in an exception:

ScheduledQuery: Resource handler returned message: "line 12:25: Column 'foo' does not exist (Service: AmazonTimestreamQuery; Status Code: 400; Error Code: ValidationException; Request ID: OSQH3TTQWMV4BP6W7NKAZS324M; Proxy: null)" (RequestToken: a86574da-20c5-0081-1c7f-05eae4b55b2f, HandlerErrorCode: InvalidRequest)

It would be nice if this were a warning instead of an error, or if the construct could be deployed but execution deferred until the validation passes. The current behavior makes deployment of tiered scheduled queries especially inconvenient.

Other Details

No response