[DS9] Season 3, Episode 15: Destiny
This episode isn’t that great. I tend not to be too interested in Bajoran prophecy stuff.
Read more at Memory Alpha
Notes:

A Bajoran guy warns Sisko about a prophecy about three snakes and a sword of stars and bad things follow. He thinks the Cardassians are the snakes.

Turns out the prophecy still was true, it just meant totally different stuff than they thought. The “three snakes” meant three pieces of a comet, obviously.

At the end this guy warns Sisko that he will face a fiery trial, just like how those three Cardassians were snakes.
<Previous Episode——————————————————– Next Episode>