DB Quacks SQL Tutorial · Chapter 3
The Duck Hunt: CSV Edition
Professor Shellbert paddles over with files. Great news! Neighboring communities want to contribute to our festival by sharing food preference data, but they use different systems. We can read their CSV files directly without importing!
Your task
Read and display the contents of the external CSV file 'data/duck_foods.csv'. You will be working with an external file containing food preference data from neighboring communities.
Hint
Look for a function that can read CSV files directly without importing them into the database.
Expected result
A table showing all data from the duck_foods.csv file.
Tables
duck_diaries (10 rows)
| column | type |
|---|---|
diary_id | BIGINT |
duck_id | BIGINT |
entry_date | DATE |
diary_text | VARCHAR |
mood | VARCHAR |
duck_surveys (5000 rows)
| column | type |
|---|---|
survey_id | BIGINT |
duck_id | BIGINT |
age | BIGINT |
favorite_food | VARCHAR |
favorite_pond | BIGINT |
swimming_rating | BIGINT |
migration_preference | VARCHAR |
social_behavior | VARCHAR |
health_status | VARCHAR |
activity_level | VARCHAR |
survey_date | DATE |
survey_location | BIGINT |
ducks (15 rows)
| column | type |
|---|---|
id | BIGINT |
name | VARCHAR |
age | BIGINT |
species | VARCHAR |
birth_date | DATE |
arrival_date | DATE |
ponds (3 rows)
| column | type |
|---|---|
pond_id | BIGINT |
pond_name | VARCHAR |
location_lat | DOUBLE |
location_lng | DOUBLE |
capacity | BIGINT |
features | VARCHAR[] |
amenities | VARCHAR[] |
Files
data/duck_foods.csv (15 rows)
| column | type |
|---|---|
duck_id | BIGINT |
favorite_food | VARCHAR |
allergies | VARCHAR |
diet_type | VARCHAR |
Database: https://dbquacks.com/data/databases/tutorial.duckdb
This page as markdown: https://dbquacks.com/tutorial/14.md