Motherduck and Malloy

Motherduck is cloud based scale out relational SQL database.

vscode.dev is a web based version of VSCode that runs entirely in your browser. VSCode.dev can direcly work with github repositories from your web browser. You can create make branches, edit files and push back to the repositories without need a local machine.

Malloy is a semantic data modeling and query language that among other things runs as an extension in VSCode.

Together these three components make a great way to explore and access data.

This repository is an example of using these three components together. The example uses several datasets stored and shared in Motherduck. Loading the datamodels from this repository, into Malloy in vscode will allow you to build and run data analysis against the data in Motherduck using only your browser. You can modifiy these examples and/or follow this pattern with your own data.

To run these examples from a web browser

1. Goto https://app.motherduck.com and create an account
2. Goto https://insiders.vscode.dev/github/malloydata/motherduck-examples?vscode-coi=
3. Install the Malloy VSCode Extension (it should prompt you)
4. Goto Motherduck and click settings then 'Copy Token'
5. Open a Malloy file in the files pane for example imdb.malloy.
6. Click on the 'M' in the right panel andd open Open Connections and make a new connection type: 'DuckDb' name: 'md', add your mother duck token
7. Run the Open the attach data notebook
8. Click 'Run All' to attach the example data to your motherduck database.

To run these examples from a local version of VSCode

1. Goto https://app.motherduck.com and create an account
2. install VSCode
3. At a command shell

   git clone https//malloydata/motherduck-examples.git
   cd motherduck-examples
   code .
   

4. Install the Malloy VSCode Extension (it should prompt you)
5. Goto Motherduck and click settings then 'Copy Token'
6. Open a Malloy file in the files pane for example imdb.malloy.
7. Click on the 'M' in the right panel andd open Open Connections and make a new connection type: 'DuckDb' name: 'md', add your mother duck token
8. Run the Open the attach data notebook
9. Click 'Run All' to attach the example data to your motherduck database.

Run any of the examples.

FAA

• Carrier Analysis

IMDB

• IMDB overview
• Genre Analysis
• Genre Matrix (genre co-occurance)

Ecommerce

• Brand Synergy

open setting`