There’s likely a compatibility issue on to_timestamp() with AWS Redshift and the following is the error that I get when Date range control tries to query Redshift:
Redshift’s SQL language doesn’t have a to_timestamp() function that takes in a numeric value.
What would be a workaround? Thanks,