I found 2 solutions: Using AWS Data Pipeline to schedule the query (Unload) and use ‘s3://reporting-team-bucket/importfiles/test_123-#{format(@scheduledStartTime,’YYYY-MM-dd-HH’)}.csv’ writing an MV command to rename the file on the s3 bucket Is there a way to give a file’s the current date by only using Redshift, with no other services? Here is my code so far: Just need to get CurrentDate to be