How dlt Loads Nested JSON into Tables in DuckDB
Learn how dlt normalizes nested JSON into parent and child tables in DuckDB using a simple students and courses example.
DuckDB
This page contains hands-on DuckDB tutorials. DuckDB is an open-source, in-process SQL database optimized for fast analytical queries and ideal for local data analysis and processing. It integrates seamlessly with tools like Python or dbt for efficient analytics workflows.
14 posts
Streamlit + DuckDB: Build Interactive Data Apps That Read and Write to a DuckDB Database
Build a simple Streamlit task tracker that reads from DuckDB, writes new rows, updates task status, and validates the result with SQL.
When to Use replace, append, or merge in a dlt Pipeline
Learn when to use replace, append, or merge in a dlt pipeline with practical DuckDB examples and beginner-friendly explanations.
How to Load JSON Data into DuckDB using dlt
Learn how to load a local JSON file into DuckDB with dlt, inspect the result with SQL, and understand a simple data pipeline pattern.
How to Load CSV Data into DuckDB using dlt
Learn how to load a local CSV file into DuckDB with dlt, inspect the result with SQL, and understand the basic pipeline pattern.
How to Load API Data into DuckDB with dlt
📘 Introduction In this hands-on tutorial, you will learn how to load data from a REST API into DuckDB using dlt. This is a great first local data pipeline because you do not need a cloud warehouse, a complex setup, or production credentials. We will use dlt to fetch data...
Load Data from a JSON File into DuckDB using Python
📘 Introduction Working with structured data is a core part of any data engineering or analytics workflow. DuckDB, often called the SQLite for analytics, makes it incredibly easy to query local data files—including JSON—without requiring a complex setup. In this tutorial, you’ll learn how to load JSON data...
Load Data from a Parquet File into DuckDB using Python
📘 Introduction In this tutorial, you’ll learn how to load data from a Parquet file into a DuckDB database using Python. DuckDB’s native Parquet support makes it fast and efficient to work with columnar data, making it ideal for analytics, ETL pipelines, and Python data projects. You’ll see...
Insert Data from a CSV File into DuckDB using Python
📘 Introduction In this tutorial, you will learn how to insert data from a CSV file into a DuckDB database using Python. DuckDB is a powerful in-process analytical database that makes working with structured data fast, simple, and efficient—perfect for data projects, notebooks, and local analytics. ✅ Prerequisites Before you...