🙋♂️ Similar problem here as well. I ended up avoiding hourly partitions for newer assets; there are just too many rough edges right now. I use daily partitioning instead, which creates other problems, but they’re more manageable since I can do it in my own code.
There was
this issue that ended up creating the “Pass partition ranges to single run” feature, which is good, but probably not general enough. There’s
this discussion that is related and might be a good place to hash out other ideas.