I currently have a baseview that with an interpolation variable for a date value that can be used to dynamically target a specific CSV file on AWS S3 as the source.
select * from hcc_dv.dv_ctigeneral_s3_gdw_backupdate
where backupdate = '09-01-2021'
I am investigating ways to parse for specific users and dates across a range of dates. The "backupdate" variable is a text value since it is part of the file name. Is there any easy way to search for a range for dates? I tried to localdate funciton, but that is causing an error.
I can do a IN statement like this but sometimes there are 100 files we need to check.
select wwid, name, status from hcc_dv.dv_ctigeneral_s3_gdw_backupdate
where backupdate in ('09-01-2021', '10-01-2020') and wwid = 12345
any thoughts or suggestions?