THE CLOUD EXPEDITION! · Chapter 1
To Infinity and Be-Pond
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 its time you met MotherDuck — the ENTIRE WORLD at your wingtips! Your first step: Connect to MotherDuck and verify your cloud connection is live.
Your 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 |
Database: https://dbquacks.com/data/databases/motherduck_tutorial.duckdb
This page as markdown: https://dbquacks.com/motherduck/1.md