As part of Sidon of Zora’s main quest in Zelda: Tears of the Kingdom, you will have to find and pick up a unique fish, the Ancient Arowana. The Ancient Arowana fish is a yellow-colored, rare fish that is required to restore the Zora Armor. This armor allows you to swim up waterfalls in Zelda: TotK and ultimately reach the Water Temple.
As a reward for finding Ancient Arowana and giving it to Lady Yona, you will be given the first piece of Zora armor and can then move to the other quest objectives.
How to start the Sidon of Zora quest in Zelda: TotK
As mentioned, finding the Ancient Arowana fish is a part of one of the branches; Sidon of Zora of the main story quest Regional Phenomena.

To get the Sidon of Zora quest, you need to head towards Zora’s Domain in Lanayru Great Spring. Head inside the domain and talk to Yona. This will start Sidon of Zora, and the first step you need to do for this is to find Ancient Arowana to continue with the Restoring the Zora Armor objective.
Ancient Arowana Location in Zelda: TotK
To find the Ancient Arowana fish, you need to head towards the Shatterback Point in the Lanaryu Great Spring Region. This place is close to Mipha’s Court.

You can easily arrive here by fast traveling to Ihen-a Shrine on the north of the Shatterback Point and on the east of Zora’s Domain.
Continue down the water stairs and find Gruve in the water pool north of the Shatterback Point.
Inside the pool are Ancient Arowana fish. You can either swim towards them or shoot an arrow at them to collect them.
Alternatively, we were also able to find the Ancient Arowana fish on the Great Sky Island. You have to arrive at the waterfall basin located on the west side before the large lake.

There, you can clearly see yellow fish swimming in the water basin. These are the Ancient Arowana fish. To get them, you can approach them or you can shoot an arrow at them to collect them in your inventory.
You only need one Ancient Arowana to complete this part of the quest. Bring the fish back to Yona at Zora’s Domain and give it to her. As a reward, she will give you the first piece of the Zora Armor. Now you are ready to meet King Dorephan and eventually complete Clues to the Sky.