test.usql

DECLARE @file_set_path string = "/Data/SomeEntity/{date:yyyy}/{date:MM}/{date:dd}/SomeEntity_{date:yyyy}_{date:MM}_{date:dd}__{date:H}/test.csv";

// The "H" custom format specifier represents the hour as a number from 0 through 23; 

@input =
    EXTRACT [Id] long,
            date DateTime
    FROM @file_set_path
    USING Extractors.Csv();

@rdate =
    SELECT MAX(ProcessedDate) AS maxDate
    FROM dbo.SyncTable;

@output =
    SELECT *,
           date.ToString() AS dateString
    FROM @input AS i
         CROSS JOIN
             @rdate AS r
    WHERE i.date >= r.maxDate;


OUTPUT @output TO "/output/output.csv"
ORDER BY Id
USING Outputters.Csv(quoting:false);