THE CLOUD EXPEDITION! · Chapter 2
X Marks the Schema
Captain Cloudsworth pulls out a magnifying glass and peers at the cloud databases. Weve connected, weve queried — but what ELSE is hiding in there? Tables we havent seen, columns we havent explored! He flips open a dusty ledger. Before we go deeper, we need the full map. Time to master Catalog Exploration — using DESCRIBE and information_schema to navigate unfamiliar cloud databases.
Your task
Reveal the column structure of `dbquacks_cloud_expedition.global_migrations` — what columns does it have, and what are their types? Table: `dbquacks_cloud_expedition.global_migrations` (MotherDuck).
Hint
Use DESCRIBE on the table to reveal its column names, types, and nullability
Expected result
Column definitions for global_migrations showing column_name, column_type, null, key, default, and extra
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 |
dbquacks_cloud_expedition.global_migrations
A table in a MotherDuck share; its columns are not listed here.
Database: https://dbquacks.com/data/databases/motherduck_tutorial.duckdb
This page as markdown: https://dbquacks.com/motherduck/4.md