Skip to main content
DuckDB Logo

​
Task 1 Overview: Ad-hoc and Batch Analytics with DuckDB

In this task, you’ll learn how to process and analyze historical data using DuckDB, a modern analytical database designed for OLAP workloads. You’ll work with a mix of real and synthetic data.

​
Learning Objectives

  • Install and configure DuckDB for batch processing
  • Query and explore CSV data files
  • Query and explore JSON data files
  • Perform geospatial analytics
  • Create a data lakehouse with DuckLake, a new open standard built on object storage and PostgreSQL

​
DuckDB Installation and Setup

​
Install DuckDB

First, we need to install DuckDB to our Codespaces. DuckDB runs almost anywhere and it’s very easy to install.
Visit the DuckDB installation page for Linux installation instructions.For Codespaces, you can typically install it using:
curl https://install.duckdb.org | sh

​
Verify Installation

Test that DuckDB is working correctly: 
duckdb --version
You should see the DuckDB version information.

​
Adjust max columns

DuckDB has a default limit of 1000 columns. Let’s increase it to 10000. 
.maxcolumns 10000
⌘I