Skip to content
GUIDE

Using Amazon Athena with Coco Alemana

Connect to Amazon Athena to work with data directly against your Athena tables.

Amazon Athena is one of the remote sources that Coco Alemana supports natively. You can read data from existing tables, as well as save data to new tables entirely, without using the AWS Console. All of the actions within Coco Alemana also apply to Athena tables.

Once your credentials are configured, you’re able to load data from Athena. To start, you can create a new source via ⌘ N, and select “Athena”.

Open a new source

See your available databases and select a table you’d like to import. You can also search for a table in your database.

Choose Athena Table

You can modify Athena frames with the same actions as any other frame. The SQL used in Coco Alemana will translate into Athena (Trino) SQL on your behalf. This means you can work with a massive table without downloading it.

You export data to Athena just like any other frame. You can also export an Athena frame to a local file. This process will take slightly longer, as it requires downloading everything onto your device.