Reaching the City in the Sky
Location and Uses
The Sky Cannon is a rusted, ancient Oocca cannon found in Twilight Princess beneath Renado's house in Kakariko Village. The Sky Cannon, when properly assembled and repaired, will send the "messenger who holds the Dominion Rod" to the City in the Sky, via Fyer's platform on Lake Hylia. The Sky Cannon can be obtained only after Link has possession of the Dominion Rod - the Owl Statue that guards the room where the Sky Cannon rests can only be moved by activating it with the Dominion Rod, similar to statues found in the Temple of Time dungeon.
After moving the Owl Statue with Shad in Renado's basement and finding the dilapidated, broken Sky Cannon in the subsequent room, Shad tells Link his best bet to get it repaired would be to take it to a cannon expert. Link goes to speak with Fyer, who immediately recognizes the huge, ancient cannon. Fyer says that he can repair the Sky Cannon for him, asking for an advance payment of an exhausting 300 Rupees for the job. Fyer then says he will "only be a minute", but in fact takes several days.
After the repairs are complete, Fyer warns Link that although the Sky Cannon looks like junk, it has some "powerful innards" and that Link will be "knocking on the doors of the Heavens". To use it, Link must simply use his Clawshot to enter and activate the Cannon. The first time Link uses the Cannon, and Ooccoo and Ooccoo Jr. join Link, blasting them to the City in the Sky. Miniature models of Sky Cannons can be seen on the left side of the Oocca Shop.
Even after Link completes the City in the Sky dungeon, the Sky Cannon will shoot him into the heavens whenever he pleases, and its counterpart in the heavens will do the same back to Hyrule.
Concept art of the Sky Cannon from Hyrule Historia