# To Infinity and Be-Pond

THE CLOUD EXPEDITION! · level 1 · chapter 1

Professor Shellbert adjusts his spectacles gravely. 'Reports of strange migrations from distant lands — we need cloud data to investigate.' Captain Cloudsworth descends on a gust of wind. 'Then it's time you met MotherDuck — the ENTIRE WORLD at your wingtips!' Your first step: <span class='feature-highlight'>Connect to MotherDuck</span> and verify your cloud connection is live.

## Task

Click the <b class="text-orange-400">MotherDuck required</b> button above to connect. Once connected, verify your cloud connection is live by listing all databases attached to your session.

## Hint

Use SHOW DATABASES to list all databases attached to your MotherDuck session

## Expected result

A list of databases attached to your session, including dbquacks_cloud_expedition

## Tables

### `lake_visits` (500 rows)

| column | type |
| --- | --- |
| visit_id | BIGINT |
| duck_id | BIGINT |
| destination_pond | VARCHAR |
| visit_date | DATE |
| purpose | VARCHAR |

### `pondville_events` (50 rows)

| column | type |
| --- | --- |
| event_id | BIGINT |
| event_name | VARCHAR |
| event_date | DATE |
| organizer_id | BIGINT |
| location | VARCHAR |
| attendee_count | BIGINT |

### `pondville_residents` (100 rows)

| column | type |
| --- | --- |
| duck_id | BIGINT |
| name | VARCHAR |
| species | VARCHAR |
| home_pond | VARCHAR |
| age | BIGINT |
| occupation | VARCHAR |
| joined_date | DATE |

## Data

The tables live in a DuckDB database: https://dbquacks.com/data/databases/motherduck_tutorial.duckdb

To query it outside the browser, attach it read-only:

```sql
ATTACH 'https://dbquacks.com/data/databases/motherduck_tutorial.duckdb' AS db (READ_ONLY);
USE db;
```

This level also queries MotherDuck shares, which need a MotherDuck token. On the page, the editor asks for one.

Play it in the browser: https://dbquacks.com/motherduck/1

## Reference

https://motherduck.com/docs/key-tasks/database-operations