Sky Cannon

The Sky Cannon is a rusted, ancient Oocca cannon found in 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.

Discovery and Repairs to the Sky Cannon
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". Link simply uses his Clawshot to enter the Cannon, and a rather frantic Ooccoo follows suit, from which the Cannon blasts Link to the City in the Sky, the seventh dungeon of the game.

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.

Hyrule Warriors
In and, The Sky Cannon appears as one of Twili Midna's movesets with the Mirror Weapon. When she summons it, it fires 3 huge Sol cannon balls at her enemies.

Trivia

 * Miniature models of Sky Cannons can be seen on the left side of the Oocca Shop
 * A humorous time-lapse video clip of Fyer's meticulous, rampant work on the Sky Cannon can be seen here.
 * Air Cannons, appearing in, are other cannons that can blast Link high in the air.
 * An infamous, game breaking glitch involves the Sky Cannon when Link saves the game in the room containing the cannon. When the file is reloaded, Shad will have disappeared and Midna cannot warp the cannon out because Shad is still watching, even though he is absent. If Link attempts to leave, Shad will tell him not to, resulting in the game becoming locked and Link stuck in the room.