motherduck

Using MotherDuck

lea works with DuckDB, and thus can be used with MotherDuck too.

Here is an example .env file:

echo "
LEA_USERNAME=max
LEA_WAREHOUSE=duckdb
LEA_DUCKDB_PATH=md:jaffle_shop
MOTHERDUCK_TOKEN=<provided by MotherDuck>
" > .env

The token can be obtained by logging into MotherDuck from the terminal, as documented here.

Then, you can run the usual commands. For the sake of example, let's re-use the jaffle shop views:

lea prepare ../jaffle_shop/views

Created schema analytics
Created schema staging
Created schema core

lea run ../jaffle_shop/views

You should see the views in your MotherDuck UI: