Will pinot automatically delete segments from S3 when a table is deleted? Based on what I've seen, it looks like deleting a realtime table will eventually delete the segments associated with that table. But I'm not sure if this behavior is also true for offline tables where the segments are generated and uploaded with SegmentCreationAndMetadataPush?

Yes, segments will get deleted from S3 as well. One possible issue with

SegmentCreationAndMetadataPush

might be that if you haven't given write permissions to the S3 credential to pinot controller.

got it, thanks!