About MotherDuck

MotherDuck is one of the remote sources that Coco Alemana supports natively. Because MotherDuck is a cloud warehouse built on DuckDB — the same engine behind CocoSQL — it’s the closest match to how Coco Alemana works internally. You can read data from existing tables, as well as save data to new tables entirely, without using the MotherDuck web UI.

Note

You’ll need to connect at least one MotherDuck account to continue.

For more information, see Connect to MotherDuck

Load a Table from MotherDuck

1. Open a new source

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

2. Select a Table

See your available databases and select a table you’d like to import. The number next to each database is how many tables it contains. You can also search for a table.

Note

Databases without any tables don’t appear in the list.

Modifying MotherDuck Tables

You can modify MotherDuck frames with the same actions as any other frame. Because MotherDuck runs DuckDB, the SQL used in Coco Alemana runs against it essentially as-is — no translation layer in between. This means you can work with a massive table without downloading it.

Exporting Data

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

Compatibility

MotherDuck is the most compatible remote source Coco Alemana supports. MotherDuck and CocoSQL share the same engine, so types, functions, and semantic behavior line up almost exactly — the translation caveats that apply to other sources don’t apply here.

Version Pinning

Each release of Coco Alemana ships with a specific, tested version of the MotherDuck connector built in. Nothing is downloaded at runtime. If MotherDuck ever requires a newer connector than the one your version of Coco Alemana ships, updating the app resolves it.