MotherDuck UI quick tour
Login
To log in to MotherDuck UI, please go to app.motherduck.com. You will be redirected to our web UI.
Executing a sample query
After you log in, run the following SQL query:
SELECT
date, project, count(*) as downloads
FROM 'https://motherduck-demo.s3.amazonaws.com/pypi_downloads.parquet'
GROUP BY date, project
ORDER BY date desc;
MotherDuck executes this query in the cloud. Query results are saved into your browser into an interactive panel for fast data exploration with data sorting, filtering, and pivoting.
Write queries with Autocomplete
MotherDuck Web UI supports autocomplete. As you write SQL in the UI, on every keystroke autocomplete brings up query syntax suggestions. You can turn off autocomplete in Web UI settings, found under the gear icon in top right.
Keyboard shortcuts
MotherDuck supports the following keyboard shortcuts.
Use Alt
for Windows/Linux and ⌥
for Mac.
Use Ctrl
for Windows/Linux and ⌘
for Mac.
Command | Action |
---|---|
Ctrl/⌘ + Enter | Execute query in currently selected cell. |
Alt/⌥ + Enter | Execute query in currently selected cell, then insert new cell at bottom of notebook and select the new cell. |
Tab | When editing a query, indent current line. When navigating the notebook, advance to next UI element/button. Hit Esc to allow Tab to no longer indent current line and advance to next UI element instead. |
Shift + Tab | When editing a query, de-indent current line. When navigating the notebook, move to previous UI element/button. Hit Esc to allow Shift-Tab to no longer de-indent current line and move to previous UI element instead. |
Esc | Change Tab key behavior to navigate the UI instead of indent/de-indent editor text. Once another cell is selected, Tab behavior reverts to indent/de-indent. |
Ctrl/⌘ + / or Ctrl + / | Toggle comment on all highlighted lines in query editor by prepending or removing "-- " at the start of each line. Will comment out the highlighted lines unless all lines are already commented out, in which case it will uncomment. |
Ctrl/⌘ + z | Undo query edits within currently selected cell. |
Ctrl/⌘ + Shift + z | Redo query edits within currently selected cell. |
Ctrl/⌘ + ↑ | Move currently selected cell up. |
Ctrl/⌘ + ↓ | Move currently selected cell down. |