Table of Contents
Preface
1
An Introduction to DuckDB
Technical requirements
What is DuckDB?
Why use DuckDB?
DuckDB use cases
DuckDB features
When is DuckDB not the right tool?
DuckDB deployment options and installation
DuckDB deployment options
Installing the DuckDB CLI
Starting the DuckDB CLI
Working with the DuckDB CLI
A short SQL primer
Creating your first DuckDB table
Running your first DuckDB query
Summary
2
Loading Data into DuckDB
Technical requirements
Loading CSV files
The COPY statement
COPY statement options
Error handling with CSV reading
File loading with read_csv
Table creation with read_csv
Date formats
When to use COPY versus read_csv
Loading multiple files
Mixed schemas
Loading JSON files
JSON Lines – Newline Delimited JSON ...
Get Getting Started with DuckDB now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
